MarkPflug / Sylvan.Data.Excel

The fastest .NET library for reading Excel data files.
MIT License
243 stars 30 forks source link

Not read all the cells in row. #157

Closed equaerdist closed 8 months ago

equaerdist commented 8 months ago

I dont think that it's should be work like that. When i read xlsx file< and then get irteration over the row like this: var i=0; i < ed.FieldCounts;... var value = ed.GetString(I); It doesnt read all the cells. My doc contains much empty cells in the row, but this structure set in the start level of the project and can not be remade. Closed xml read it properly.

MarkPflug commented 8 months ago

Instead of: ed.FieldCount, use ed.RowFieldCount instead.