PicoXLSX Namespace

PicoXLSX

PicoXLSX

PicoXLSX Namespace

PicoXLSX is a library to generate XLSX files in an easy and native way
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 classCellBasicFormulas
Class for handling of basic Excel formulas
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)
Public classLowLevelDocumentPath
Class to manage XML document paths
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
Public classStyleBorder
Class representing a Border entry. The Border entry is used to define frames and cell borders
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 classStyleFill
Class representing a Fill (background) entry. The Fill entry is used to define background colors and fill patterns
Public classStyleFont
Class representing a Font entry. The Font entry is used to define text formatting
Public classStyleNumberFormat
Class representing a NumberFormat entry. The NumberFormat entry is used to define cell formats like currency or date
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 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 classWorksheetColumn
Class representing a column of a worksheet
Public classWorksheetException
Class for exceptions regarding worksheet incidents
Structures
  StructureDescription
Public structureCellAddress
Struct representing the cell address as column and row (zero based)
Public structureCellRange
Struct representing a cell range with a start and end address
Enumerations
  EnumerationDescription
Public enumerationCellCellType
Enum defines the basic data types of a cell
Private enumerationStyleBasicStylesStyleEnum
Enum with style selection
Public enumerationStyleBorderStyleValue
Enum for the border style
Public enumerationStyleCellXfHorizontalAlignValue
Enum for the horizontal alignment of a cell
Public enumerationStyleCellXfTextBreakValue
Enum for text break options
Public enumerationStyleCellXfTextDirectionValue
Enum for the general text alignment direction
Public enumerationStyleCellXfVerticalAlignValue
Enum for the vertical alignment of a cell
Public enumerationStyleFillFillType
Enum for the type of the color
Public enumerationStyleFillPatternValue
Enum for the pattern values
Public enumerationStyleFontSchemeValue
Enum for the font scheme
Public enumerationStyleFontVerticalAlignValue
Enum for the vertical alignment of the text from base line
Public enumerationStyleNumberFormatFormatNumber
Enum for predefined number formats
Public enumerationWorksheetCellDirection
Enum to define the direction when using AddNextCell method
Public enumerationWorksheetSheetProtectionValue
Enum to define the possible protection types when protecting a worksheet