Name | Description | |
---|---|---|
CalculateFormulas | Starts the calculation for all the Worksheet's cells containing a formula and update their Value properties. | |
Clear | Clears specific elements in the Worksheet. | |
DeleteColumns | Overloaded. Deletes Columns at a specific index in the Worksheet. | |
DeleteRange | Overloaded. Deletes a CellRange and allows to specify in which direction the Cells located after the deleted range will be shifted. | |
DeleteRows | Deletes Rows at a specific index in the Worksheet. | |
ImportData | Imports data of type Array, 2D-Array, ArrayList, ICollection, IDictionary, DataTable, DataView or CSV path/stream in a Worksheet. | |
InsertColumns | Overloaded. Inserts new Columns at a specific index in the Worksheet. | |
InsertRange | Overloaded. Inserts an empty CellRange and allows to specify in which direction the Cells located after the inserted range will be shifted. | |
InsertRows | Inserts new Rows at a specific index in the Worksheet. | |
Protect | Protects a Worksheet by enabling or disabling specific actions. This can be done with or without a password. | |
ReplaceContent | Searches into the content of the Worksheet and replaces all occurences of a specific value with a new value. | |
Unprotect | Unprotects a Worksheet. |