In my excel, i selected a cell and that cell i set a format like date,“Wednesday, March 14, 2012”, in Format Cells.
In my code:
where datetimeValue is System.Datetime.
The value of cell.StringValue is not the format that i set in the excel but is the same date of datetimeValue . And the autoFitColumn function calculated the width seems using cell.StringValue.
As a result when i open the excel, the value is correct but the width is too narrow to shown the whole format and become ######.
My Question is how could i handle it?