Edit this page

Kendo.Mvc.UI.Fluent.SpreadsheetBuilder

Defines the fluent API for configuring the Kendo Spreadsheet for ASP.NET MVC.

Methods

ActiveSheet(System.String)

The name of the currently active sheet.Must match one of the (sheet names)[#configuration-sheets.name] exactly.

Parameters

value System.String

The value that configures the activesheet.

ColumnWidth(System.Double)

The default column width in pixels.

Parameters

value System.Double

The value that configures the columnwidth.

Columns(System.Double)

The number of columns in the document.

Parameters

value System.Double

The value that configures the columns.

DefaultCellStyle(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetDefaultCellStyleSettingsBuilder>)

The default cell styles to be applyied to sheet cells.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetDefaultCellStyleSettingsBuilder>

The action that configures the defaultcellstyle.

HeaderHeight(System.Double)

The height of the header row in pixels.

Parameters

value System.Double

The value that configures the headerheight.

HeaderWidth(System.Double)

The width of the header column in pixels.

Parameters

value System.Double

The value that configures the headerwidth.

Excel(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetExcelSettingsBuilder>)

Configures the Kendo UI Spreadsheet Excel export settings.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetExcelSettingsBuilder>

The action that configures the excel.

Pdf(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetPdfSettingsBuilder>)

Configures the Kendo UI Spreadsheet PDF export settings.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetPdfSettingsBuilder>

The action that configures the pdf.

RowHeight(System.Double)

The default row height in pixels.

Parameters

value System.Double

The value that configures the rowheight.

Rows(System.Double)

The number of rows in the document.

Parameters

value System.Double

The value that configures the rows.

Sheetsbar(System.Boolean)

A boolean value indicating if the sheetsbar should be displayed.

Parameters

value System.Boolean

The value that configures the sheetsbar.

Toolbar(System.Boolean)

A boolean value indicating if the toolbar should be displayed.

Parameters

enabled System.Boolean

Enables or disables the toolbar option.

Toolbar(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetToolbarSettingsBuilder>)

A boolean value indicating if the toolbar should be displayed.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetToolbarSettingsBuilder>

The action that configures the toolbar.

Sheets(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFactory>)

An array defining the document sheets and their content.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetSheetFactory>

The action that configures the sheets.

Events(System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetEventBuilder>)

Configures the client-side events.

Parameters

configurator System.Action<Kendo.Mvc.UI.Fluent.SpreadsheetEventBuilder>

The client events action.

Example (ASPX)

<%= Html.Kendo().Spreadsheet()
.Name("Spreadsheet")
.Events(events => events
    .Render("onRender")
)
%>