How to read cell containg date?

[TiliSleepStealer]

First of all, thank you for this wonderful library. It really is exactly what I wanted: Small, lightweight and just works.

My question is how to read a cell containing a date. when I try cell.Value.Tostring it returns me a number for some reason. And I am not sure how to convert this back to a System.DateTime

[rabanti-github]

Hello and thank you :-)

The answer is quite easy, but maybe not that obvious:

            Workbook workbook = new Workbook("test.xlsx", "Sheet1"); 
            workbook.CurrentWorksheet.AddNextCell(DateTime.Now);        // Add cell A1
            workbook.Save();
            Workbook workbook2 = Workbook.Load("test.xlsx");
            DateTime date = (DateTime)workbook2.CurrentWorksheet.Cells["A1"].Value;

So, it is just casting. You also find out, what type a cell has, by using the property Cell.DataType

Please let me know, if there are any other question.

[rabanti-github]

By the way, if yo are already using a release candidate of version 3 (will be released end of January or February), the reading of workbooks changed:

 using NanoXLSX.Extensions;

 Workbook workbook = WorkbookReader.Load("path_to_file.xlsx");
 Workbook workbook = WorkbookReader.Load("path_to_file.xlsx", new ReaderOptions(){ DateTimeFormat = "yyyy.MM.dd hh:mm:ss" }); // Using options
 Workbook workbook = WorkbookReader.Load(stream); // Using a stream
 Workbook workbook = await WorkbookReader.LoadAsync("path_to_file.xlsx"); // Using async method