c# - I would like a DateTime to be shown as a proper Date, but in the Gembox options I could not find a option to set the format to Date -

i'm using external component called gembox creating excel reports.

when exporting property that's datetime in c# towards excel value in excel shown number (for instance '-693593'). other (basic) property types displayed type represent.

in excel datetime shown proper date, in gembox options not find option set format date.

alternative option convert datetime .tostring() while setting value in excel, gives desired result there better way of doing so?

some simplyfied code example:

excelfile excelfile = new excelfile(); excelworksheet excelworksheet = excelfile.worksheets.add("myworksheet");  int rownumber = 0; int columnnumber = 2; datetime datetime = datetime.now;  excelworksheet.cells[rownumber, columnnumber].value = datetime; 

example of output:

format excel cell display date time in excel itself,

excelfile excelfile = new excelfile(); excelworksheet excelworksheet = excelfile.worksheets.add("myworksheet");  int rownumber = 0; int columnnumber = 2; datetime datetime = datetime.now;  microsoft.office.interop.excel.range range = excelworksheet.cells[rownumber, columnnumber] range; range.numberformat = "dd/mmm/yyyy"; range.value2 = datetime; 

this set excel cell date format.

in line range.numberformat = "dd/mmm/yyyy"; can give of format below:

dd/mm/yy         // 01/01/01 dd/mmm/yy         // 01/jan/01 ddd/mmm/yyyy      // mon/jan/2001 ddd dd/mmm/yyyy   // mon 01/jan/2001 hh:mm:ss          // 01:01:01  - 24 hour hh:mm:ss am/pm    // 01:01:01 pm - 12 hour  format below used .net format only, not work excel. hh:mm:ss          // 01:01:01  - 24 hour hh:mm:ss t        // 01:01:01 pm - 12 hour hh:mm:ss.fff      // 01:01:01.123  - 24 hour millisecond   or combination of both date , time; ddd dd/mmm/yyyy hh:mm:ss