PicoXLSX Library Documentation
 | PicoXLSX Namespace |
PicoXLSX is a library to generate XLSX files in an easy and native way
Classes| Class | Description | |
|---|---|---|
 | AbstractStyle |
Class represents an abstract style component
|
| AbstractStyleAppendAttribute |
Attribute designated to control the copying of style properties
|
| Cell |
Class representing a cell of a worksheet
|
| CellBasicFormulas |
Class for handling of basic Excel formulas
|
| FormatException |
Class for exceptions regarding format error incidents
|
| IOException |
Class for exceptions regarding stream or save error incidents
|
 | LowLevel |
Class for low level handling (XML, formatting, packing)
|
| LowLevelDocumentPath |
Class to manage XML document paths
|
| LowLevelSortedMap |
Class to manage key value pairs (string / string). The entries are in the order how they were added
|
| Metadata |
Class representing the meta data of a workbook
|
| RangeException |
Class for exceptions regarding range incidents (e.g. out-of-range)
|
| Style |
Class representing a Style with sub classes within a style sheet. An instance of this class is only a container for the different sub-classes. These sub-classes contain the actual styling information.
|
| StyleBasicStyles |
Factory class with the most important predefined styles
|
| StyleBorder |
Class representing a Border entry. The Border entry is used to define frames and cell borders
|
| StyleCellXf |
Class representing an XF entry. The XF entry is used to make reference to other style instances like Border or Fill and for the positioning of the cell content
|
| StyleFill |
Class representing a Fill (background) entry. The Fill entry is used to define background colors and fill patterns
|
| StyleFont |
Class representing a Font entry. The Font entry is used to define text formatting
|
| StyleNumberFormat |
Class representing a NumberFormat entry. The NumberFormat entry is used to define cell formats like currency or date
|
| StyleException |
Class for exceptions regarding Style incidents
|
| StyleManager |
Class representing a style manager to maintain all styles and its components of a workbook
|
| Workbook |
Class representing a workbook
|
| WorkbookShortener |
Class to provide access to the current worksheet with a shortened syntax. Note: The WS object can be null if the workbook was created without a worksheet. The object will be available as soon as the current worksheet is defined
|
| Worksheet |
Class representing a worksheet of a workbook
|
| WorksheetColumn |
Class representing a column of a worksheet
|
| WorksheetException |
Class for exceptions regarding worksheet incidents
|
Structures| Structure | Description | |
|---|---|---|
 | CellAddress |
Struct representing the cell address as column and row (zero based)
|
| CellRange |
Struct representing a cell range with a start and end address
|
Enumerations| Enumeration | Description | |
|---|---|---|
 | CellCellType |
Enum defines the basic data types of a cell
|
 | StyleBasicStylesStyleEnum |
Enum with style selection
|
| StyleBorderStyleValue |
Enum for the border style
|
| StyleCellXfHorizontalAlignValue |
Enum for the horizontal alignment of a cell
|
| StyleCellXfTextBreakValue |
Enum for text break options
|
| StyleCellXfTextDirectionValue |
Enum for the general text alignment direction
|
| StyleCellXfVerticalAlignValue |
Enum for the vertical alignment of a cell
|
| StyleFillFillType |
Enum for the type of the color
|
| StyleFillPatternValue |
Enum for the pattern values
|
| StyleFontSchemeValue |
Enum for the font scheme
|
| StyleFontVerticalAlignValue |
Enum for the vertical alignment of the text from base line
|
| StyleNumberFormatFormatNumber |
Enum for predefined number formats
|
| WorksheetCellDirection |
Enum to define the direction when using AddNextCell method
|
| WorksheetSheetProtectionValue |
Enum to define the possible protection types when protecting a worksheet
|