If one of the excel columns is empty, then all the values get overlapped

[WeihanLi]

If one of the excel columns is empty, then all the values get overlapped, this happens when using this :

var entityList = ExcelHelper.ToEntityList<T>(string excelPath);

I tried using what i thought were column mappers

setting.Property(_ => _.DisplayName)
    .HasColumnTitle("设置显示名称")
    .HasColumnIndex(2);

but this proved to be innecfective.

So, whenever i have excel columns which are empty, I fill them with 1 blank space so the values are not overlapped when they are read by your excelhelper.

[rcuzco]

I really hope you can find a solution.
Thanks a lot for your time!

[WeihanLi]

Hi @rcuzco , bug fixed in #5
you can update to v1.0.6 to solve the bug,if you have any problem, contact me whenever you need.

[ssanga]

Now works nice, many thanks WeihanLi

[WeihanLi]

Thanks for your feedback.