Hi team,
we are using the spreadsheet component with angular . there is some issue in preview mode for xlsx file. While we upload sample xlsx file which size is approximately 7-8MB is becomes browser unresponsive and not able to see the preview of xlsx file in spreadsheet. So I am attaching screenshot for the same.
11 Answers, 1 is accepted
Hi Ankur,
It looks like this thread isn't related to the Kendo UI for Angular Grid. There isn't also a Kendo UI for Angular dedicated SpreadSheet component. Thus, could I ask you to confirm if you are using the Kendo UI for jQuery Spreadsheet in an Angular 2+ project or in an Angular JS project. Thank you.
Regards,
Svetlin
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/.
Hi Svetlin,
Yes I am using the kendo jquery spreadsheet for angular 10 .
Hi Ankur,
To be able to help you, can you share more details about the issue?
- Does the Spreadsheet become unresponsive or it is the whole browser?
- In the end, does the file loads in the Spreadsheet or not?
- Is the same issue replicable with all files that you try to load or the issue is file related?
- Are there any errors in the browser's console?
- Can you check if the issue is replicable on our jQuery demos and let me know about the result?
- If your file doesn't contain sensitive information, can you share the file that you are trying to load?
Looking forward to your reply.
Regards,
Petar
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/.
Hi Petar,
Does the Spreadsheet become unresponsive or it is the whole browser? - whole browser becomes unresponsive
In the end, does the file loads in the Spreadsheet or not? - not loaded in the spreadsheet
Is the same issue replicable with all files that you try to load or the issue is file related? - In all files this issue is occurring
Are there any errors in the browser's console? - NO
Can you check if the issue is replicable on our jQuery demos and let me know about the result? - Yes ,browser becomes unresponsive .For this I am attaching the screenshot for the same.
If your file doesn't contain sensitive information, can you share the file that you are trying to load? - Yes, but due to file size restriction i am unable to attach it . it's size is approx. 38 MB. so kindly tell the alternative to attach the file if you required.
Looking forward to your reply.
Regards,
Ankur
Hi Ankur,
Thank you for the additional details. Based on them and the screenshot from your reply, I would assume that the reported behavior is a result of the size of the file that you are trying to load.
Can you reduce the file size to up to 5 -10 MB and see if the issue will disappear? To reduce the file size, delete some data or sheets in it. Try to load the reduced file in the Spreadsheet and let me know about the result.
Also, can you share the browser that you use? Which version is it?
Looking forward to your reply.
Regards,
Petar
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/.
Hi Peter,
I am using the browser Version 88.0.4324.104 (Official Build) (64-bit) . Even 7-8Mb file is also do unresponsive the browser. you can try to upload the sample file in spreadsheet , type of file is xlsx.
Thanks,
Ankur
Hi Ankur,
I can't see a sample file attached to your reply. Can you send it to me again so I can test the file locally?
Regards,
Petar
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/.
Hi Peter,
Due to File size 38-39 MB unable to attach the file. Any alternative solution for attach the file to you ?.
Thanks,
Ankur
Hi Ankur,
I meant to send me a file that is smaller in size. In one of your replies, you shared that the Spreadsheet's behavior is the same when opening a file with a size of 7-8 MB.
You can attach files of 7-8 MB. Otherwise, you can send upload your file on a DropBox, Google Drive, or similar service and send me a link for further investigation.
Regards,
Petar
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/.
Hi Peter,
Below the link you can see the sample files.
https://drive.google.com/file/d/1tgrkqJPGc14OCRvCr7WaTVVHRrGKCkHd/view?usp=sharing, https://drive.google.com/file/d/1yKMbpM9T_eZrtY-EpRn-4PDehUHu_K7H/view?usp=sharing
Hi Ankur,
Thank you for the provided file. I can see that it contains more than 387 000 records. After reducing the file to around 200 000 records, I've managed to load it in the Spreadsheet after waiting for a while.
I can confirm that it is the file size and rows' number that block the browser when you try to load the provided file in the Spreadsheet. Generally speaking, if you wait enough time(depending on the parameters of the computer you are working on) the file should be loaded in the Spreadsheet. This time will vary on each machine. There is no solution we can provide for loading such big files without delays in the file load.
Regards,
Petar
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/.