Date format?

[DanteNahuel]

When the worksheet is readed, the cells formated as complete Dates return an odd number (43115.47584490741 e.g) and are of String type.
How do I convert these into dates?

[ivcubr]

@DanteNahuel What is the format of the cell you are trying to read?

Can you post a sample Excel document and your code that is reading that cell?

[linkosoft]

I'm having the same problem

var worksheet1 = fastExcel.Read(1);
FastExcel.CellRange cellRange = new FastExcel.CellRange("A", "BB");
var cells = worksheet1.GetCellsInRange(cellRange);
var cellValue= cells.FirstOrDefault(x => x.RowNumber == 1 && x.ColumnNumber == 1).Value;
var date = Convert.ToDateTime(cellValue);

[skycloudnest]

same problem

[rstm-sf]

This SO may help you. I think that additional processing should be added to this library.

[ahmedwalid05]

Opened a new issue for this #58.