PicoXLSX Library Documentation
 | Workbook Methods |
The Workbook type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddStyle |
Adds a style to the style manager
|
| AddStyleComponent |
Adds a style component to a style
|
| 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
|
| Equals | (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 a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
 | Init |
Init method called in the constructors
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| RemoveStyle(String) |
Removes the defined style from the style sheet of the workbook
|
| RemoveStyle(Style) |
Removes the passed style from the style sheet
|
| RemoveStyle(String, Boolean) |
Removes the defined style from the style sheet of the workbook
|
| RemoveStyle(Style, Boolean) |
Removes the defined style from the style sheet of the workbook
|
| RemoveWorksheet |
Removes the defined worksheet
|
| 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.
|
| Save |
Saves the workbook
|
| SaveAs |
Saves the workbook with the defined name
|
| SaveAsStream |
Save the workbook to a writable stream
|
| SetCurrentWorksheet |
Sets the current worksheet
|
| SetSelectedWorksheet(Int32) |
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.) |
See Also