CSV not being read correctly

Aspose.Cells Product Family
1

I am trying to import a csv file into a Workbook object and the result is not correct…only the last line of data is showing up in the resulting Worksheet. I suspect the problem may be that there are a different number of columns in the first row as the rest of the rows. Excel 2003 treats this situation fine.

I have attached the workbook. My code to open it is:

Workbook wb = new Workbook();
wb.Open(@“c:\csv2.csv”);

2

Hi Mike,

Thank you for considering Aspose.

Well, we checked your template CSV file and it is not a Standard CSV file (its Unicode text file). You may check it by opening the file in Excel and “Save As” the file and check “Save As Type”. You can save the file as CSV using MS Excel and then try to open the file using Aspose.Cells.

Thank You & Best Regards,

3

Hi,

We found there is an issue in opening your file, we will fix it soon.

Thank you.

4

Hi Mike,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells foe .NET. We have fixed your mentioned issue.

Thank You & Best Regards,

5

That fixed the problem.

Thanks,
Mike

6

The issues you have found earlier (filed as 12748) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.