Hi everyone !
I need to import a CSV file. So to extract data, I’m using Aspose and I define my separator as “,” :
image.png (5.7 KB)
(“LoadWorkBook” methods just instanciates and returns a new workbook with the file at “alertPath” using options “loadOptions”)
My problem is that my CSV file contains sometimes in some cells the “,” character, and if so, the whole cell value is between double quotes ("). When extracting data with Aspose as I do in code above, the double quotes don’t “protect” the text, and I’ve go one new column per “,”…
In excel, when you go to Data -> Convert -> Delimited you’ve got an option called “Text identifier”, and that’s exactly what I need. Can I do that sort of thing in Aspose ?
I hope i’m clear ! Thanks