• Getting Started
  • Components
    • Barcodes
    • Buttons
    • Chartsupdated
    • Conversational UIupdated
    • Data Query
    • Date Inputsupdated
    • Date Math
    • Dialogs
    • Drawing
    • Dropdownsupdated
    • Editor
    • Excel Export
    • File Saver
    • Filter
    • Gantt
    • Gauges
    • Gridupdated
    • Icons
    • Indicators
    • Inputsupdated
    • Labels
    • Layoutupdated
    • ListBox
    • ListView
    • Map
    • Menus
    • Navigation
    • Notification
    • Pager
    • PDF Export
    • PDFViewer
    • PivotGridupdated
    • Popup
    • ProgressBars
    • Ripple
    • Schedulerupdated
    • ScrollView
    • Sortable
    • Spreadsheetupdated
    • ToolBar
    • Tooltips
    • TreeList
    • TreeView
    • Typography
    • Uploads
    • Utilities
  • Styling & Themes
  • Common Features
  • Project Setup
  • Knowledge Base
  • Sample Applications
  • FAQ
  • Troubleshooting
  • Updates
  • Changelogs
New to Kendo UI for Angular? Start a free 30-day trial

WorkbookSheet

The workbook sheets options.

NameTypeDefaultDescription

columns?

WorkbookSheetColumn[]

The sheets columns configuration.

filter?

WorkbookSheetFilter

Excel auto filter configuration. When set the final document will have auto filtering enabled.

frozenColumns?

number

The number of frozen columns in this sheet.

frozenRows?

number

The number of frozen rows in this sheet.

name?

string

Sets the name of the exported workbook sheet.

rows?

WorkbookSheetRow[]

The array of rows of the sheet.

rtl?

boolean

Specifies if the sheet should use right to left direction.

state?

WorkbookSheetState

Specifies the sheet state.