Opening a tabdelimeted file as an excel using aspose

Aspose.Cells Product Family
1

Hi,

Our application is trying to open a tab delimited file as an excel for parsing throw the rows. When it is trying to open a tabdelimited file using

wBook.Open(inputFile.FilePath, FileFormatType.TabDelimited);

it throws the following error

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
at System.Double.Parse(String s)
at Aspose.Cells.?.?(String ?, Boolean ?)
at Aspose.Cells.RW.?.?(StringBuilder ?, Boolean ?)
at Aspose.Cells.RW.?.?(StreamReader ?, Cells ?, Char ?, Boolean ?)
at Aspose.Cells.RW.?.?(String ?, Cells ?, Char ?, Boolean ?)
at Aspose.Cells.Workbook.Open(String fileName, FileFormatType type)
at GEMS.FileHandling.ExcelParser.IsExcelValid(FileDetails inputFile, DataTable dtColumnDetails) in C:\Inetpub\wwwroot\GEMSHub\FileDetectionAndHandlingComponent\GenericParser\ExcelParser.cs:line 245

any help in this regrad is very much appreciated.

Thanks,

ramjee

This message was posted using Page2Forum from Aspose.Cells for .NET and Java - Documentation
2

Hi,

Could you post your template file here, we will check your issue soon.

Thank you.

3

Hi,

thanks for your response. Please find attached template file with a record, which fails opening.

4

Hi,

Thank you for Considering Aspose,

Well, I used your provided template file to open as Tab Delimited and it worked fine with Aspose.Cells Latest Version. The issue may be occurring due to the use of some older version of Aspose.Cells. Please try the attached latest version of Aspose.Cells.

Also I have saved your Tab Delimited file as Ms Excel .xls after opening it and the resultant file is also attached.

Thank you & Best Regards,