LightweightExcelReader

LightweightExcelReader copied to clipboard

If you try to read an Excel which has some columns in format TIME or CUSTOM (hh:mm:ss), it throws an exception: "oleaut the date is not valid". The exception: ```...

polvolcano

Added a possibility to dispose all active streams with ExcelReader.Dispose()

2

Added a possibility to dispose all active streams of the excel-file by using ExcelReader.Dispose(). This enables to edit a excel-file after it was read by the LightweightExcelReader.

Shiraiku

I receive the above when referencing some cells. I believe through elimination that it's where a cell sits beneath a hidden row or there are merged cells in the worksheet....

Nathan9399

Have you tried to read a table with millions of rows？

wangshagouy

Not disposing underlying resources

1

The `ExcelReader` creates streams, like `ZippedXlsxFile`, but it never disposes them.

kikaragyozov

e.g. `public IReadOnlyList SheetNames => _sheetnameLookup.Keys.ToList();` And

Smurf-IV

It should use `MaxRow`, e,g, like below:

Smurf-IV