sync toc
GemBox.Spreadsheet
AbstractRange Class
AbstractRange Members
Properties
Comment Property
Formula Property
IsStyleDefault Property
Style Property
Value Property
Methods
SetBorders 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
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
ExcelCell Class
ExcelCell Members
Properties
Comment Property
Formula 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
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
IsStyleDefault Property
OutlineLevel Property
Style Property
ExcelComment Class
ExcelComment Members
Properties
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
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)
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
BoundingRectangle Property
Image Property
Methods
Delete Method
ExcelPictureCollection Class
ExcelPictureCollection Members
Properties
Count Property
Item Property
Methods
Add Method
Add Method (Image)
Add Method (Image, Rectangle)
Add Method (String)
Add Method (String, Rectangle)
GetEnumerator Method
ExcelPrintOptions Class
ExcelPrintOptions Members
Properties
AutomaticPageBreakScalingFactor Property
DraftQuality Property
FitToPage Property
FitWorksheetHeightToPages Property
FitWorksheetWidthToPages Property
FooterMargin Property
HeaderMargin Property
NumberOfCopies Property
PaperSize Property
Portrait Property
PrintBlackWhite Property
PrintCellNotes Property
PrintNotesSheetEnd Property
PrintPagesInRows Property
PrintResolution Property
StartPageNumber Property
UseStartPageNumber Property
VerticalPrintResolution Property
ExcelRow Class
ExcelRow Members
Properties
AllocatedCells Property
Cells Property
Height Property
Methods
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
HorizontalPageBreaks Property
Name Property
NamedRanges Property
Pictures Property
PrintOptions Property
Protected Property
Rows Property
VerticalPageBreaks Property
ViewOptions Property
Methods
Delete Method
InsertCopy Method
InsertDataTable Method
InsertDataTable Method (DataTable, Int32, Int32, Boolean)
InsertDataTable Method (DataTable, String, Boolean)
InsertEmpty Method
ExcelWorksheetCollection Class
ExcelWorksheetCollection Members
Properties
ActiveWorksheet Property
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Methods
Add Method
AddCopy Method
GetEnumerator Method
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)
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