sync toc
GemBox.Spreadsheet
AbstractRange Class
AbstractRange Members
Properties
Comment Property
Formula Property
IsStyleDefault Property
Style Property
Value Property
Methods
SetBorders Method
AnchorCell Class
AnchorCell Members
AnchorCell Constructor
AnchorCell Constructor (ExcelColumn, ExcelRow, Int64, Int64)
AnchorCell Constructor (ExcelColumn, ExcelRow, Boolean)
AnchorCell Constructor (AnchorCell)
Properties
Column Property
ColumnOffset Property
Row Property
RowOffset Property
Methods
Equals Method
GetHashCode Method
CellBorder Class
CellBorder Members
Properties
LineColor Property
LineStyle Property
Methods
SetBorder Method
CellBorders Class
CellBorders Members
Properties
Item Property
Methods
SetBorders Method
CellRange Class
CellRange Members
Properties
Comment Property
EndPosition Property
FirstColumnIndex Property
FirstRowIndex Property
Formula Property
Height Property
IndexingMode Property
IsAnyCellMerged Property
IsStyleDefault Property
Item Property
Item Property (Int32)
Item Property (Int32, Int32)
Item Property (String)
LastColumnIndex Property
LastRowIndex Property
Merged Property
StartPosition Property
Style Property
Value Property
Width Property
Methods
CopyTo Method
CopyTo Method (ExcelWorksheet, Int32, Int32)
CopyTo Method (ExcelWorksheet, String)
CopyTo Method (Int32, Int32)
CopyTo Method (String)
Equals Method
ExportToHtml Method
ExportToHtml Method (String, HtmlExporterOptions, Boolean)
ExportToHtml Method (XmlTextWriter, HtmlExporterOptions, Boolean)
FindText Method
GetEnumerator Method
GetHashCode Method
GetReadEnumerator Method
GetSubrange Method
GetSubrangeAbsolute Method
GetSubrangeRelative Method
Overlaps Method
PositionToRowColumn Method
RowColumnToPosition Method
SetBorders Method
ToString Method
CellRangeEnumerator Class
CellRangeEnumerator Members
Properties
Current Property
CurrentCell Property
CurrentColumn Property
CurrentRow Property
Parent Property
Methods
MoveNext Method
Reset Method
CellStyle Class
CellStyle Members
CellStyle Constructor
CellStyle Constructor ()
CellStyle Constructor (ExcelFile)
Properties
Borders Property
FillPattern Property
Font Property
FormulaHidden Property
HorizontalAlignment Property
Indent Property
IsDefault Property
IsTextVertical Property
Locked Property
NumberFormat Property
Rotation Property
ShrinkToFit Property
VerticalAlignment Property
WrapText Property
CsvType Enumeration
DefaultHtmlExporter Class
DefaultHtmlExporter Members
Methods
DefaultCellStyleToHtml Method
DefaultCellToHtml Method
DefaultCellValueToHtml Method
DefaultColumnLettersToHtml Method
DefaultColumnLetterToHtml Method
DefaultPageToHtml Method
DefaultRowNumberToHtml Method
DefaultRowToHtml Method
DefaultTableToHtml Method
DefinedName Class
DefinedName Members
Properties
LocalSheetIndex Property
Name Property
Value Property
DefinedNameCollection Class
DefinedNameCollection Members
Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Methods
AddDefinedName Method
Clear Method
GetEnumerator Method
RemoveDefinedName Method
RemoveDefinedNameAt Method
ExcelCell Class
ExcelCell Members
Properties
Comment Property
Formula Property
HasHyperlink Property
Hyperlink Property
IsStyleDefault Property
MergedRange Property
Style Property
Value Property
Methods
ConvertExcelNumberToDateTime Method
SetBorders Method
ExcelCellCollection Class
ExcelCellCollection Members
Properties
Item Property
ExcelColumn Class
ExcelColumn Members
Properties
Cells Property
Width Property
Methods
AutoFit Method
AutoFitAdvanced Method
AutoFitAdvanced Method (Single)
AutoFitAdvanced Method (Single, ExcelRow, ExcelRow)
Delete Method
InsertCopy Method
InsertEmpty Method
ExcelColumnCollection Class
ExcelColumnCollection Members
Properties
Item Property
Item Property (Int32)
Item Property (String)
Methods
ColumnIndexToName Method
ColumnNameToIndex Method
ExcelColumnRowBase Class
ExcelColumnRowBase Members
Properties
Collapsed Property
Hidden Property
Index Property
IsStyleDefault Property
OutlineLevel Property
Style Property
ExcelComment Class
ExcelComment Members
Properties
Author Property
IsVisible Property
Text Property
ExcelFile Class
ExcelFile Members
ExcelFile Constructor
Fields
MaxColumns Field
MaxRows Field
MaxXlsCellStyles Field
MaxXlsColors Field
MaxXlsColumns Field
MaxXlsRows Field
Properties
CsvParseNumbersDuringLoad Property
DefaultFontName Property
DefaultFontSize Property
DefinedNames Property
DelayFormulaParse Property
GroupMethodsAffectedCellsLimit Property
Protected Property
RowColumnResolutionMethod Property
Use1904DateSystem Property
Worksheets Property
Methods
ClosePreservedXlsx Method
LoadCsv Method
LoadCsv Method (Stream, CsvType)
LoadCsv Method (Stream, Char)
LoadCsv Method (StreamReader, CsvType)
LoadCsv Method (StreamReader, Char)
LoadCsv Method (String, CsvType)
LoadCsv Method (String, Char)
LoadXls Method
LoadXls Method (Stream)
LoadXls Method (Stream, XlsOptions)
LoadXls Method (String)
LoadXls Method (String, XlsOptions)
LoadXlsx Method
LoadXlsx Method (Stream, XlsxOptions)
LoadXlsx Method (String, XlsxOptions)
LoadXlsxFromDirectory Method
SaveCsv Method
SaveCsv Method (Stream, CsvType)
SaveCsv Method (Stream, Char)
SaveCsv Method (StreamWriter, CsvType)
SaveCsv Method (StreamWriter, Char)
SaveCsv Method (String, CsvType)
SaveCsv Method (String, Char)
SaveHtml Method
SaveHtml Method (String, HtmlExporterOptions, Boolean)
SaveHtml Method (XmlTextWriter, HtmlExporterOptions, Boolean)
SaveXls Method
SaveXls Method (Stream)
SaveXls Method (String)
SaveXlsx Method
SaveXlsx Method (Stream)
SaveXlsx Method (String)
SaveXlsxToDirectory Method
SupportsType Method
Events
IoWarning Event
LimitNear Event
LimitReached Event
ExcelFillPattern Class
ExcelFillPattern Members
Properties
PatternBackgroundColor Property
PatternForegroundColor Property
PatternStyle Property
Methods
SetPattern Method
SetSolid Method
ExcelFont Class
ExcelFont Members
Fields
BoldWeight Field
MaxWeight Field
MinWeight Field
NormalWeight Field
Properties
Color Property
Italic Property
Name Property
ScriptPosition Property
Size Property
Strikeout Property
UnderlineStyle Property
Weight Property
ExcelPicture Class
ExcelPicture Members
Properties
BottomRightCell Property
BoundingRectangle Property
Image Property
ImageStream Property
PictureFormat Property
Positioning Property
TopLeftCell Property
Methods
Delete Method
ExcelPictureCollection Class
ExcelPictureCollection Members
Properties
Count Property
Item Property
Methods
Add Method
Add Method (MemoryStream, PositioningMode, AnchorCell, AnchorCell, ExcelPictureFormat)
Add Method (MemoryStream, Rectangle, ExcelPictureFormat)
Add Method (String, PositioningMode, AnchorCell, AnchorCell)
Add Method (String, Rectangle)
Clear Method
GetEnumerator Method
ExcelPictureFormat Enumeration
ExcelPrintOptions Class
ExcelPrintOptions Members
Properties
AutomaticPageBreakScalingFactor Property
BottomMargin Property
DraftQuality Property
FitToPage Property
FitWorksheetHeightToPages Property
FitWorksheetWidthToPages Property
FooterMargin Property
HeaderMargin Property
LeftMargin Property
NumberOfCopies Property
PaperSize Property
Portrait Property
PrintBlackWhite Property
PrintCellNotes Property
PrintNotesSheetEnd Property
PrintPagesInRows Property
PrintResolution Property
RightMargin Property
StartPageNumber Property
TopMargin Property
UseStartPageNumber Property
VerticalPrintResolution Property
ExcelRow Class
ExcelRow Members
Properties
AllocatedCells Property
Cells Property
Height Property
Methods
AutoFit Method
Delete Method
InsertCopy Method
InsertEmpty Method
ExcelRowCollection Class
ExcelRowCollection Members
Properties
Item Property
Item Property (Int32)
Item Property (String)
Methods
RowIndexToName Method
RowNameToIndex Method
ExcelRowColumnCellCollectionBase Class
ExcelRowColumnCellCollectionBase Members
Properties
Count Property
Methods
GetEnumerator Method
ExcelRowColumnCollectionBase Class
ExcelRowColumnCollectionBase Members
ExcelViewOptions Class
ExcelViewOptions Members
Properties
FirstVisibleColumn Property
FirstVisibleRow Property
OutlineColumnButtonsRight Property
OutlineRowButtonsBelow Property
PageBreakViewZoom Property
ShowColumnsFromRightToLeft Property
ShowFormulas Property
ShowGridLines Property
ShowInPageBreakPreview Property
ShowOutlineSymbols Property
ShowSheetHeaders Property
ShowZeroValues Property
Zoom Property
ExcelWorksheet Class
ExcelWorksheet Members
Properties
Cells Property
Columns Property
DefaultColumnWidth Property
HasHeadersFooters Property
HasSplitOrFreezePanes Property
HeadersFooters Property
HorizontalPageBreaks Property
Hyperlinks Property
Name Property
NamedRanges Property
Panes Property
Pictures Property
PrintOptions Property
Protected Property
Rows Property
VerticalPageBreaks Property
ViewOptions Property
Visibility Property
Methods
Delete Method
ExtractToDataTable Method
ExtractToDataTable Method (DataTable, Int32, ExtractDataOptions, ExcelRow, ExcelColumn)
ExtractToDataTable Method (DataTable, Int32, ExtractDataOptions, DataColumnMappingCollection, ExcelRow)
GetUsedCellRange Method
InsertCopy Method
InsertDataTable Method
InsertDataTable Method (DataTable, Int32, Int32, Boolean)
InsertDataTable Method (DataTable, String, Boolean)
InsertEmpty Method
Events
ExtractDataEvent Event
ExcelWorksheet.ExtractDataEventHandler Delegate
ExcelWorksheetCollection Class
ExcelWorksheetCollection Members
Properties
ActiveWorksheet Property
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Methods
Add Method
AddCopy Method
GetEnumerator Method
ExtractDataDelegateEventArgs Class
ExtractDataDelegateEventArgs Members
Properties
Action Property
DataTableRow Property
DataTableValue Property
DestinationTable Property
ErrorID Property
ExcelValue Property
Mapping Property
WorksheetRow Property
ExtractDataError Enumeration
ExtractDataEventAction Enumeration
ExtractDataOptions Enumeration
FillPatternStyle Enumeration
HorizontalAlignmentStyle Enumeration
HorizontalPageBreak Class
HorizontalPageBreak Members
Properties
FirstColumn Property
LastColumn Property
Row Property
HorizontalPageBreakCollection Class
HorizontalPageBreakCollection Members
Properties
Item Property
Methods
Add Method
Add Method (Int32)
Add Method (Int32, Int32, Int32)
HtmlExporterOptions Class
HtmlExporterOptions Members
HtmlExporterOptions Constructor
HtmlExporterOptions Constructor ()
HtmlExporterOptions Constructor (XmlDocument)
Properties
CalculateTableWidth Property
ExportHiddenColumns Property
ExportHiddenRows Property
ExportingXmlDocument Property
MethodCellStyleToHtml Property
MethodCellToHtml Property
MethodCellValueToHtml Property
MethodColumnLettersToHtml Property
MethodColumnLetterToHtml Property
MethodPageToHtml Property
MethodRowNumberToHtml Property
MethodRowToHtml Property
MethodTableToHtml Property
ShowColumnLetters Property
ShowGridLines Property
ShowRowNumbers Property
HtmlExporterOptions.CellStyleToHtmlDelegate Delegate
HtmlExporterOptions.CellToHtmlDelegate Delegate
HtmlExporterOptions.CellValueToHtmlDelegate Delegate
HtmlExporterOptions.ColumnLettersToHtmlDelegate Delegate
HtmlExporterOptions.ColumnLetterToHtmlDelegate Delegate
HtmlExporterOptions.PageToHtmlDelegate Delegate
HtmlExporterOptions.RowNumberToHtmlDelegate Delegate
HtmlExporterOptions.RowToHtmlDelegate Delegate
HtmlExporterOptions.TableToHtmlDelegate Delegate
HtmlExportPosition Class
HtmlExportPosition Members
HtmlExportPosition Constructor
Properties
HtmlColumnIndex Property
HtmlRowIndex Property
Range Property
SheetColumn Property
SheetRow Property
IndividualBorder Enumeration
IoOperation Enumeration
IoWarningEventArgs Class
IoWarningEventArgs Members
Properties
FileName Property
Operation Property
WarningMsg Property
IoWarningEventHandler Delegate
LimitEventArgs Class
LimitEventArgs Members
Properties
FileName Property
MaxRowCount Property
Operation Property
WorksheetCount Property
WriteWarningWorksheet Property
LimitEventHandler Delegate
LineStyle Enumeration
MultipleBorders Enumeration
NamedRange Class
NamedRange Members
Properties
GlobalName Property
Name Property
Range Property
Methods
Delete Method
NamedRangeCollection Class
NamedRangeCollection Members
Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Methods
Add Method
Add Method (String, CellRange)
Add Method (String, CellRange, Boolean)
GetEnumerator Method
PageBreak Class
PageBreakCollection Class
PageBreakCollection Members
Properties
Count Property
Methods
Clear Method
GetEnumerator Method
RemoveAt Method
PanePosition Enumeration
PanesState Enumeration
PositioningMode Enumeration
RangeIndexingMode Enumeration
RowColumnResolutionMethod Enumeration
ScriptPosition Enumeration
SheetHeaderFooter Class
SheetHeaderFooter Members
SheetHeaderFooter Constructor
Properties
AlignWithMargins Property
DifferentFirst Property
DifferentOddEven Property
EvenFooter Property
EvenHeader Property
FirstFooter Property
FirstHeader Property
Footer Property
Header Property
ScaleWithDoc Property
SheetVisibility Enumeration
SpreadsheetException Class
SpreadsheetException Members
SpreadsheetException Constructor
SpreadsheetException Constructor ()
SpreadsheetException Constructor (String)
SpreadsheetException Constructor (String, Exception)
SpreadsheetHyperlink Class
SpreadsheetHyperlink Members
Properties
IsExternal Property
Location Property
ToolTip Property
SpreadsheetHyperlinkCollection Class
SpreadsheetHyperlinkCollection Members
Properties
Count Property
Methods
Clear Method
GetEnumerator Method
RemoveAt Method
SpreadsheetInfo Class
SpreadsheetInfo Members
Fields
FullVersion Field
Title Field
Methods
SetLicense Method
UnderlineStyle Enumeration
VerticalAlignmentStyle Enumeration
VerticalPageBreak Class
VerticalPageBreak Members
Properties
Column Property
FirstRow Property
LastRow Property
VerticalPageBreakCollection Class
VerticalPageBreakCollection Members
Properties
Item Property
Methods
Add Method
Add Method (Int32)
Add Method (Int32, Int32, Int32)
WorksheetPanes Class
WorksheetPanes Members
WorksheetPanes Constructor
Properties
ActivePane Property
State Property
TopLeftCell Property
XSplit Property
YSplit Property
XlsOptions Enumeration
XlsxOptions Enumeration