I have the following csv file:
OrderNo,OrderDate,PromiseDate,DivisionNo,CustomerNo,SalesorderDate,BillToName,BillToAddress1,BillToAddress2,
16839,1/10/2018,,DIV,CUST,,,,,,,,,,EU Distributor,Viale Della Vittoria,22-33033 Codroipo,,Udine,,,IT,,, ? ?,,,,,,0,0,KMU191,,1872,3.99,CS-12
I'm having trouble parsing when I use the open method:
xls.Open(xlsFilename, TFileFormats.Text, ',', 1,1,nil);
seems the Flexcel open method with FileFomat.text is skipping the comma delimitter if the cell value is blank. for example the 3rd column(PromiseDate) is empty but when I'm accessing the cellvalue I get the next column value: DIV.
Is there any other method with Flexcel to open a CSV file correctly?