 | Workbook Methods |
The Workbook type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddMruColor | Adds a color value (HEX; 6-digit RGB or 8-digit ARGB) to the MRU list |
| AddStyle | Obsolete. Adds a style to the style repository. This method is deprecated since it has no direct impact on the generated file |
| AddStyleComponent | Obsolete. Adds a style component to a style. This method is deprecated since it has no direct impact on the generated file |
| AddWorksheet(String) | Adding a new Worksheet. The new worksheet will be defined as current worksheet |
| AddWorksheet(Worksheet) | Adding a new Worksheet. The new worksheet will be defined as current worksheet |
| AddWorksheet(String, Boolean) | Adding a new Worksheet with a sanitizing option. The new worksheet will be defined as current worksheet |
| AddWorksheet(Worksheet, Boolean) | Adding a new Worksheet. The new worksheet will be defined as current worksheet |
| ClearMruColors | Clears the MRU color list |
| CopyWorksheetIntoThis(Int32, String, Boolean) | Copies a worksheet of the current workbook by its index |
| CopyWorksheetIntoThis(String, String, Boolean) | Copies a worksheet of the current workbook by its name |
| CopyWorksheetIntoThis(Worksheet, String, Boolean) | Copies a worksheet of any workbook into the current workbook |
| CopyWorksheetTo(Int32, String, Workbook, Boolean) | Copies a worksheet of the current workbook by its index into another workbook |
| CopyWorksheetTo(String, String, Workbook, Boolean) | Copies a worksheet of the current workbook by its name into another workbook |
 | CopyWorksheetTo(Worksheet, String, Workbook, Boolean) | Copies a worksheet of any workbook into the another workbook |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetMruColors | Gets the MRU color list |
 | GetNextWorksheetId | Gets the next free worksheet ID |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetWorksheet(Int32) | Gets a worksheet from this workbook by index |
| GetWorksheet(String) | Gets a worksheet from this workbook by name |
| Init | Init method called in the constructors |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| RemoveStyle(String) | Obsolete. Removes the defined style from the style sheet of the workbook. This method is deprecated since it has no direct impact on the generated file |
| RemoveStyle(Style) | Obsolete. Removes the passed style from the style sheet. This method is deprecated since it has no direct impact on the generated file |
| RemoveStyle(String, Boolean) | Obsolete. Removes the defined style from the style sheet of the workbook. This method is deprecated since it has no direct impact on the generated file |
| RemoveStyle(Style, Boolean) | Obsolete. Removes the defined style from the style sheet of the workbook |
| RemoveWorksheet(Int32) | Removes the defined worksheet based on its index. If the worksheet is the current or selected worksheet, the current and / or the selected worksheet will be set to the last worksheet of the workbook Removes the defined worksheet based on its index. If the worksheet is the current or selected worksheet, the current and / or the selected worksheet will be set to the last worksheet of the workbook |
| RemoveWorksheet(String) | Removes the defined worksheet based on its name. If the worksheet is the current or selected worksheet, the current and / or the selected worksheet will be set to the last worksheet of the workbook Removes the defined worksheet based on its name. If the worksheet is the current or selected worksheet, the current and / or the selected worksheet will be set to the last worksheet of the workbook |
| RemoveWorksheet(Int32, Boolean) | Removes the worksheet at the defined index and relocates current and selected worksheet references |
| ResolveMergedCells |
Method to resolve all merged cells in all worksheets. Only the value of the very first cell of the locked cells range will be visible. The other values are still present (set to EMPTY) but will not be stored in the worksheet. This is an internal method. There is no need to use it |
| Save | Saves the workbook |
| SaveAs | Saves the workbook with the defined name |
| SaveAsAsync | Saves the workbook with the defined name asynchronous |
| SaveAsStream | Save the workbook to a writable stream |
| SaveAsStreamAsync | Save the workbook to a writable stream asynchronous |
| SaveAsync | Saves the workbook asynchronous |
| SetCurrentWorksheet(Int32) | Sets the current worksheet |
| SetCurrentWorksheet(String) | Sets the current worksheet |
| SetCurrentWorksheet(Worksheet) | Sets the current worksheet |
| SetSelectedWorksheet(Int32) | Sets the selected worksheet in the output workbook |
| SetSelectedWorksheet(String) | Sets the selected worksheet in the output workbook |
| SetSelectedWorksheet(Worksheet) | Sets the selected worksheet in the output workbook |
| SetWorkbookProtection | Sets or removes the workbook protection. If protectWindows and protectStructure are both false, the workbook will not be protected |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| ValidateWorksheets |
Validates the worksheets regarding several conditions that must be met: - At least one worksheet must be defined - A hidden worksheet cannot be the selected one - At least one worksheet must be visible If one of the conditions is not met, an exception is thrown |
See Also