This project has moved. For the latest updates, please go here.

Disable auto formating creating a Excel file

Jan 30, 2016 at 12:12 PM

I have a problem that some values look like dates ("12-01-00-06") and the api is converting them to custom date time format and messes the data up.

I have tried this:
worksheet.Cell("A2").DataType = XLCellValues.Text;

but this doesn't help and in debugger I see that after I assign the value then te dataType is set to DateTime.

How can I disable auto formattingfrom my sheet and show values as they are.
In Excel I also see that that the format is set to custom dateTime.