Free Support Forum - aspose.com

Problem with reading CSV files in version 4.4.1

We are using 4.4.1 and
are encountering a similar problem when trying to read from a .csv
file. Here’s an example of the problem. It’s a very simple file that
demonstrates the problem.

Here’s the data of the csv file:
A
L1
"L2
X"
“L3

X"

It produces this output when viewed in the immediate window in Visual Studio:
workSheet.Cells[1, 0].Value
"L1"
workSheet.Cells[2, 0].Value
"L2\nX"
workSheet.Cells[3, 0].Value
”“L3\n"
workSheet.Cells[4, 0].Value
"X”"

It appears to be treating the extra newline between the quotes as a new row.

Thanks,
Scott Slaten