Excel found unreadable content in generated XLSX file

Last post 02-13-2012, 3:45 AM by aspose.notifier. 9 replies.
Sort Posts: Previous Next
  •  02-08-2012, 11:09 AM 360131

    Excel found unreadable content in generated XLSX file .NET

    Attachment: Present (inaccessible)
    Hi -- I am trying convert HTML to XLS. Aspose generates the file....but getting this error when I try to open in Excel.

    Details:
    1. My HTML have <th> elements that causes this error.
    2. Generates fine, but only opening in the Excel throws this error.
    Enclosed the full working code to duplicate the issue. Please let me know.

    Thanks.


     
  •  02-08-2012, 12:25 PM 360162 in reply to 360131

    Re: Excel found unreadable content in generated XLSX file

    Hi,

    You are converting conventional/common HTML to XLS, which might not be fully supported (some tags might not be supported completely) as the product does support to read/write MS Excel oriented html files (the html files you may make in MS Excel).

    Anyways, I checked your issue a bit, I think it works fine with latest version v7.1.0.5.

    Please download and try this fix: Aspose.Cells for .NET v7.1.0.5

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  02-08-2012, 1:03 PM 360174 in reply to 360162

    Re: Excel found unreadable content in generated XLSX file

    Yes...it works...but it does not add the TH columns in the generated Excel file. Thanks.
     
  •  02-08-2012, 1:28 PM 360183 in reply to 360174

    Re: Excel found unreadable content in generated XLSX file

    Hi,

    Yes, I noticed the TH tag is not working, the tag might not be supported, I have logged it into your existing issue: CELLSNET-40356. We will also look into it soon.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  02-08-2012, 2:49 PM 360200 in reply to 360183

    Re: Excel found unreadable content in generated XLSX file

    Thanks Amjad. Is there are a place where I can see what tags are supported by the current version? Thanks again.
     
  •  02-08-2012, 9:02 PM 360220 in reply to 360200

    Re: Excel found unreadable content in generated XLSX file

    Hi,

    a) The issue of a partial HTML snippet:

    If there is not html header in the file, we could simply process the file as a html file. So please set the load format when you call  new Workbook().

    See following code:
    LoadOptions loadOptions = new LoadOptions(LoadFormat.Html);
    Workbook workbook = new Workbook(stream,loadOptions);

    b) The issue of Th,

    We will try to support this tag.


    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  02-08-2012, 9:21 PM 360221 in reply to 360220

    Re: Excel found unreadable content in generated XLSX file

    Thanks!

    Yes, LoadOptions takes care of the partial issue and what we left out is TH tag support.
     
  •  02-10-2012, 3:16 AM 360594 in reply to 360131

    Re: Excel found unreadable content in generated XLSX file

    Hi,

    We have fixed this issue. Please download and try this fix: Aspose.Cells for .NET v7.1.0.6

    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  02-10-2012, 8:45 AM 360738 in reply to 360594

    Re: Excel found unreadable content in generated XLSX file

    Works....great!! Thx.
     
  •  02-13-2012, 3:45 AM 360999 in reply to 360131

    Re: Excel found unreadable content in generated XLSX file

    The issues you have found earlier (filed as CELLSNET-40356) have been fixed in this update.


    This message was posted using Notification2Forum from Downloads module by aspose.notifier.
     
View as RSS news feed in XML