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