We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Importing CSV with a blank column name causes unhandeled exeception


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.


Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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,