How to set the column format

[dfense]

Hello!

How can i set the excel column format? For example from default to datetime, or specific datetime format: "dd.mm.yyyy hh:mm".

Thanks

[Flash]

Hello,

Thank you for your inquiry.
Please try to use following code to set column format.

Code: Select all

          sheet.Range["A1"].DateTimeValue = DateTime.Now;
          sheet.Columns[0].NumberFormat = "dd.mm.yyyy hh:mm";

Please let me know if you have any questions and concerns.

Best Regards.

[dfense]

Great! It works very well. Thank you for support.

Best wishes.