<kendo:spreadsheet>

A JSP wrapper for Kendo UI Spreadsheet.

Configuration Attributes

activeSheet java.lang.String

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

Example

<kendo:spreadsheet activeSheet="activeSheet">
</kendo:spreadsheet>

columnWidth float

The default column width in pixels.

Example

<kendo:spreadsheet columnWidth="columnWidth">
</kendo:spreadsheet>

columns float

The number of columns in the document.

Example

<kendo:spreadsheet columns="columns">
</kendo:spreadsheet>

headerHeight float

The height of the header row in pixels.

Example

<kendo:spreadsheet headerHeight="headerHeight">
</kendo:spreadsheet>

headerWidth float

The width of the header column in pixels.

Example

<kendo:spreadsheet headerWidth="headerWidth">
</kendo:spreadsheet>

rowHeight float

The default row height in pixels.

Example

<kendo:spreadsheet rowHeight="rowHeight">
</kendo:spreadsheet>

rows float

The number of rows in the document.

Example

<kendo:spreadsheet rows="rows">
</kendo:spreadsheet>

sheetsbar boolean

A boolean value indicating if the sheetsbar should be displayed.

Example

<kendo:spreadsheet sheetsbar="sheetsbar">
</kendo:spreadsheet>

toolbar boolean

A boolean value indicating if the toolbar should be displayed. Further configuration is available via kendo:spreadsheet-toolbar.

Example

<kendo:spreadsheet toolbar="toolbar">
</kendo:spreadsheet>

Configuration JSP Tags

kendo:spreadsheet-defaultCellStyle

The default cell styles to be applyied to sheet cells.

More documentation is available at kendo:spreadsheet-defaultCellStyle.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-defaultCellStyle></kendo:spreadsheet-defaultCellStyle>
</kendo:spreadsheet>

kendo:spreadsheet-excel

Configures the Kendo UI Spreadsheet Excel export settings.

More documentation is available at kendo:spreadsheet-excel.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-excel></kendo:spreadsheet-excel>
</kendo:spreadsheet>

kendo:spreadsheet-pdf

Configures the Kendo UI Spreadsheet PDF export settings.

More documentation is available at kendo:spreadsheet-pdf.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-pdf></kendo:spreadsheet-pdf>
</kendo:spreadsheet>

kendo:spreadsheet-sheets

An array defining the document sheets and their content.

More documentation is available at kendo:spreadsheet-sheets.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-sheets></kendo:spreadsheet-sheets>
</kendo:spreadsheet>

kendo:spreadsheet-toolbar

A boolean value indicating if the toolbar should be displayed.

More documentation is available at kendo:spreadsheet-toolbar.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-toolbar></kendo:spreadsheet-toolbar>
</kendo:spreadsheet>

Event Attributes

insertSheet String

Triggered when sheet is inserted. Introduced in 2017 Q1.

For additional information check the insertSheet event documentation.

Example

<kendo:spreadsheet insertSheet="handle_insertSheet">
</kendo:spreadsheet>
<script>
    function handle_insertSheet(e) {
        // Code to handle the insertSheet event.
    }
</script>

removeSheet String

Triggered when sheet will be removed. Introduced in 2017 Q1.

For additional information check the removeSheet event documentation.

Example

<kendo:spreadsheet removeSheet="handle_removeSheet">
</kendo:spreadsheet>
<script>
    function handle_removeSheet(e) {
        // Code to handle the removeSheet event.
    }
</script>

renameSheet String

Triggered when sheet will be renamed. Introduced in 2017 Q1.

For additional information check the renameSheet event documentation.

Example

<kendo:spreadsheet renameSheet="handle_renameSheet">
</kendo:spreadsheet>
<script>
    function handle_renameSheet(e) {
        // Code to handle the renameSheet event.
    }
</script>

selectSheet String

Triggered when sheet will be activated. Introduced in 2017 Q1.

For additional information check the selectSheet event documentation.

Example

<kendo:spreadsheet selectSheet="handle_selectSheet">
</kendo:spreadsheet>
<script>
    function handle_selectSheet(e) {
        // Code to handle the selectSheet event.
    }
</script>

unhideColumn String

Triggered when column will be shown. Introduced in 2017 Q1.

For additional information check the unhideColumn event documentation.

Example

<kendo:spreadsheet unhideColumn="handle_unhideColumn">
</kendo:spreadsheet>
<script>
    function handle_unhideColumn(e) {
        // Code to handle the unhideColumn event.
    }
</script>

unhideRow String

Triggered when row will be shown. Introduced in 2017 Q1.

For additional information check the unhideRow event documentation.

Example

<kendo:spreadsheet unhideRow="handle_unhideRow">
</kendo:spreadsheet>
<script>
    function handle_unhideRow(e) {
        // Code to handle the unhideRow event.
    }
</script>

hideColumn String

Triggered when column will be hidden. Introduced in 2017 Q1.

For additional information check the hideColumn event documentation.

Example

<kendo:spreadsheet hideColumn="handle_hideColumn">
</kendo:spreadsheet>
<script>
    function handle_hideColumn(e) {
        // Code to handle the hideColumn event.
    }
