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

Upload XLSX file in spreadsheet

11 Answers 91 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Ankur
Top achievements
Rank 1
Ankur asked on 04 Feb 2021, 08:36 AM

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

Sort by
0
Svet
Telerik team
answered on 08 Feb 2021, 06:54 AM

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

0
Ankur
Top achievements
Rank 1
answered on 08 Feb 2021, 09:01 AM

Hi Svetlin,

Yes I am using the kendo jquery spreadsheet for angular 10 . 

0
Petar
Telerik team
answered on 10 Feb 2021, 07:39 AM

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

0
Ankur
Top achievements
Rank 1
answered on 12 Feb 2021, 10:57 AM

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

0
Petar
Telerik team
answered on 16 Feb 2021, 09:43 AM

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

0
Ankur
Top achievements
Rank 1
answered on 17 Feb 2021, 05:59 AM

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 

0
Petar
Telerik team
answered on 18 Feb 2021, 09:12 AM

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

0
Ankur
Top achievements
Rank 1
answered on 22 Feb 2021, 06:15 AM

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

0
Petar
Telerik team
answered on 23 Feb 2021, 10:21 AM

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

0
Ankur
Top achievements
Rank 1
answered on 01 Mar 2021, 10:11 AM

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

 

 

0
Petar
Telerik team
answered on 03 Mar 2021, 08:58 AM

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

Tags
Grid
Asked by
Ankur
Top achievements
Rank 1
Answers by
Svet
Telerik team
Ankur
Top achievements
Rank 1
Petar
Telerik team
Share this question
or