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
|