kendo.ui.Spreadsheet
Represents the Kendo UI Spreadsheet widget. Inherits from Widget.
Configuration
- activeSheet
- columnWidth
- columns
- defaultCellStyle
- defaultCellStyle.background
- defaultCellStyle.color
- defaultCellStyle.fontFamily
- defaultCellStyle.fontSize
- defaultCellStyle.Italic
- defaultCellStyle.bold
- defaultCellStyle.underline
- defaultCellStyle.wrap
- headerHeight
- headerWidth
- excel
- excel.fileName
- excel.forceProxy
- excel.proxyURL
- images
- pdf.area
- pdf.author
- pdf.autoPrint
- pdf.creator
- pdf.date
- pdf.fileName
- pdf.fitWidth
- pdf.forceProxy
- pdf.guidelines
- pdf.hCenter
- pdf.jpegQuality
- pdf.keepPNG
- pdf.keywords
- pdf.landscape
- pdf.margin
- pdf.margin.bottom
- pdf.margin.left
- pdf.margin.right
- pdf.margin.top
- pdf.paperSize
- pdf.proxyURL
- pdf.proxyTarget
- pdf.subject
- pdf.title
- pdf.vCenter
- rowHeight
- rows
- sheets
- sheets.activeCell
- sheets.name
- sheets.columns
- sheets.columns.index
- sheets.columns.width
- sheets.dataSource
- sheets.drawings
- sheets.drawings.topLeftCell
- sheets.drawings.offsetX
- sheets.drawings.offsetY
- sheets.drawings.width
- sheets.drawings.height
- sheets.drawings.image
- sheets.filter
- sheets.filter.columns
- sheets.filter.columns.criteria
- sheets.filter.columns.criteria.operator
- sheets.filter.columns.criteria.value
- sheets.filter.columns.filter
- sheets.filter.columns.index
- sheets.filter.columns.logic
- sheets.filter.columns.type
- sheets.filter.columns.value
- sheets.filter.columns.values
- sheets.filter.ref
- sheets.frozenColumns
- sheets.frozenRows
- sheets.mergedCells
- sheets.rows
- sheets.rows.cells
- sheets.rows.cells.background
- sheets.rows.cells.borderBottom
- sheets.rows.cells.borderBottom.color
- sheets.rows.cells.borderBottom.size
- sheets.rows.cells.borderLeft
- sheets.rows.cells.borderLeft.color
- sheets.rows.cells.borderLeft.size
- sheets.rows.cells.borderTop
- sheets.rows.cells.borderTop.color
- sheets.rows.cells.borderTop.size
- sheets.rows.cells.borderRight
- sheets.rows.cells.borderRight.color
- sheets.rows.cells.borderRight.size
- sheets.rows.cells.color
- sheets.rows.cells.comment
- sheets.rows.cells.fontFamily
- sheets.rows.cells.fontSize
- sheets.rows.cells.italic
- sheets.rows.cells.bold
- sheets.rows.cells.enable
- sheets.rows.cells.format
- sheets.rows.cells.formula
- sheets.rows.cells.html
- sheets.rows.cells.index
- sheets.rows.cells.link
- sheets.rows.cells.textAlign
- sheets.rows.cells.underline
- sheets.rows.cells.value
- sheets.rows.cells.validation
- sheets.rows.cells.validation.type
- sheets.rows.cells.validation.comparerType
- sheets.rows.cells.validation.dataType
- sheets.rows.cells.validation.from
- sheets.rows.cells.validation.showButton
- sheets.rows.cells.validation.to
- sheets.rows.cells.validation.allowNulls
- sheets.rows.cells.validation.messageTemplate
- sheets.rows.cells.validation.titleTemplate
- sheets.rows.cells.verticalAlign
- sheets.rows.cells.wrap
- sheets.rows.height
- sheets.rows.index
- sheets.rows.type
- sheets.selection
- sheets.showGridLines
- sheets.sort
- sheets.sort.columns
- sheets.sort.columns.ascending
- sheets.sort.columns.index
- sheets.sort.ref
- sheetsbar
- toolbar
- toolbar.file
- toolbar.home
- toolbar.insert
- toolbar.format
- toolbar.data
- toolbar.view
- useCultureDecimals
Methods
- activeSheet
- addImage
- cellContextMenu
- cleanupImages
- rowHeaderContextMenu
- colHeaderContextMenu
- sheets
- fromFile
- saveAsExcel
- saveAsPDF
- sheetByName
- sheetIndex
- sheetByIndex
- insertSheet
- moveSheetToIndex
- refresh
- removeSheet
- renameSheet
- saveJSON
- toJSON
- fromJSON
- defineName
- undefineName