This example is the second part of the SpreadsheetControl API set of examples that demonstrates how to use the SpreadsheetControl API to manage spreadsheet documents in code, without the need for Microsoft Excel to be installed.
This sample introduces API properties and methods used to perform the following operations:
- Insert, delete and modify pictures
- Add a hyperlink to a picture
- Add custom functions to the spreadsheet
- Create and format a 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 dynamic filter
- Sort filtered data
- Specify the built-in document properties
- Specify the custom document properties