New to Kendo UI for jQuery? Start a free 30-day trial

InsertSheet

methods

Inserts a sheet with the specified options.

insertSheet

Parameters:optionsObject

The configuration options for the sheet.

options.rowsNumber

The number of rows in this sheet.

options.columnsNumber

The number of columns in this sheet.

options.rowHeightNumber

The row height in this sheet in pixels.

options.columnWidthNumber

The column width in this sheet in pixels.

options.headerHeightNumber

The header row height in pixels.

options.headerWidthNumber

The header column width in pixels.

options.dataSourcekendo.data.DataSource

The data source for this sheet.

options.dataObject

The sheet state and data as Object. The schema follows the same structure as the widget configuration.

Returns:kendo.spreadsheet.Sheet

- The inserted sheet.

<div id="spreadsheet"></div>
<button>Add New Sheet</button>
<script>
  var i = 2
  $("#spreadsheet").kendoSpreadsheet({
    sheets: [{ name: "Sheet1" }, { name: "Sheet2" }]
  });
  var sheets = $("#spreadsheet").data("kendoSpreadsheet").sheets();
  $("button").click(function(){
    $("#spreadsheet").data("kendoSpreadsheet").insertSheet({
      name: "Custom Sheet Name" + ++i,
      frozenRows: 1,
      frozenColumns: 1,
      rows: 15,
      columns: 10,
    });
  })
</script>