Excel-IO icon indicating copy to clipboard operation
Excel-IO copied to clipboard

The Judgment conditions are not sufficient.

Open EthanAnro opened this issue 4 years ago • 3 comments

image 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.

EthanAnro avatar Apr 22 '21 08:04 EthanAnro

May you check and give some opinions? Thanks a lot.

EthanAnro avatar Apr 22 '21 08:04 EthanAnro

By the looks of what you are saying this condition (GetCellValue Null Check) wasn't triggered due to the fact that cell.DataType.Value is null but cell.DataType isn't.

I say this because, if cell.DataType was indeed null it would enter that null check condition and return a value before reaching that cell.DataType.Value switch.

JoaoDinisCodit avatar Apr 27 '21 01:04 JoaoDinisCodit

Hello!

I was wondering if you have an example of code of this library...about filters... if you want to filter an existing excel by a column (eg: "gender") then copy the sheet excel (with that column filtered).

Does this library have that function?

Thank u, Regards,

AntonellaSM avatar Dec 23 '21 17:12 AntonellaSM