Importing CSV with a blank column name causes unhandeled exeception

Aspose.Cells Product Family
1

Hi,

I have noticed that when importing a CSV file that contains a blank column name in Row one to a datatable, it throws an exception when exporting it as DataTable. "Inpurt string was not of the correct format."

DataTable dt = wrksheet.Cells.ExportDataTable(0,0,NoRows,wrksheet.Cells.MaxColumn + 1,true);

If I do not use the true argument it exports fine, but the first row of course will be my column names.

Thanks.

2

Hi,

Thank you for considering Aspose.

Well, I have tested you issue using the latest Aspose.Cells version and I was unable to re-produce the issue. Please try the attached latest fix of Aspose.Cells. If you still face a problem please share your template file and we will figure it out soon.

Thank you & Best Regards,