PicoXLSX Library Documentation
PicoXLSX
Table of contents
-
PicoXLSX
-
PicoXLSX
-
AbstractStyle Class
-
AbstractStyle Constructor
-
AbstractStyle Properties
-
Hash Property
-
InternalID Property
-
AbstractStyle Methods
-
CalculateHash Method
-
CastValue Method
-
CompareTo Method
-
Copy Method
-
CopyProperties(T) Method
-
Equals Method
-
Equals Method (AbstractStyle)
-
AbstractStyle.AppendAttribute Class
-
AbstractStyle.AppendAttribute Constructor
-
AppendAttribute Properties
-
Ignore Property
-
NestedProperty Property
-
AppendAttribute Methods
-
Cell Class
-
Cell Constructor
-
Cell Constructor
-
Cell Constructor (Object, Cell.CellType)
-
Cell Constructor (Object, Cell.CellType, Int32, Int32, Worksheet)
-
Cell Properties
-
CellAddress Property
-
CellAddress2 Property
-
CellStyle Property
-
ColumnNumber Property
-
DataType Property
-
RowNumber Property
-
Value Property
-
WorksheetReference Property
-
Cell Methods
-
CompareTo Method
-
ConvertArray(T) Method
-
GetCellRange Method
-
GetCellRange Method (String)
-
GetCellRange Method (String, String)
-
GetCellRange Method (Cell.Address, Cell.Address)
-
GetCellRange Method (Int32, Int32, Int32, Int32)
-
RemoveStyle Method
-
ResolveCellAddress Method
-
ResolveCellCoordinate Method
-
ResolveCellCoordinate Method (String)
-
ResolveCellCoordinate Method (String, Int32, Int32)
-
ResolveCellRange Method
-
ResolveCellType Method
-
ResolveColumn Method
-
ResolveColumnAddress Method
-
SetCellLockedState Method
-
SetStyle Method
-
Cell.Address Structure
-
Address Constructor
-
Cell.Address Constructor (String)
-
Cell.Address Constructor (Int32, Int32)
-
Address Methods
-
Equals Method
-
Equals Method (Cell.Address)
-
GetAddress Method
-
ToString Method
-
Address Fields
-
Column Field
-
Row Field
-
Cell.BasicFormulas Class
-
BasicFormulas Methods
-
Average Method
-
Average Method (Cell.Range)
-
Average Method (Worksheet, Cell.Range)
-
Ceil Method
-
Ceil Method (Cell.Address, Int32)
-
Ceil Method (Worksheet, Cell.Address, Int32)
-
Floor Method
-
Floor Method (Cell.Address, Int32)
-
Floor Method (Worksheet, Cell.Address, Int32)
-
GetBasicFormula Method
-
GetVLookup Method
-
Max Method
-
Max Method (Cell.Range)
-
Max Method (Worksheet, Cell.Range)
-
Median Method
-
Median Method (Cell.Range)
-
Median Method (Worksheet, Cell.Range)
-
Min Method
-
Min Method (Cell.Range)
-
Min Method (Worksheet, Cell.Range)
-
Round Method
-
Round Method (Cell.Address, Int32)
-
Round Method (Worksheet, Cell.Address, Int32)
-
Sum Method
-
Sum Method (Cell.Range)
-
Sum Method (Worksheet, Cell.Range)
-
VLookup Method
-
VLookup Method (Object, Cell.Range, Int32, Boolean)
-
VLookup Method (Cell.Address, Cell.Range, Int32, Boolean)
-
VLookup Method (Object, Worksheet, Cell.Range, Int32, Boolean)
-
VLookup Method (Worksheet, Cell.Address, Worksheet, Cell.Range, Int32, Boolean)
-
Cell.CellType Enumeration
-
Cell.Range Structure
-
Range Constructor
-
Cell.Range Constructor (String)
-
Cell.Range Constructor (Cell.Address, Cell.Address)
-
Range Methods
-
ToString Method
-
Range Fields
-
EndAddress Field
-
StartAddress Field
-
FormatException Class
-
FormatException Constructor
-
FormatException Constructor
-
FormatException Constructor (String)
-
FormatException Constructor (String, String)
-
FormatException Constructor (String, String, Exception)
-
FormatException Properties
-
ExceptionTitle Property
-
FormatException Methods
-
FormatException Events
-
IOException Class
-
IOException Constructor
-
IOException Constructor
-
IOException Constructor (String, String)
-
IOException Constructor (String, String, Exception)
-
IOException Properties
-
ExceptionTitle Property
-
IOException Methods
-
IOException Events
-
LowLevel Class
-
LowLevel Constructor
-
LowLevel Constructor
-
LowLevel Properties
-
InterceptDocuments Property
-
InterceptedDocuments Property
-
LowLevel Methods
-
AppendXmlTag Method
-
AppendXmlToPackagePart Method
-
CreateAppPropertiesDocument Method
-
CreateAppString Method
-
CreateColsString Method
-
CreateCorePropertiesDocument Method
-
CreateCorePropertiesString Method
-
CreateMergedCellsString Method
-
CreateMruColorsString Method
-
CreateRowString Method
-
CreateSharedStringsDocument Method
-
CreateSheetProtectionString Method
-
CreateStyleBorderString Method
-
CreateStyleFillString Method
-
CreateStyleFontString Method
-
CreateStyleNumberFormatString Method
-
CreateStyleSheetDocument Method
-
CreateStyleXfsString Method
-
CreateWorkbookDocument Method
-
CreateWorksheetPart Method
-
EscapeXmlAttributeChars Method
-
EscapeXmlChars Method
-
GeneratePasswordHash Method
-
GetOADateTimeString Method
-
GetSortedSheetData Method
-
Save Method
-
SaveAsStream Method
-
LowLevel.DocumentPath Class
-
DocumentPath Constructor
-
LowLevel.DocumentPath Constructor
-
LowLevel.DocumentPath Constructor (String, String)
-
DocumentPath Properties
-
Filename Property
-
Path Property
-
DocumentPath Methods
-
GetFullPath Method
-
LowLevel.SortedMap Class
-
LowLevel.SortedMap Constructor
-
SortedMap Properties
-
Count Property
-
Item Property
-
Keys Property
-
Values Property
-
SortedMap Methods
-
Add Method
-
ContainsKey Method
-
Metadata Class
-
Metadata Constructor
-
Metadata Properties
-
Application Property
-
ApplicationVersion Property
-
Category Property
-
Company Property
-
ContentStatus Property
-
Creator Property
-
Description Property
-
HyperlinkBase Property
-
Keywords Property
-
Manager Property
-
Subject Property
-
Title Property
-
UseColorMRU Property
-
Metadata Methods
-
CheckVersion Method
-
ParseVersion Method
-
RangeException Class
-
RangeException Constructor
-
RangeException Constructor
-
RangeException Constructor (String, String)
-
RangeException Properties
-
ExceptionTitle Property
-
RangeException Methods
-
RangeException Events
-
Style Class
-
Style Constructor
-
Style Constructor
-
Style Constructor (String)
-
Style Constructor (String, Int32, Boolean)
-
Style Properties
-
CurrentBorder Property
-
CurrentCellXf Property
-
CurrentFill Property
-
CurrentFont Property
-
CurrentNumberFormat Property
-
IsInternalStyle Property
-
Name Property
-
StyleManagerReference Property
-
Style Methods
-
Append Method
-
CalculateHash Method
-
Copy Method
-
CopyStyle Method
-
ReorganizeStyle Method
-
ToString Method
-
Style.BasicStyles Class
-
BasicStyles Properties
-
Bold Property
-
BoldItalic Property
-
BorderFrame Property
-
BorderFrameHeader Property
-
DateFormat Property
-
DottedFill_0_125 Property
-
DoubleUnderline Property
-
Italic Property
-
MergeCellStyle Property
-
RoundFormat Property
-
Strike Property
-
Underline Property
-
BasicStyles Methods
-
ColorizedBackground Method
-
ColorizedText Method
-
Font Method
-
GetStyle Method
-
Style.BasicStyles.StyleEnum Enumeration
-
Style.Border Class
-
Style.Border Constructor
-
Border Properties
-
BottomColor Property
-
BottomStyle Property
-
DiagonalColor Property
-
DiagonalDown Property
-
DiagonalStyle Property
-
DiagonalUp Property
-
LeftColor Property
-
LeftStyle Property
-
RightColor Property
-
RightStyle Property
-
TopColor Property
-
TopStyle Property
-
Border Methods
-
CalculateHash Method
-
Copy Method
-
CopyBorder Method
-
GetStyleName Method
-
IsEmpty Method
-
ToString Method
-
Style.Border.StyleValue Enumeration
-
Style.CellXf Class
-
Style.CellXf Constructor
-
CellXf Properties
-
Alignment Property
-
ForceApplyAlignment Property
-
Hidden Property
-
HorizontalAlign Property
-
Locked Property
-
TextDirection Property
-
TextRotation Property
-
VerticalAlign Property
-
CellXf Methods
-
CalculateHash Method
-
CalculateInternalRotation Method
-
Copy Method
-
CopyCellXf Method
-
ToString Method
-
Style.CellXf.HorizontalAlignValue Enumeration
-
Style.CellXf.TextBreakValue Enumeration
-
Style.CellXf.TextDirectionValue Enumeration
-
Style.CellXf.VerticalAlignValue Enumeration
-
Style.Fill Class
-
Fill Constructor
-
Style.Fill Constructor
-
Style.Fill Constructor (String, Style.Fill.FillType)
-
Style.Fill Constructor (String, String)
-
Fill Properties
-
BackgroundColor Property
-
ForegroundColor Property
-
IndexedColor Property
-
PatternFill Property
-
Fill Methods
-
CalculateHash Method
-
Copy Method
-
CopyFill Method
-
GetPatternName Method
-
SetColor Method
-
ToString Method
-
Fill Fields
-
DEFAULTCOLOR Field
-
Style.Fill.FillType Enumeration
-
Style.Fill.PatternValue Enumeration
-
Style.Font Class
-
Style.Font Constructor
-
Font Properties
-
Bold Property
-
Charset Property
-
ColorTheme Property
-
ColorValue Property
-
DoubleUnderline Property
-
Family Property
-
IsDefaultFont Property
-
Italic Property
-
Name Property
-
Scheme Property
-
Size Property
-
Strike Property
-
Underline Property
-
VerticalAlign Property
-
Font Methods
-
CalculateHash Method
-
Copy Method
-
CopyFont Method
-
ToString Method
-
Font Fields
-
DEFAULTFONT Field
-
Style.Font.SchemeValue Enumeration
-
Style.Font.VerticalAlignValue Enumeration
-
Style.NumberFormat Class
-
Style.NumberFormat Constructor
-
NumberFormat Properties
-
CustomFormatCode Property
-
CustomFormatID Property
-
IsCustomFormat Property
-
Number Property
-
NumberFormat Methods
-
CalculateHash Method
-
Copy Method
-
CopyNumberFormat Method
-
ToString Method
-
NumberFormat Fields
-
CUSTOMFORMAT_START_NUMBER Field
-
Style.NumberFormat.FormatNumber Enumeration
-
StyleException Class
-
StyleException Constructor
-
StyleException Constructor
-
StyleException Constructor (String, String)
-
StyleException Properties
-
ExceptionTitle Property
-
StyleException Methods
-
StyleException Events
-
StyleManager Class
-
StyleManager Constructor
-
StyleManager Methods
-
AddStyle Method
-
AddStyleComponent Method
-
AddStyleComponent Method (AbstractStyle)
-
AddStyleComponent Method (AbstractStyle, Nullable(Int32))
-
CleanupStyleComponents Method
-
GetBorderByHash Method
-
GetBorders Method
-
GetBorderStyleNumber Method
-
GetCellXfByHash Method
-
GetCellXfs Method
-
GetCellXfStyleNumber Method
-
GetComponentByHash Method
-
GetFillByHash Method
-
GetFills Method
-
GetFillStyleNumber Method
-
GetFontByHash Method
-
GetFonts Method
-
GetFontStyleNumber Method
-
GetNumberFormatByHash Method
-
GetNumberFormats Method
-
GetNumberFormatStyleNumber Method
-
GetStyleByHash Method
-
GetStyleByName Method
-
GetStyleNumber Method
-
GetStyles Method
-
IsUsedByStyle Method
-
RemoveStyle Method
-
Reorganize Method
-
StyleManager Fields
-
BORDERPREFIX Field
-
CELLXFPREFIX Field
-
FILLPREFIX Field
-
FONTPREFIX Field
-
NUMBERFORMATPREFIX Field
-
STYLEPREFIX Field
-
Workbook Class
-
Workbook Constructor
-
Workbook Constructor (Boolean)
-
Workbook Constructor (String)
-
Workbook Constructor (String, String)
-
Workbook Constructor (String, String, Boolean)
-
Workbook Properties
-
CurrentWorksheet Property
-
Filename Property
-
LockStructureIfProtected Property
-
LockWindowsIfProtected Property
-
SelectedWorksheet Property
-
Styles Property
-
UseWorkbookProtection Property
-
WorkbookMetadata Property
-
WorkbookProtectionPassword Property
-
Worksheets Property
-
WS Property
-
Workbook Methods
-
AddStyle Method
-
AddStyleComponent Method
-
AddWorksheet Method
-
AddWorksheet Method (String)
-
AddWorksheet Method (Worksheet)
-
AddWorksheet Method (String, Boolean)
-
Init Method
-
RemoveStyle Method
-
RemoveStyle Method (String)
-
RemoveStyle Method (Style)
-
RemoveStyle Method (String, Boolean)
-
RemoveStyle Method (Style, Boolean)
-
RemoveWorksheet Method
-
ResolveMergedCells Method
-
Save Method
-
SaveAs Method
-
SaveAsStream Method
-
SetCurrentWorksheet Method
-
SetSelectedWorksheet Method
-
SetSelectedWorksheet Method (Int32)
-
SetSelectedWorksheet Method (Worksheet)
-
SetWorkbookProtection Method
-
Workbook.Shortener Class
-
Workbook.Shortener Constructor
-
Shortener Methods
-
Down Method
-
Down Method
-
Down Method (Int32)
-
Formula Method
-
Formula Method (String)
-
Formula Method (String, Style)
-
NullCheck Method
-
Right Method
-
Right Method
-
Right Method (Int32)
-
SetCurrentWorksheet Method
-
Value Method
-
Value Method (Object)
-
Value Method (Object, Style)
-
Worksheet Class
-
Worksheet Constructor
-
Worksheet Constructor
-
Worksheet Constructor (String, Int32, Workbook)
-
Worksheet Properties
-
AutoFilterRange Property
-
Cells Property
-
Columns Property
-
CurrentCellDirection Property
-
DefaultColumnWidth Property
-
DefaultRowHeight Property
-
HiddenRows Property
-
MergedCells Property
-
RowHeights Property
-
SelectedCells Property
-
SheetID Property
-
SheetName Property
-
SheetProtectionPassword Property
-
SheetProtectionValues Property
-
UseSheetProtection Property
-
WorkbookReference Property
-
Worksheet Methods
-
AddAllowedActionOnSheetProtection Method
-
AddCell Method
-
AddCell Method (Object, String)
-
AddCell Method (Object, Int32, Int32)
-
AddCell Method (Object, String, Style)
-
AddCell Method (Object, Int32, Int32, Style)
-
AddCellFormula Method
-
AddCellFormula Method (String, String)
-
AddCellFormula Method (String, Int32, Int32)
-
AddCellFormula Method (String, String, Style)
-
AddCellFormula Method (String, Int32, Int32, Style)
-
AddCellRange Method
-
AddCellRange Method (List(Object), String)
-
AddCellRange Method (List(Object), Cell.Address, Cell.Address)
-
AddCellRange Method (List(Object), String, Style)
-
AddCellRange Method (List(Object), Cell.Address, Cell.Address, Style)
-
AddCellRangeInternal(T) Method
-
AddHiddenColumn Method
-
AddHiddenColumn Method (Int32)
-
AddHiddenColumn Method (String)
-
AddHiddenRow Method
-
AddNextCell Method
-
AddNextCell Method (Object)
-
AddNextCell Method (Object, Style)
-
AddNextCell Method (Cell, Boolean, Style)
-
AddNextCellFormula Method
-
AddNextCellFormula Method (String)
-
AddNextCellFormula Method (String, Style)
-
CastValue Method
-
ClearActiveStyle Method
-
GetCell Method
-
GetCell Method (Cell.Address)
-
GetCell Method (Int32, Int32)
-
GetCurrentColumnNumber Method
-
GetCurrentRowNumber Method
-
GetLastAddress Method
-
GetLastColumnNumber Method
-
GetLastRowNumber Method
-
GoToNextColumn Method
-
GoToNextColumn Method
-
GoToNextColumn Method (Int32)
-
GoToNextRow Method
-
GoToNextRow Method
-
GoToNextRow Method (Int32)
-
HasCell Method
-
HasCell Method (Cell.Address)
-
HasCell Method (Int32, Int32)
-
MergeCells Method
-
MergeCells Method (String)
-
MergeCells Method (Cell.Range)
-
MergeCells Method (Cell.Address, Cell.Address)
-
RecalculateAutoFilter Method
-
RecalculateColumns Method
-
RemoveAutoFilter Method
-
RemoveCell Method
-
RemoveCell Method (String)
-
RemoveCell Method (Int32, Int32)
-
RemoveHiddenColumn Method
-
RemoveHiddenColumn Method (Int32)
-
RemoveHiddenColumn Method (String)
-
RemoveHiddenRow Method
-
RemoveMergedCells Method
-
RemoveSelectedCells Method
-
SanitizeWorksheetName Method
-
SetActiveStyle Method
-
SetAutoFilter Method
-
SetAutoFilter Method (String)
-
SetAutoFilter Method (Int32, Int32)
-
SetColumnHiddenState Method
-
SetColumnWidth Method
-
SetColumnWidth Method (Int32, Single)
-
SetColumnWidth Method (String, Single)
-
SetCurrentCellAddress Method
-
SetCurrentCellAddress Method (String)
-
SetCurrentCellAddress Method (Int32, Int32)
-
SetCurrentColumnNumber Method
-
SetCurrentRowNumber Method
-
SetRowHeight Method
-
SetRowHiddenState Method
-
SetSelectedCells Method
-
SetSelectedCells Method (String)
-
SetSelectedCells Method (Cell.Range)
-
SetSelectedCells Method (Cell.Address, Cell.Address)
-
SetSheetname Method
-
SetSheetName Method
-
SetSheetProtectionPassword Method
-
WorksheetExists Method
-
Worksheet Fields
-
DEFAULT_COLUMN_WIDTH Field
-
DEFAULT_ROW_HEIGHT Field
-
MAX_COLUMN_NUMBER Field
-
MAX_COLUMN_WIDTH Field
-
MAX_ROW_HEIGHT Field
-
MAX_ROW_NUMBER Field
-
MIN_COLUMN_NUMBER Field
-
MIN_COLUMN_WIDTH Field
-
MIN_ROW_HEIGHT Field
-
MIN_ROW_NUMBER Field
-
Worksheet.CellDirection Enumeration
-
Worksheet.Column Class
-
Column Constructor
-
Worksheet.Column Constructor
-
Worksheet.Column Constructor (Int32)
-
Worksheet.Column Constructor (String)
-
Column Properties
-
ColumnAddress Property
-
HasAutoFilter Property
-
IsHidden Property
-
Number Property
-
Width Property
-
Column Methods
-
Worksheet.SheetProtectionValue Enumeration
-
WorksheetException Class
-
WorksheetException Constructor
-
WorksheetException Constructor
-
WorksheetException Constructor (String, String)
-
WorksheetException Properties
-
ExceptionTitle Property
-
WorksheetException Methods
-
WorksheetException Events