I have the following CSV file:
Sample1
Row1Col1,“This should be,
in a single cell,
but is broken up into seperate lines”, Row1Col3
Row2Col1,Row2Col2,Row2Col3
Note that the text “This should be, in a single cell, but is broken up into seperate lines” is broken over 3 rows. But in theory I only have 2 row in my CSV file as the text is delimited. When opening this file with Aspose I expect the following structure:
Sample2
Row1Col1,“This should be…”, Row1Col3I however get the structure of Sample1 (4 rows). Am I missing something. Is there API functionality that allows me to achieve this? When opening the CSV file with MS Excel and Open Office I get Sample2’s structure.
Row2Col1,Row2Col2,Row2Col3
I am using the worksheet.Cells.ExportDataTableAsString() method.