This example is the third 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:
- Apply data validation to control the type of data or the values that users enter into a cell
- Remove rows and columns that meet the specified condition
- Custom XML Parts examples