The WinForms Spreadsheet Control allows you to create high-impact business data analysis solutions that emulate the look, feel and capabilities of Microsoft Excel®. It includes full integration with the DevExpress Ribbon control so you can deliver Excel inspired functionality with minimal effort.
This example demonstrates how to use the Spreadsheet API to execute the following actions:
- Insert, delete and modify pictures
- Add a hyperlink to a picture
- Add custom functions to the spreadsheet
- Create a table
- Apply a custom style to the table
- Protect a workbook
- Protect a worksheet
- Apply user-specific permissions to a range in a protected worksheet
- Sort a range in descending and ascending orders
- Sort using a custom comparer
- Sort by multiple columns
- Simple search
- Search with options
- Export to HTML
- Group and outline data
- Insert subtotals
- Filter the data by a list of values
- Apply a number filter
- Apply a text filter
- Apply a dynamic filter
- Sort the filtered data
- Specify the built-in document properties
- Specify the custom document properties
- AutoFilterActions.cs (VB: AutoFilterActions.vb)
- CustomFunctionActions.cs (VB: CustomFunctionActions.vb)
- DocumentPropertiesActions.cs (VB: DocumentPropertiesActions.vb)
- ExportActions.cs (VB: ExportActions.vb)
- GroupAndOutlineActions.cs (VB: GroupAndOutlineActions.vb)
- PictureActions.cs (VB: PictureActions.vb)
- ProtectionActions.cs (VB: ProtectionActions.vb)
- SearchActions.cs (VB: SearchActions.vb)
- SortActions.cs (VB: SortActions.vb)
- TableActions.cs (VB: TableActions.vb)