This example demonstrates how to use the Excel Export Library to create spreadsheet files in XLSX, XLS and CSV formats.
Important
The Universal Subscription or an additional Office File API Subscription is required to use this example in production code. For pricing information, please refer to the DevExpress Subscription page.
This project introduces API properties and methods used to perform the following operations:
- Create a workbook, worksheets,rows, columns and particular cells
- Apply predefined, themed and custom formatting to worksheet cells
- Apply conditional formatting rules
- Enable filtering and group data
- Apply data validation rules
- Assign formulas to worksheet cells
- Specify page settings
- Specify print options
- Insert pictures
- Insert hyperlinks
- Specify document properties
- Insert and modify sparklines
- Apply different fonts to specific text regions within a cell
- Create image hyperlinks
- Display a worksheet from right to left
- Create a table
- Apply a table style to a table
- Format the table elements
- Total data in a table
- Create calculated columns
- Password protect a document
- Filter the data by a list of values
- Apply a number filter
- Apply a date filter
- Apply a dynamic filter
- Apply a Top 10 filter
- Filter by a fill color
- CellFormattingActions.cs (VB: CellFormattingActions.vb)
- ConditionalFormattingActions.cs (VB: ConditionalFormattingActions.vb)
- DataActions.cs (VB: DataActions.vb)
- FormulaActions.cs (VB: FormulaActions.vb)
- GeneralActions.cs (VB: GeneralActions.vb)
- MiscellaneousActions.cs (VB: MiscellaneousActions.vb)
- PageViewAndLayoutActions.cs (VB: PageViewAndLayoutActions.vb)
- PictureActions.cs (VB: PictureActions.vb)
- SparklineActions.cs (VB: SparklineActions.vb)
- TableActions.cs (VB: TableActions.vb)
- Get Started with the Excel Export Library - Generate an Excel File
- Excel Export Library Overview
- How to: Create a New Document
- How to: Create a New Worksheet
- Rows and Columns
(you will be redirected to DevExpress.com to submit your response)