</script>

hideRow String

Triggered when row will be hidden. Introduced in 2017 Q1.

For additional information check the hideRow event documentation.

Example

<kendo:spreadsheet hideRow="handle_hideRow">
</kendo:spreadsheet>
<script>
    function handle_hideRow(e) {
        // Code to handle the hideRow event.
    }
</script>

deleteColumn String

Triggered when column will be deleted. Introduced in 2017 Q1.

For additional information check the deleteColumn event documentation.

Example

<kendo:spreadsheet deleteColumn="handle_deleteColumn">
</kendo:spreadsheet>
<script>
    function handle_deleteColumn(e) {
        // Code to handle the deleteColumn event.
    }
</script>

deleteRow String

Triggered when row will be deleted. Introduced in 2017 Q1.

For additional information check the deleteRow event documentation.

Example

<kendo:spreadsheet deleteRow="handle_deleteRow">
</kendo:spreadsheet>
<script>
    function handle_deleteRow(e) {
        // Code to handle the deleteRow event.
    }
</script>

insertColumn String

Triggered when column will be inserted. Introduced in 2017 Q1.

For additional information check the insertColumn event documentation.

Example

<kendo:spreadsheet insertColumn="handle_insertColumn">
</kendo:spreadsheet>
<script>
    function handle_insertColumn(e) {
        // Code to handle the insertColumn event.
    }
</script>

insertRow String

Triggered when row will be inserted. Introduced in 2017 Q1.

For additional information check the insertRow event documentation.

Example

<kendo:spreadsheet insertRow="handle_insertRow">
</kendo:spreadsheet>
<script>
    function handle_insertRow(e) {
        // Code to handle the insertRow event.
    }
</script>

select String

Triggered when spreadsheet selection is changed. Introduced in 2017 Q1.

For additional information check the select event documentation.

Example

<kendo:spreadsheet select="handle_select">
</kendo:spreadsheet>
<script>
    function handle_select(e) {
        // Code to handle the select event.
    }
</script>

changeFormat String

Triggered when range format is changed from the UI. Introduced in 2017 Q1.

For additional information check the changeFormat event documentation.

Example

<kendo:spreadsheet changeFormat="handle_changeFormat">
</kendo:spreadsheet>
<script>
    function handle_changeFormat(e) {
        // Code to handle the changeFormat event.
    }
</script>

change String

Triggered when a value in the spreadsheet has been changed. Introduced in 2016.Q1.SP1.

For additional information check the change event documentation.

Example

<kendo:spreadsheet change="handle_change">
</kendo:spreadsheet>
<script>
    function handle_change(e) {
        // Code to handle the change event.
    }
</script>

render String

Triggered after the widget has completed rendering.

For additional information check the render event documentation.

Example

<kendo:spreadsheet render="handle_render">
</kendo:spreadsheet>
<script>
    function handle_render(e) {
        // Code to handle the render event.
    }
</script>

excelExport String

Fired when the user clicks the "Export to Excel" toolbar button.

For additional information check the excelExport event documentation.

Example

<kendo:spreadsheet excelExport="handle_excelExport">
</kendo:spreadsheet>
<script>
    function handle_excelExport(e) {
        // Code to handle the excelExport event.
    }
</script>

excelImport String

Fired when the user clicks the "Open" toolbar button.

For additional information check the excelImport event documentation.

Example

<kendo:spreadsheet excelImport="handle_excelImport">
</kendo:spreadsheet>
<script>
    function handle_excelImport(e) {
        // Code to handle the excelImport event.
    }
</script>

pdfExport String

Fired when the user initiates PDF export.

For additional information check the pdfExport event documentation.

Example

<kendo:spreadsheet pdfExport="handle_pdfExport">
</kendo:spreadsheet>
<script>
    function handle_pdfExport(e) {
        // Code to handle the pdfExport event.
    }
</script>

Event Tags

kendo:spreadsheet-insertSheet

Triggered when sheet is inserted. Introduced in 2017 Q1.

For additional information check the insertSheet event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-insertSheet>
        <script>
            function(e) {
                // Code to handle the insertSheet event.
            }
        </script>
    </kendo:spreadsheet-insertSheet>
</kendo:spreadsheet>

kendo:spreadsheet-removeSheet

Triggered when sheet will be removed. Introduced in 2017 Q1.

For additional information check the removeSheet event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-removeSheet>
        <script>
            function(e) {
                // Code to handle the removeSheet event.
            }
        </script>
    </kendo:spreadsheet-removeSheet>
</kendo:spreadsheet>

kendo:spreadsheet-renameSheet

Triggered when sheet will be renamed. Introduced in 2017 Q1.

For additional information check the renameSheet event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-renameSheet>
        <script>
            function(e) {
                // Code to handle the renameSheet event.
            }
        </script>
    </kendo:spreadsheet-renameSheet>
</kendo:spreadsheet>

kendo:spreadsheet-selectSheet

Triggered when sheet will be activated. Introduced in 2017 Q1.

