xlsx breaking in spreadsheet viewer

4 posts, 0 answers
  1. Jaspreet
    Jaspreet avatar
    14 posts
    Member since:
    Feb 2020

    Posted 24 Sep 2020 Link to this post

    hi,
    While opening few xlsx in spreadhsheet viewer, an error is being thrown ERROR TypeError: Cannot read property '2' of null. PFA the sample file. 
    Regards,
    Jaspreet
  2. Misho
    Admin
    Misho avatar
    241 posts

    Posted 28 Sep 2020 Link to this post

    Hi Jaspreet,

    I was able to replicate the error on my side with the document you've attached. I've tried to create xlsx document from scratch on my end with similar data pasted from the excel file you have provided. This way the document is opened in spreadsheet successfully in this dojo. I'm attaching it for reference. Could you please provide us with more details about the steps to produce the problematic xlsx file? This way we will be enabled to investigate the case more easily on our side and do our best to provide you with more detailed information and reliable solution.

    Thank you for your collaboration.

    Best Regards,
    Misho
    Progress Telerik

    Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

  3. Jaspreet
    Jaspreet avatar
    14 posts
    Member since:
    Feb 2020

    Posted 30 Sep 2020 in reply to Misho Link to this post

    hi Misho,

    We have used Apache POI to convert xls to xlsx only because spreadhseet viewer supports xlsx. But after the conversion we got this error. 

    Regards,

    Jaspreet

  4. Misho
    Admin
    Misho avatar
    241 posts

    Posted 02 Oct 2020 Link to this post

    Hi,

    I've tested the original test10000.xlsx in OpenXML SDK Productivity Tool 2.5 and it reports 24 errors which means that it might be corrupted.

    In case opening the same file in MS Excel and just save it, these errors are cleaned by MS Excel and the file could be imported successfully to Kendo Spreadsheet with no errors. I've attached it for reference.

    I hope you will find this information useful.

    Best Regards,
    Misho
    Progress Telerik

    Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Back to Top