Defining cell as date in spreadsheet

[Fenella Martinez]

How can I set the cell in the worksheet as a date? Using setValue seems to define it as a string, which makes it hard for sorting in Excel.

[Melba Winshia]

Hi Fenella,

Thanks for your interest in Essential XlsIO.

You can set the cell in the worksheet as Date by using Value property. Please refer the following code snippet to achieve this:

//Inserting Date into the first worksheet
sheet.Range["A1"].Value = "12/05/2005";
sheet.Range["A2"].Value = "11/05/2005";

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F60933/main.htm

Kindly let me know if you have any other questions.

Thanks,
Melba

[Anonymous]

also you can use
DateTime value = DateTime.Now

sheet.Range[ "A1" ].DateTime = value;
sheet.Range[ "A2" ].Value2 = value;

or

sheet.Range[ "A1" ].Number = 100;
sheet.Range[ "A1" ].NumberFormat = "mm dd yyyy";// or any other date format

[Melba Winshia]

Hi,

Yes, you can also use DateTime and Value2 property to set the cell in the worksheet as Date.

Kindly let me know if you have any other questions.

Thanks,
Melba