This example demonstrates how to use the Excel Export Library to create spreadsheet files in XLSX, XLS and CSV formats.
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)