I have a 3rd party CSV file I´d like to process using MiniExcel.
0,"V","4000","6","26",10000001,"Test123" ,"220626",,1001200,,,5769.00 ,N,"EUR",,,,,,, ,,,,, , ,,,,,,,,,,,,0,
1,"V","4000","" ,"26",10000001,"Test457" ,"220626",, ,,,5769.00 , ,"" ,,,,,,,0.00 ,,,,,"","",,,,
0,"V","4000","6","26",10000002,"Test789" ,"220626",,1104500,,,26550.00 ,N,"EUR",,,,,,, ,,,,, , ,,,,,,,,,,,,7,
1,"V","4000","" ,"26",10000002,"Test11X" ,"220626",, ,,,26550.00 , ,"" ,,,,,,,0.00 ,,,,,"","",,,,
Have an option to specify a value for missing values or have a possibility to somehow process the file.
An Exception is throws that prevents processing.
Description
I have a 3rd party CSV file I´d like to process using MiniExcel.
I use:
The "ToList()" crashes for me with
Csv read error: Column 32 not found in Row 2" | MiniExcelLibs.Exceptions.ExcelColumnNotFoundExceptionExpected Behavior
Have an option to specify a value for missing values or have a possibility to somehow process the file.
Actual Behavior
An Exception is throws that prevents processing.
Workarounds
none known
Environment (please fill the following information):
example.csv