officedev / excel-io Goto Github PK

If the 'cell.DataType.Value' is null, the program will be throw the error of Object null reference. Burt the cell value just is empty in excel.

As I don't have much experience, I'll leave here images of code I've done and that certainly could be improved upon on things that I had to implement to create an azure storage table exporter and importer to excel that I'm working on:

In this ExcelConverter.cs method I've added CellReference with this quick fix workaround and to cells as well:

To support dates I've done:

Then I changed GetCellValue to convert DateTime? values present on azure storage table

and in ReadSheet I checked for type names that contain data to parse the string to appropriate type

As for my suggestion: This would be great in a Nuget package