This is a migrated thread and some comments may be shown as answers.

xlsx breaking in spreadsheet viewer

3 Answers 23 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jaspreet
Top achievements
Rank 1
Iron
Veteran
Jaspreet asked on 24 Sep 2020, 10:47 AM
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

3 Answers, 1 is accepted

Sort by
0
Misho
Telerik team
answered on 28 Sep 2020, 07:41 AM

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/.

0
Jaspreet
Top achievements
Rank 1
Iron
Veteran
answered on 30 Sep 2020, 03:59 PM

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

0
Misho
Telerik team
answered on 02 Oct 2020, 11:50 AM

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/.

Tags
Spreadsheet
Asked by
Jaspreet
Top achievements
Rank 1
Iron
Veteran
Answers by
Misho
Telerik team
Jaspreet
Top achievements
Rank 1
Iron
Veteran
Share this question
or