Last Updated: 12 May 2022 12:26 by ADMIN
Release 2022.R1.SP2
David M
Created on: 20 May 2016 16:33
Category: Spreadsheet
Type: Feature Request
Dynamically change the number of rows
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
Ivan Danchev
Posted on: 20 Apr 2021 08:06


Thank you for your suggestions. We will consider all of them.

Ivan Danchev
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.

Posted on: 13 Apr 2021 08:43

I would add, there should be a possibility to auto-add the rows, if the current cell along with the pasted range "overflows" the existing row number.


Suppose I have 10 rows, I am in the last row, and I paste 10 000 rows from clipboard. The row number should increase to 10 009, and all the values should be pasted and available in the sheet.

Posted on: 11 Jun 2020 11:21
Yes, this is must have feature in context of Excel functionalities. Please plan it in your next release.
Posted on: 29 Apr 2019 06:24

Totally agree to Steve.

A sheet should expand automatically, when a user fills the last rows. Such a behavior would also be nice for the columns.

Posted on: 27 Feb 2017 16:11
The workaround is a tad cumbersome, would be nice to be OOTB.  Kinda seems like a feature that was just missed nobody thought of it in testing, but really kinda needs to be here.

I would also really like the ability to specify a buffer, so like if I specify 20 as the buffer and the Datasource returns 1000, I then have 1020 rows in the sheet.
Posted on: 08 Nov 2016 05:33
You could use "insertRow" and "deleteRow" to get the correct rows back.

However, as always with major UI updates, put it into "batch":
.batch(function () {
   .. Code to insert/remove rows
        }, { layout: true });
T. Tsonev
Posted on: 04 Nov 2016 17:47

The fromJSON method ( on the Workbook will create a sheet with the appropriate size to accommodate all records. 

Additionally, you don't need to re-create the whole Widget, just call `insertSheet` with the appropriate size.

Does this help?