opening a tabdelimeted file as an excel using aspose

Last post 11-19-2008, 12:12 PM by nausherwan.aslam. 3 replies.
Sort Posts: Previous Next
  •  11-19-2008, 10:38 AM 153278

    opening a tabdelimeted file as an excel using aspose

    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
     
  •  11-19-2008, 10:59 AM 153286 in reply to 153278

    Re: opening a tabdelimeted file as an excel using aspose

    Hi,

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

    Thank you.


    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  11-19-2008, 11:51 AM 153293 in reply to 153286

    Re: opening a tabdelimeted file as an excel using aspose

    Attachment: Present (inaccessible)

    Hi,

     

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

     
  •  11-19-2008, 12:12 PM 153296 in reply to 153293

    Re: opening a tabdelimeted file as an excel using aspose

    Attachment: Present (inaccessible)

    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,


    Nausherwan Aslam
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
View as RSS news feed in XML