3 Answers, 1 is accepted
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/.
Rank 1
Iron
Veteran
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
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/.