Free Support Forum - aspose.com

Csv file issue in reading

Hi ,

Help Me, when i trying to read the CSV using the Aspose.cell DLL Execption is thrown "Input string was not in a correct format." This issue come in the Below Sutivation.

Separate : ^ , But in the File data we have ","

Example

Name^Class^Sec

N^12^A,B

A^12,10^A

Thanks & Regards,

Naveen T

Hi Naveen,

Thank you for considering Aspose.

I tested your issue with the attached latest version and sample code below and it works fine. You may try using the below mentioned overloaded method of Workbook.Open() as per your requirement.

//Create a Workbook.

Workbook workbook = new Workbook();

//Open a file into the first book.

workbook.Open(@"C:\new.csv",'^');

workbook.Save(@"C:\input.xls", FileFormatType.Excel2003);

Thank You & Best Regards,

Hi,

I am getting the error while opening the file itself..

//Create a Workbook.<?XML:NAMESPACE PREFIX = O />

Workbook workbook = new Workbook();

//Open a file into the first book.

workbook.Open(@"C:\new.csv",'^'); ----> I am getting error while opening..

workbook.Save(@"C:\input.xls", FileFormatType.Excel2003);

Thanks & Regards,

Naveen T

Hi Naveen,

Thank you for considering Aspose.

Did you try the latest version I attached in my previous post? If you are facing the issue with the latest version, please share your template file and we will check it soon.

Thank You & Best Regards,