Issue with cell's format

[sergiogm]

Hi!

I was generating my excel when I see a different data in my "hours" columns.
I save the hours in my database as "00:00", but excel write it like "00/00/000 00:00".
I try to force "worksheet.range[range].NumberFormat" = "@";" but it doesn't work.
Can someone help me?

[Jane.Bai]

Hello,

Thanks for your inquiry.
What is the data type of the data “00:00” in your database, is it DateTime or "String"? Theoretically, if the data type is DateTime, Spire.XLS would parse the hour to the default DateTime format.
If you want to get the result“00:00", we suggest that you change the data type to string instead.

Sincerely,
Jane
E-iceblue support team

[Jane.Bai]

Hello,

Greetings from e-iceblue!
How is the issue now?
Your feedback would be greatly appreciated!

Sincerely,
Jane
E-iceblue support team