documentation
.HELP!
PicoXLSX Documentation
LowLevel Constructor
PicoXLSX
previous page
next page
PicoXLSX Library Documentation
LowLevel Constructor
Initializes the static fields of the
LowLevel
class
Namespace:
PicoXLSX
Assembly:
PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
Syntax
C#
Copy
static
LowLevel
()
See Also
Reference
LowLevel Class
PicoXLSX Namespace
Copyright Raphael Stoeckli © 2018
previous page
start
next page
Menu
Homepage
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
Get in touch
Submit feedback about this site to:
[email protected]
SyntaxSee Also