For additional information check the selectSheet event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-selectSheet>
        <script>
            function(e) {
                // Code to handle the selectSheet event.
            }
        </script>
    </kendo:spreadsheet-selectSheet>
</kendo:spreadsheet>

kendo:spreadsheet-unhideColumn

Triggered when column will be shown. Introduced in 2017 Q1.

For additional information check the unhideColumn event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-unhideColumn>
        <script>
            function(e) {
                // Code to handle the unhideColumn event.
            }
        </script>
    </kendo:spreadsheet-unhideColumn>
</kendo:spreadsheet>

kendo:spreadsheet-unhideRow

Triggered when row will be shown. Introduced in 2017 Q1.

For additional information check the unhideRow event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-unhideRow>
        <script>
            function(e) {
                // Code to handle the unhideRow event.
            }
        </script>
    </kendo:spreadsheet-unhideRow>
</kendo:spreadsheet>

kendo:spreadsheet-hideColumn

Triggered when column will be hidden. Introduced in 2017 Q1.

For additional information check the hideColumn event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-hideColumn>
        <script>
            function(e) {
                // Code to handle the hideColumn event.
            }
        </script>
    </kendo:spreadsheet-hideColumn>
</kendo:spreadsheet>

kendo:spreadsheet-hideRow

Triggered when row will be hidden. Introduced in 2017 Q1.

For additional information check the hideRow event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-hideRow>
        <script>
            function(e) {
                // Code to handle the hideRow event.
            }
        </script>
    </kendo:spreadsheet-hideRow>
</kendo:spreadsheet>

kendo:spreadsheet-deleteColumn

Triggered when column will be deleted. Introduced in 2017 Q1.

For additional information check the deleteColumn event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-deleteColumn>
        <script>
            function(e) {
                // Code to handle the deleteColumn event.
            }
        </script>
    </kendo:spreadsheet-deleteColumn>
</kendo:spreadsheet>

kendo:spreadsheet-deleteRow

Triggered when row will be deleted. Introduced in 2017 Q1.

For additional information check the deleteRow event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-deleteRow>
        <script>
            function(e) {
                // Code to handle the deleteRow event.
            }
        </script>
    </kendo:spreadsheet-deleteRow>
</kendo:spreadsheet>

kendo:spreadsheet-insertColumn

Triggered when column will be inserted. Introduced in 2017 Q1.

For additional information check the insertColumn event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-insertColumn>
        <script>
            function(e) {
                // Code to handle the insertColumn event.
            }
        </script>
    </kendo:spreadsheet-insertColumn>
</kendo:spreadsheet>

kendo:spreadsheet-insertRow

Triggered when row will be inserted. Introduced in 2017 Q1.

For additional information check the insertRow event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-insertRow>
        <script>
            function(e) {
                // Code to handle the insertRow event.
            }
        </script>
    </kendo:spreadsheet-insertRow>
</kendo:spreadsheet>

kendo:spreadsheet-select

Triggered when spreadsheet selection is changed. Introduced in 2017 Q1.

For additional information check the select event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-select>
        <script>
            function(e) {
                // Code to handle the select event.
            }
        </script>
    </kendo:spreadsheet-select>
</kendo:spreadsheet>

kendo:spreadsheet-changeFormat

Triggered when range format is changed from the UI. Introduced in 2017 Q1.

For additional information check the changeFormat event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-changeFormat>
        <script>
            function(e) {
                // Code to handle the changeFormat event.
            }
        </script>
    </kendo:spreadsheet-changeFormat>
</kendo:spreadsheet>

kendo:spreadsheet-change

Triggered when a value in the spreadsheet has been changed. Introduced in 2016.Q1.SP1.

For additional information check the change event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-change>
        <script>
            function(e) {
                // Code to handle the change event.
            }
        </script>
    </kendo:spreadsheet-change>
</kendo:spreadsheet>

kendo:spreadsheet-render

Triggered after the widget has completed rendering.

For additional information check the render event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-render>
        <script>
            function(e) {
                // Code to handle the render event.
            }
        </script>
    </kendo:spreadsheet-render>
</kendo:spreadsheet>

kendo:spreadsheet-excelExport

Fired when the user clicks the "Export to Excel" toolbar button.

For additional information check the excelExport event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-excelExport>
        <script>
            function(e) {
                // Code to handle the excelExport event.
            }
        </script>
    </kendo:spreadsheet-excelExport>
</kendo:spreadsheet>

kendo:spreadsheet-excelImport

Fired when the user clicks the "Open" toolbar button.

For additional information check the excelImport event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-excelImport>
        <script>
            function(e) {
                // Code to handle the excelImport event.
            }
        </script>
    </kendo:spreadsheet-excelImport>
</kendo:spreadsheet>

kendo:spreadsheet-pdfExport

Fired when the user initiates PDF export.

For additional information check the pdfExport event documentation.

Example

<kendo:spreadsheet>
    <kendo:spreadsheet-pdfExport>
        <script>
            function(e) {
                // Code to handle the pdfExport event.
            }
        </script>
    </kendo:spreadsheet-pdfExport>
</kendo:spreadsheet>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy