Cell format to date

[IceVanis]

Hello,

I'm having some issues while trying to set a cell to a custom format ( "yyyy/mm/dd hh:mm:ss" )

This is what I tried so far but to no avail:

Code: Select all

sheetOne["A2"].NumberFormat = "yyyy/mm/dd hh:mm:ss"
sheetOne.Range[2,1].NumberFormat = "yyyy/mm/dd hh:mm:ss"
sheetOne["A2"].NumberFormat = "yyyy.mm.dd hh:mm:ss"

I'll keep trying, but in the meantime maybe you guys can help me with the solution!

Thank you!

[Triste.Dai]

Hi,

Thanks for your inquiry.
You can use the following code to meet your requirement.

Code: Select all

            Workbook wb = new Workbook();
            Worksheet ws = wb.Worksheets[0];
            ws.Range["C10"].DateTimeValue = new DateTime(2023, 1, 6);
            ws.Range["C10"].NumberFormat = "yyyy/MM/dd HH:mm:ss";
            wb.SaveToFile("output.xlsx", ExcelVersion.Version2013);

In addition, yyyy: year, MM: month, dd: day, HH: hour, mm: minute, ss: second.
If you have any further questions, just feel free to contact us.

Sincerely,
Triste
E-iceblue support team