Getting Started
Components
- Barcodes
- Buttons
- Chartsupdated
- Conversational UIupdated
- Data Query
- Date Inputsupdated
- Date Math
- Dialogs
- Drawing
- Dropdownsupdated
- Editor
- Excel Export
- - Overview
  - Getting Started
  - Columns
  - Cells
  - Workbook
  - Filtering
  - Saving Files on the Server
  - Globalization
  - API
- File Saver
- Filter
- Gantt
- Gauges
- Gridupdated
- Icons
- Indicators
- Inputsupdated
- Labels
- Layout
- 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

Components / Excel Export / API / WorkbookSheet /

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

WorkbookSheet

The workbook sheets options.

Name	Type	Default	Description
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.

Is this article helpful?

Thank you for your feedback!