Excel found unreadable content in 'file.xlsx'

Last post 09-16-2010, 6:14 AM by aspose.notifier. 14 replies.
Sort Posts: Previous Next
  •  08-25-2010, 3:29 PM 255655

    Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)
    I am getting this error whenever I attempt to do anything with a file.  I have simplified my code to the point where all it does is open the file, then save it (no operations in between), and I always get this error.  I'm using version 5.1.2.

    Attached are the following files:

    error.jpg - screenshot of the message excel throws
    primary.xlsx - the file that I'm opening
    primary_output.xlsx - the file after I open it and save it using ASPOSE.Net

    Here is the code that produces the error

       Dim lo As New LoadOptions(LoadFormat.Auto)
            Dim wb As New Workbook("d:\code\NationalParks\Output\1\Primary.xlsx", lo)
            
            Response.Clear()
            Response.AddHeader("Content-Type", "application/vnd.ms-excel; charset=windows-1251")
            Response.AddHeader("content-disposition", "attachment; filename=""" & "test.xlsx" & """")
            Dim ms As New IO.MemoryStream
            wb.Save(ms, SaveFormat.Xlsx)

            Response.BinaryWrite(ms.ToArray())
            Response.End()
     
  •  08-25-2010, 3:56 PM 255659 in reply to 255655

    Re: Excel found unreadable content in 'file.xlsx'

    Hi,

    Thanks for the template files.

    I have found the issue after an initial test, we will figure it out soon.

    I have logged your issue into our issue tracking system with an id: CELLSNET-19585.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  08-30-2010, 9:59 AM 256160 in reply to 255659

    Re: Excel found unreadable content in 'file.xlsx'

    Any progress on this? 

    Can you also look into the following issue with the same file:

    I cannot set any formulae in the worksheets.

    If I add the following line of code

    wb.worksheets(5).cells("B4").formula="=9+1"

    No formula is set (and it makes no difference what the formula is.

    Thank you - I'm about to put in a PR for ASP.net total, but can't very well do it if it doesn't work.

     
  •  08-30-2010, 11:23 AM 256177 in reply to 256160

    Re: Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)

    Hi Christopher,

    We are in process of fixing the issue. We will update you as soon as it is fixed.

    Set formula is working fine. Please find the attached screen shot. We have used the template file which you had provided.

    wb.worksheets(5).cells("B4").formula="=9+1"
    The code line above produce the required results which can be seen in the attached screen shot.

    Thanks,


    Sincere Regards,

    Salman Shakeel
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  08-30-2010, 11:31 AM 256181 in reply to 256177

    Re: Excel found unreadable content in 'file.xlsx'

    Sorry - I forgot which template you had...try doing set formula on column C rather than B.
     
  •  08-31-2010, 1:54 AM 256285 in reply to 256181

    Re: Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)
    Hi,

    We have checked thoroughly your sample file, if you could open your template file "Primary.xlsx" into MS Excel 2007 file, it also produces the same error "Excel found unreadable content....". So, it is not an issue of Aspose.Cells. To confirm it, you may open your sample file into MS Excel and then re-save the file. Now use Aspose.Cells to open, set formulas etc. and save the file. If you open the generated file into MS Excel 2007, it won't give you any error.

    I am using the following sample code with the attached version/fix (latest):
       LoadOptions lo = new LoadOptions(LoadFormat.Auto);
                Workbook wb = new Workbook("e:\\test\\Resaved_Primary.xlsx", lo);
                wb.Worksheets[5].Cells["C4"].Formula = "=9+1";
                wb.Save("e:\\test\\outPrimary.xlsx");


    If you still find any issue, kindly post your correct file here, we will check it soon.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  08-31-2010, 12:29 PM 256420 in reply to 256285

    Re: Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)

    OK - I have a new final template file, and I'm getting the unreadable content error.  Also, I went back and opened the template you said generated the error in Excel 2007 in Excel 2007 and I did NOT get the error.

    In any case - this is the final template, and I am getting the error - unreadable content.  Please advise.

     
  •  08-31-2010, 2:00 PM 256442 in reply to 256420

    Re: Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)
    Hi,

    I open your attached template file in MS Excel 2007 and I can get the same error, see the attached screen shot.


    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  08-31-2010, 2:05 PM 256445 in reply to 256442

    Re: Excel found unreadable content in 'file.xlsx'

    I don't get that...at all.  I only get it after generating the file with aspose.  Also - if I open it and save it (as you suggested in the past), I continue to get the error.

     

     
  •  09-01-2010, 12:47 AM 256487 in reply to 256445

    Re: Excel found unreadable content in 'file.xlsx'

    Hi,

    Kindly give us details which MS Excel version you are using?

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  09-01-2010, 11:07 AM 256614 in reply to 256487

    Re: Excel found unreadable content in 'file.xlsx'

    Microsoft Office Excel 2007 (12.0.6535.5002) SP2 MSO (12.0.6535.5002)
     
  •  09-01-2010, 1:09 PM 256649 in reply to 256614

    Re: Excel found unreadable content in 'file.xlsx'

    Hi,

    Thanks for giving info about your MS Excel version. We will further look into your issue soon.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  09-02-2010, 8:09 AM 256824 in reply to 256649

    Re: Excel found unreadable content in 'file.xlsx'

    Attachment: Present (inaccessible)

    Hi Christopher,

    Please use the updated version of Aspose.Cells.dll v5.1.2.5 attached. The issue has been resolved.

    Thanks,


    Sincere Regards,

    Salman Shakeel
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
  •  09-02-2010, 4:15 PM 256891 in reply to 256824

    Re: Excel found unreadable content in 'file.xlsx'

    This portion is working now.  I'm having an issue with borders, but I'll start another topic for that one.

     
  •  09-16-2010, 6:14 AM 258973 in reply to 255655

    Re: Excel found unreadable content in 'file.xlsx'

    The issues you have found earlier (filed as 19585) 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