I am trying to set the max row count after I retrieved the data from AJAX call. The default option for the number of rows is 200. I am needing to be able to change this number based on the number of rows returned from AJAX call. I want the page to have to have the default of 200 when the page loads.

The user then chooses from a dropdown on the page to query the backend for data which will have a different number of rows each time. I was hoping to be able to just set the rows property on the sheet.options object, but it does not look like these values are re-read after initialization.

How should I do this? Especially if I am going to have multiple tabs of data with different number of rows.

Thanks.

Another reason for this question is it just suggested to set this value to really large number if I have multiple tabs?

For Example:

Tab 1: 20 rows
Tab 2: 100 rows
Tab 3: 2000 rows
Tab 4: 500 rows

If the max count defaults to 200, the tabs with more 200 rows will fail. If I just set the max row count to 2000 rows, all of tabs will display, but now the tabs with only a few rows like Tab 1 will have over 1,000 blank rows.

Hello John,

You could use the insertSheet method to add new sheets with specific options to the Spreadsheet. The object which is passed as a parameter to the method should have an options.rows configuration which specifies the number of rows in the new sheet.

I just ran into this issue of wanting to expand the # of rows by one from a fixed row length sheet. Here is a direct and fast way to add a row in just a few lines of code that handles the copy data/reset sheet and everything in a simple call and also preserves hidden column attributes:

            var workbook = yourKendoWorkSheet.toJSON();
            workbook.rows = workbook.sheets[0].rows.push({}); // push x empty rows if you'd like, the {} can also be a full row option set
            yourKendoWorkSheet.fromJSON(workbook);

Hope this helps someone