Spreadsheet a long time to render

Spreedsheet takes a long time to render after my request data interface receives the data; Data files are sent as attachments


browser:

Chrome browser: Version 96.0.4664.93Official Build (arm64)

Microsoft Edge browser: Version 96.0.1054.43Official Build (arm64)
Firefox95.0 (arm64)

version:

syncfusion/ej2-vue-spreadsheet :19.3.57


Attachment: sample.json_b0e6932c.zip

2 Replies

SP Sangeetha Priya Murugan Syncfusion Team December 13, 2021 02:41 PM UTC

Hi KK, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported issue and we need to validate more on this. So, we will update you the further details on December 15th 2021. We appreciate your patience until then. 
 
Regards, 
Sangeetha M 



SP Sangeetha Priya Murugan Syncfusion Team December 17, 2021 02:57 PM UTC

Hi KK, 
 
Thank you for your patience. 
 
We have checked your reported requirement with the attached json file, and we are facing some difficulties while loading your json file in application. We have suspect that you have used more number of rows and columns. And we have some limitations in web platform, for number of elements rendered in the DOM. Our spreadsheet rendered maximum of 1 million cells that dependes upon the rows and columns. The time delay in spreadsheet varies depend upon the cell count and formats applied in the spreadsheet, please find the below benchmark of our Spreadsheet. 
  
 Scenario 
Rows * Columns 
Import with normal data (without any formatting, cell templates) 
50,000 * 20 (1 million cells) 
Import data with format (Row height/ cell formats & Merging Wrap text randomly) 
30,000 * 10 
 
Meanwhile, we have row virtualization support in spreadsheet. In this we have rendered the cells while scrolling the content. If you render more columns the rendering time is moderately high, based on the loaded columns. Before we proceed further, please share the below details. 
 
1. If possible, please share us the row count and column count used in the json file. 
2.we have included some performance related improvements with our latest version. So, please check with latest version for Vue packages (19.4.38). 
3.if possible, please share the customization code done in your sample. 
 
Please provide the above requested information, based on that we will check and provide you a better solution quickly 
 
Regards, 
Sangeetha M 


Loader.
Up arrow icon