Click or drag to resize
PicoXLSX

PicoXLSX Namespace

PicoXLSX is a library to generate XLSX files in an easy and native way

The namespace PicoXLSX contains all classes of the library

Classes
 ClassDescription
Public classAbstractStyle Class represents an abstract style component
Public classAbstractStyleAppendAttribute Attribute designated to control the copying of style properties
Public classCell Class representing a cell of a worksheet
Public classCellAddress Struct representing the cell address as column and row (zero based)
Public classCellAddressScope Enum to define the scope of a passed address string (used in static context)
Public classCellAddressType Enum for the referencing style of the address
Public classCellBasicFormulas Class for handling of basic Excel formulas
Public classCellCellType Enum defines the basic data types of a cell
Public classCellRange Struct representing a cell range with a start and end address
Public classFormatException Class for exceptions regarding format error incidents
Public classIOException Class for exceptions regarding stream or save error incidents
Protected classLowLevel Class for low level handling (XML, formatting, packing)
Protected classLowLevelDocumentPath Class to manage XML document paths
Private classLowLevelDynamicRow Class representing a row that is either empty or containing cells. Empty rows can also carry information about height or visibility
Public classLowLevelSortedMap Class to manage key value pairs (string / string). The entries are in the order how they were added
Public classMetadata Class representing the meta data of a workbook
Public classRangeException Class for exceptions regarding range incidents (e.g. out-of-range)
Public classStyle 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
Public classStyleBasicStyles Factory class with the most important predefined styles
Private classStyleBasicStylesStyleEnum Enum with style selection
Public classStyleBorder Class representing a Border entry. The Border entry is used to define frames and cell borders
Public classStyleBorderStyleValue Enum for the border style
Public classStyleCellXf 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
Public classStyleCellXfHorizontalAlignValue Enum for the horizontal alignment of a cell
Public classStyleCellXfTextBreakValue Enum for text break options
Public classStyleCellXfTextDirectionValue Enum for the general text alignment direction
Public classStyleCellXfVerticalAlignValue Enum for the vertical alignment of a cell
Public classStyleFill Class representing a Fill (background) entry. The Fill entry is used to define background colors and fill patterns
Public classStyleFillFillType Enum for the type of the color
Public classStyleFillPatternValue Enum for the pattern values
Public classStyleFont Class representing a Font entry. The Font entry is used to define text formatting
Public classStyleFontSchemeValue Enum for the font scheme
Public classStyleFontUnderlineValue Enum for the style of the underline property of a stylized text
Public classStyleFontVerticalAlignValue Enum for the vertical alignment of the text from base line
Public classStyleNumberFormat Class representing a NumberFormat entry. The NumberFormat entry is used to define cell formats like currency or date
Public classStyleNumberFormatFormatNumber Enum for predefined number formats
Public classStyleNumberFormatFormatRange Range or validity of the format number
Public classStyleException Class for exceptions regarding Style incidents
Public classStyleManager Class representing a style manager to maintain all styles and its components of a workbook
Public classStyleRepository Class to manage all styles at runtime, before writing XLSX files. The main purpose is deduplication and decoupling of styles from workbooks at runtime
Public classWorkbook Class representing a workbook
Public classWorkbookShortener 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
Public classWorksheet Class representing a worksheet of a workbook
Public classWorksheetCellDirection Enum to define the direction when using AddNextCell method
Public classWorksheetColumn Class representing a column of a worksheet
Public classWorksheetSheetProtectionValue Enum to define the possible protection types when protecting a worksheet
Public classWorksheetSheetViewType Enum to define how a worksheet is displayed in the spreadsheet application (Excel)
Public classWorksheetWorksheetPane Enum to define the pane position or active pane in a slip worksheet
Public classWorksheetException Class for exceptions regarding worksheet incidents