Cell MaxCol and Null value
Brought to you by:
superaso
There is a problem in Cells.MaxCol value,
if the excel sheet have multiple empty cells the Cell.MaxCol value is equal to the number of non empty cell and not equal to the total number of cell.
I don't know if it is a bug or a feature but previous version count empty cells in MaxCol
I have patched it in my checkout :
In Worksheet constructor :
if Cell is MultipleColCellRecord
add cell to currentRow.Cells if val is null
Excel Worksheet pathced