Is there a way to quickly insert multiple blank rows in the spreadsheet control? The insertRow function is too slow.
For example, Import the Excel file from the attachment into the spreadsheet control for testing. Inserting 1,000 rows is very slow.
1 Answer, 1 is accepted
Hello,
If I correctly understand the issue, it is taking a long time to import the attached file in the Spreadsheet. You can try the Server Import/Export demo to see if it will produce a better result. I am not sure how the insertRow method is involved in the behaviour you are experiencing, so kindly elaborate if I am missing something.
Regards,
Martin
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
Comparing the performance differences in AddRows between KendoSpreadsheet and SpreadJS:
SpreadJS AddRows：25ms
KendoSpreadsheet AddRows: 33388ms
Thank you for the provided demos. With the given scenario, the Spreadsheet needs to make a lot of re-calculations due to the amount of rows and columns you have. At this point there isn't something we can provide to increase the performance.