Keyword(s) for which to search:
Sort results by title
Keyword Index
Direct Link
About Bytescout Spreadsheet SDK
Getting Started
in C#
in VB.NET
in ASP.NET
in VBScript
in Visual Basic 6
in Javascript
in Console (command line)
Source Code Samples
ASP Classic
Generate XLS spreadsheet
ASP.NET
Display XLS as HTML (C#)
Display XLS as HTML (VB.NET)
C#
Add Background Image
Add Chart Area
Add Chart Bar
Add Chart Bubble
Add Chart Column
Add Chart Combination
Add Chart Doughnut
Add Chart Line
Add Chart Pie
Add Chart Radar
Add Chart Stock
Add Chart Surface
Add Chart XYScatter
Add Columns Into Existing Spreadsheet
Add Header and Footer
Add Image
Add Image Into Existing Spreadsheet
Add Images
Add Images Advanced
Add Rows Into Existing Spreadsheet
Calculate Auto Update On Cell Change
Calculate Formula In Cell
Calculate XIRR Function
Calculations and Spreadsheet as Database
Cell Alignment
Change Cell Width and Height
Change Column Width and Row Height
Change Data in Existing Spreadsheet
Change Document Properties
Convert XLS to CSV
Convert XLS to TXT
Convert XLS to XLSX
Convert XLS to XML
Convert XML to XLS
Copy range
Copy Worksheet
CopyPaste Columns
CopyPaste Rows
Create Worksheets
Create XLSX
CSV to SQL Server
CSV To XLS
Custom Functions
Date Formatting in Cells
Export To 2D Array
Export To Dataset
Export To DataTable
Export To HTML
Export To Jagged Array
Export To JSON
Export To List
Export To PDF
Export to WinForms DataGrid
Font Style In Cell
Fonts Available For Cells
Get Cell Color
Hello World
Hidden Formula
Hidden Rows And Columns
Import From 2D Array
Import From Data Table
Import From Dataset
Import From Jagged Array
Import From JSON
Import From List
Import From WinForms DataGrid
Insert Page Break
Line Styles In Cells
Merge Cells
Merge Two Documents
Number Format In Cells
ODS to SQL Server
Range Sort
Read Cell Color
Read CSV File
Read Date From Cell
Read Document Properties
Read Formula From Cell
Read Merged Cells
Read Number Format In Cell
Read ODS (Open Office Calc) Files
Read TXT (tab delimited)
Read XLSX (Office 2007) Files
Remove Columns from Existing Spreadsheet
Remove Rows from Existing Spreadsheet
Rename Worksheet
Rich Text Formatting in Cell
Search Text
Select Active Worksheet
Set Cell Formula
ShrinkToFit for Cells
Special Cells
Swap Cells and Their Values
Swap Worksheets
Template To XLS
TXT to SQL Server
Unicode Text
Unmerge Cells
Use Rich Formatting to Create Report
Validate Cell if Value is in Range
Validate Cells with Dates
Validate Data in Cell and Mark Wrong With Color
View Spreadsheet
XLS to SQL Server
XLS to SQL Server (via CSV BULK INSERT)
XLS to XML and XML to XLS
XLSX to SQL Server
C++ (managed)
HelloWorld
C++ (unmanaged)
Hello World
Compact Framework
PocketPC
WinCE
Console Tool
Batch to XLS
Batch XLS to CSV
VB.NET
Add Background Image
Add Chart Area
Add Chart Bar
Add Chart Bubble
Add Chart Column
Add Chart Combination
Add Chart Doughnut
Add Chart Line
Add Chart Pie
Add Chart Radar
Add Chart Stock
Add Chart Surface
Add Chart XYScatter
Add Columns Into Existing Spreadsheet
Add Header and Footer
Add Images
Add Images Advanced
Add Rows Into Existing Spreadsheet
Calculate Formula In Cell
Calculate XIRR Function
Calculations and Spreadsheet as Database
Cell Alignment
Change Cell Width and Height
Change Column Width and Row Height
Change Data in Existing Spreadsheet
Change Document Properties
Convert XLS to CSV
Convert XLS to TXT
Convert XLS to XLSX
Convert XLS to XML
Convert XML to XLS
Copy range
Copy Worksheet
CopyPaste Columns
CopyPaste Rows
Create Worksheets
Create XLSX
CSV to SQL Server
CSV to XLS
Custom Functions
Date Formatting in Cells
Export To 2D Array
Export To DataSet
Export To DataTable
Export To HTML
Export To Jagged Array
Export To JSON
Export To List
Export To PDF
Export to WinForms DataGrid
Font Style In Cell
Fonts Available For Cells
Get Cell Color
Hello World
Hidden Formula
Hidden Rows And Columns
Import From 2D Array
Import From DataSet
Import From DataTable
Import From Jagged Array
Import From JSON
Import From List
Import From WinForms DataGrid
Insert Page Break
Line Styles In Cells
Merge Cells
Merge Two Documents
Number Format In Cells
ODS to SQL Server
Read Cell Color
Read CSV File
Read Date From Cell
Read Document Properties
Read Formula From Cell
Read Merged Cells
Read Number Format In Cell
Read ODS (Open Office Calc) Files
Read XLSX (Office 2007) Files
Remove Columns from Existing Spreadsheet
Remove Rows from Existing Spreadsheet
Rename Worksheet
Rich Text Formatting in Cell
Search Text
Select Active Worksheet
Set Cell Formula
ShrinkToFit for Cells
Swap Cells and Their Values
Swap Worksheets
Template To XLS
TXT to SQL Server
Unicode Text
Unmerge Cells
Use Rich Formatting to Create Report
Validate Cell if Value is in Range
Validate Cells with Dates
Validate Data in Cell and Mark Wrong With Color
View Spreadsheet
XLS to SQL Server
XLS to SQL Server (via CSV BULK INSERT)
XLS to XML and XML to XLS
XLSX to SQL Server
VB6
Hello World
VBScript
Add Images
Barcode from Excel
Change Cell Background Color
Change Column Height
Change Row Height
CSV to XLS
Export To HTML
Hello World
Merge Cells and Set Alignment
Rich Text Formatting
Save As PDF
Web API Samples
C#
Convert CSV To PDF From Uploaded File
Convert CSV To PDF From URL
Convert CSV To PDF From URL Asynchronously
cURL
Convert CSV To PDF From URL
Java
Convert CSV To PDF From Uploaded File
Convert CSV To PDF From URL
JavaScript
Convert CSV To PDF From Uploaded File (Node.js)
Convert CSV To PDF From URL (Node.js)
PHP
Convert CSV To PDF Asynchronously
Convert CSV To PDF From Uploaded File
PowerShell
Convert CSV To PDF From Uploaded File
Convert CSV To PDF From URL
Convert CSV To PDF From URL Asynchronously
VB.NET
Convert CSV To PDF From Uploaded File
Convert CSV To PDF From URL
Convert CSV To PDF From URL Asynchronously
Spreadsheet SDK API Reference
Bytescout.Spreadsheet
Areas Class
Areas Constructor
Areas Properties
Count Property
Item Property
Areas Methods
BiffChartSaveException Class
BiffChartSaveException Constructor
BiffChartSaveException Constructor
BiffChartSaveException Constructor (String)
BiffChartSaveException Constructor (SerializationInfo, StreamingContext)
BiffChartSaveException Constructor (String, Exception)
BiffChartSaveException Properties
BiffChartSaveException Methods
Border Class
Border Constructor
Border Properties
Color Property
ColorIndex Property
LineStyle Property
Weight Property
Border Methods
Equals Method
GetHashCode Method
Border Operators
Equality Operator
Inequality Operator
BuiltInFuncException Class
BuiltInFuncException Constructor
BuiltInFuncException Constructor
BuiltInFuncException Constructor (String)
BuiltInFuncException Constructor (SerializationInfo, StreamingContext)
BuiltInFuncException Constructor (String, Exception)
BuiltInFuncException Properties
BuiltInFuncException Methods
CacheType Enumeration
CalcErrorHandler Delegate
Cell Class
Cell Properties
AlignmentHorizontal Property
AlignmentVertical Property
BottomBorderColor Property
BottomBorderStyle Property
CellFormat Property
ContainsArrayFormula Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternBackColorOLE Property
FillPatternForeColor Property
FillPatternForeColorOLE Property
Font Property
FontColor Property
FontColorIndex Property
FontEscapement Property
FontUnderline Property
Formula Property
HiddenFormula Property
Indent Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
IsInteger Property
LeftBorderColor Property
LeftBorderStyle Property
Locked Property
Merged Property
MergedWith Property
MergedWithCell Property
NumberFormatString Property
RightBorderColor Property
RightBorderStyle Property
Rotation Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
Validation Property
Value Property
ValueAsBoolean Property
ValueAsDateTime Property
ValueAsDouble Property
ValueAsExcelDisplays Property
ValueAsHTML Property
ValueAsInteger Property
ValueAsString Property
ValueAsUnformattedString Property
ValueDataType Property
ValueDataTypeByNumberFormatString Property
Wrap Property
Cell Methods
Calculate Method
Clear Method
Dispose Method
Dispose Method
Dispose Method (Boolean)
Finalize Method
GetAddress Method
SetFontColorRGB Method
SetFontProperties Method
ToDateTime Method
ToDouble Method
ToHTML Method
ToInteger Method
ToString Method
CellsSelectionMethod Enumeration
Column Class
Column Properties
AlignmentHorizontal Property
AlignmentVertical Property
BottomBorderColor Property
BottomBorderStyle Property
CellFormat Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternBackColorOLE Property
FillPatternForeColor Property
FillPatternForeColorOLE Property
Font Property
FontColor Property
FontColorIndex Property
FontEscapement Property
FontUnderline Property
Hidden Property
HiddenFormula Property
Indent Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
IsFormatted Property
IsNotEmptyCells Property
Item Property
LeftBorderColor Property
LeftBorderStyle Property
Locked Property
NumberFormat Property
RightBorderColor Property
RightBorderStyle Property
Rotation Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
Width Property
WidthInChars Property
Wrap Property
Column Methods
AutoFit Method
SetFontColorRGB Method
SetFontProperties Method
ToString Method
Columns Class
Columns Properties
FirstFormatedColumn Property
Item Property
LastFormatedColumn Property
Columns Methods
CopyAndPaste Method
Delete Method
Delete Method (Int32)
Delete Method (Int32, Int32)
Insert Method
Insert Method (Int32)
Insert Method (Int32, Int32)
Columns Fields
max Field
min Field
ConversionOptions Class
ConversionOptions Constructor
ConversionOptions Properties
Delimiter Property
OutputFormat Property
Quote Property
ConversionOptions Methods
CustomFunctionsCallback Delegate
DefinedName Class
DefinedName Properties
Comment Property
Index Property
Name Property
RefersTo Property
Value Property
Visible Property
DefinedName Methods
DefinedNameException Class
DefinedNameException Constructor
DefinedNameException Constructor
DefinedNameException Constructor (String)
DefinedNameException Constructor (SerializationInfo, StreamingContext)
DefinedNameException Constructor (String, Exception)
DefinedNameException Properties
DefinedNameException Methods
ExceptionEventArgs Class
ExceptionEventArgs Constructor
ExceptionEventArgs Properties
Exception Property
ExceptionEventArgs Methods
ExtendedFormat Class
ExtendedFormat Methods
Dispose Method
Dispose Method
Dispose Method (Boolean)
Equals Method
Equals Method (Object)
Equals Method (ExtendedFormat)
Finalize Method
GetHashCode Method
ExtendedFormat Operators
Equality Operator
Inequality Operator
FormulaCalculationException Class
FormulaCalculationException Constructor
FormulaCalculationException Constructor
FormulaCalculationException Constructor (String)
FormulaCalculationException Constructor (SerializationInfo, StreamingContext)
FormulaCalculationException Constructor (String, Exception)
FormulaCalculationException Properties
FormulaCalculationException Methods
FormulaReferenceException Class
FormulaReferenceException Constructor
FormulaReferenceException Constructor
FormulaReferenceException Constructor (String)
FormulaReferenceException Constructor (SerializationInfo, StreamingContext)
FormulaReferenceException Constructor (String, Exception)
FormulaReferenceException Properties
FormulaReferenceException Methods
FuncNotSupportedException Class
FuncNotSupportedException Constructor
FuncNotSupportedException Constructor
FuncNotSupportedException Constructor (String)
FuncNotSupportedException Constructor (SerializationInfo, StreamingContext)
FuncNotSupportedException Constructor (String, Exception)
FuncNotSupportedException Properties
FuncNotSupportedException Methods
HTMLTemplate Class
HTMLTemplate Constructor
HTMLTemplate Properties
CellHeader Property
TableHeader Property
HTMLTemplate Methods
SaveAsHTML Method
SaveAsHTML Method (Worksheet, Stream)
SaveAsHTML Method (Worksheet, String)
SaveHTML Method
HyperLink Class
HyperLink Constructor
HyperLink Constructor (CellsRange, String)
HyperLink Constructor (CellsRange, String, String, String, String)
HyperLink Properties
Address Property
Range Property
ScreenTip Property
SubAddress Property
TextToDisplay Property
HyperLink Methods
HyperLinks Class
HyperLinks Properties
Count Property
Item Property
HyperLinks Methods
Add Method
Add Method (HyperLink)
Add Method (CellsRange, String, String, String, String)
RemoveAt Method
IncorrectOLEAutomationDateException Class
IncorrectOLEAutomationDateException Constructor
IncorrectOLEAutomationDateException Constructor
IncorrectOLEAutomationDateException Constructor (String)
IncorrectOLEAutomationDateException Constructor (SerializationInfo, StreamingContext)
IncorrectOLEAutomationDateException Constructor (String, Exception)
IncorrectOLEAutomationDateException Properties
IncorrectOLEAutomationDateException Methods
Interior Class
Interior Constructor
Interior Properties
Color Property
ColorIndex Property
Pattern Property
PatternColor Property
PatternColorIndex Property
Interior Methods
InvalidPasswordException Class
InvalidPasswordException Constructor
InvalidPasswordException Constructor
InvalidPasswordException Constructor (String)
InvalidPasswordException Constructor (SerializationInfo, StreamingContext)
InvalidPasswordException Constructor (String, Exception)
InvalidPasswordException Properties
InvalidPasswordException Methods
OpenXMLParserException Class
OpenXMLParserException Constructor
OpenXMLParserException Constructor
OpenXMLParserException Constructor (String)
OpenXMLParserException Constructor (SerializationInfo, StreamingContext)
OpenXMLParserException Constructor (String, Exception)
OpenXMLParserException Properties
OpenXMLParserException Methods
OutputFormat Enumeration
Progress Delegate
Range Class
Range Properties
AlignmentHorizontal Property
AlignmentVertical Property
Areas Property
BottomBorderColor Property
BottomBorderStyle Property
BottomRowIndex Property
CellFormat Property
Column Property
Columns Property
Count Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternForeColor Property
Font Property
FontColor Property
FontColorIndex Property
FontEscapement Property
FontUnderline Property
Formula Property
HiddenFormula Property
Indent Property
InnerBorderColor Property
InnerBorderStyle Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
IsNotEmptyCells Property
LeftBorderColor Property
LeftBorderStyle Property
LeftColumnIndex Property
Locked Property
NumberFormatString Property
OuterBorderColor Property
OuterBorderStyle Property
RightBorderColor Property
RightBorderStyle Property
RightColumnIndex Property
Rotation Property
Row Property
Rows Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
TopRowIndex Property
Value Property
ValueAsHTML Property
ValueDataTypeByNumberFormatString Property
Wrap Property
Range Methods
Address Method
Address Method
Address Method (Boolean, Boolean, Boolean)
Calculate Method
CopyInto Method
CopyInto Method (String)
CopyInto Method (Int32, Int32)
Merge Method
Sort Method
Sort Method (String, SortOrder, Boolean, SortOrientation, SortDataOption)
Sort Method (String, SortOrder, String, SortOrder, String, SortOrder, Boolean, SortOrientation, SortDataOption, SortDataOption, SortDataOption)
SpecialCells Method
UnMerge Method
Row Class
Row Properties
AlignmentHorizontal Property
AlignmentVertical Property
BottomBorderColor Property
BottomBorderStyle Property
CellFormat Property
ColumnMax Property
ColumnMin Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternBackColorOLE Property
FillPatternForeColor Property
FillPatternForeColorOLE Property
Font Property
FontColor Property
FontColorIndex Property
FontEscapement Property
FontUnderline Property
Height Property
HeightInTwips Property
Hidden Property
HiddenFormula Property
Indent Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
IsFormatted Property
IsNotEmptyCells Property
Item Property
LeftBorderColor Property
LeftBorderStyle Property
Locked Property
NumberFormat Property
RightBorderColor Property
RightBorderStyle Property
Rotation Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
UseStandardHeight Property
Wrap Property
Row Methods
AutoFit Method
DeleteCell Method
InsertCell Method
SetFontColorRGB Method
SetFontProperties Method
ToString Method
Row Fields
max Field
min Field
recalcMinMax Field
Rows Class
Rows Properties
FirstFormatedRow Property
Item Property
LastFormatedRow Property
Rows Methods
CopyAndPaste Method
Delete Method
Delete Method (Int32)
Delete Method (Int32, Int32)
Insert Method
Insert Method (Int32)
Insert Method (Int32, Int32)
Rows Fields
max Field
min Field
SearchOptions Class
SearchOptions Constructor
SearchOptions Properties
CaseSensitiveSearch Property
RegexSearch Property
SearchBackwards Property
SearchString Property
SearchOptions Methods
Spreadsheet Class
Spreadsheet Constructor
Spreadsheet Properties
Cache Property
CustomFunctionsCallback Property
Options Property
RegistrationKey Property
RegistrationName Property
SearchOptions Property
UserName Property
Workbook Property
Worksheets Property
Spreadsheet Methods
Close Method
Dispose Method
ExportTo2DArray Method
ExportTo2DArray Method
ExportTo2DArray Method (Int32)
ExportTo2DArray Method (String)
ExportToDataSet Method
ExportToDataSet Method
ExportToDataSet Method (DataSet)
ExportToDataSet Method (DataSet, Boolean)
ExportToDataTable Method
ExportToDataTable Method
ExportToDataTable Method (Int32)
ExportToDataTable Method (String)
ExportToDataTable Method (Int32, Boolean)
ExportToDataTable Method (String, Boolean)
ExportToJaggedArray Method
ExportToJaggedArray Method
ExportToJaggedArray Method (Int32)
ExportToJaggedArray Method (String)
ExportToJSON Method
ExportToList Method
ExportToList Method (IList)
ExportToList Method (IList, Int32)
ExportToList Method (IList, String)
Finalize Method
GetAsBytesArray Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method (Int32)
GetAsBytesArrayTXT Method
GetAsBytesArrayXLS Method
GetAsBytesArrayXLSX Method
GetAsBytesArrayXML Method
ImportFrom2DArray Method
ImportFrom2DArray Method (String[,])
ImportFrom2DArray Method (String[,], Int32)
ImportFrom2DArray Method (String[,], String)
ImportFromDataSet Method
ImportFromDataSet Method (DataSet)
ImportFromDataSet Method (DataSet, UInt32)
ImportFromDataTable Method
ImportFromDataTable Method (DataTable)
ImportFromDataTable Method (DataTable, Int32)
ImportFromDataTable Method (DataTable, String)
ImportFromDataTable Method (DataTable, UInt32)
ImportFromJaggedArray Method
ImportFromJaggedArray Method (String[][])
ImportFromJaggedArray Method (String[][], Int32)
ImportFromJaggedArray Method (String[][], String)
ImportFromJSON Method
ImportFromList Method
ImportFromList Method (IList)
ImportFromList Method (IList, Int32)
ImportFromList Method (IList, String)
LoadFromFile Method
LoadFromFile Method (String)
LoadFromFile Method (String, CacheType)
LoadFromFile Method (String, String)
LoadFromFile Method (String, CacheType, String)
LoadFromFile Method (String, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding, String)
LoadFromStream Method
LoadFromStream Method (Stream)
LoadFromStream Method (Stream, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType)
LoadFromStream Method (Stream, CacheType, String)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding, String)
SaveAs Method
SaveAs Method (String)
SaveAs Method (String, SpreadsheetFormatType)
SaveAsCSV Method
SaveAsCSV Method (String, Int32)
SaveAsCSV Method (String, Int32, String)
SaveAsCSV Method (String, Int32, String, String)
SaveAsCSV Method (String, Int32, String, String, Encoding)
SaveAsCSV Method (String, Int32, String, String, Encoding, Boolean)
SaveAsHTML Method
SaveAsHTML Method (String)
SaveAsHTML Method (String, Boolean)
SaveAsPDF Method
SaveAsPDF Method (String)
SaveAsPDF Method (String, Boolean)
SaveAsTXT Method
SaveAsTXT Method (String, Int32)
SaveAsTXT Method (String, Int32, String)
SaveAsTXT Method (String, Int32, String, String)
SaveAsTXT Method (String, Int32, String, String, Encoding)
SaveAsTXT Method (String, Int32, String, String, Encoding, Boolean)
SaveAsXLS Method
SaveAsXLSX Method
SaveAsXLSX Method (String)
SaveAsXLSX Method (String, String)
SaveAsXML Method
SaveAsXML Method (String, Int32)
SaveAsXML Method (String, Int32, Encoding)
SaveToStream Method
SaveToStream Method (Stream)
SaveToStream Method (Stream, SpreadsheetFormatType)
SaveToStreamCSV Method
SaveToStreamCSV Method (Stream, Int32)
SaveToStreamCSV Method (Stream, Int32, String)
SaveToStreamCSV Method (Stream, Int32, String, String)
SaveToStreamCSV Method (Stream, Int32, String, String, Encoding)
SaveToStreamCSV Method (Stream, Int32, String, String, Encoding, Boolean)
SaveToStreamHTML Method
SaveToStreamHTML Method (Stream)
SaveToStreamHTML Method (Stream, Int32)
SaveToStreamTXT Method
SaveToStreamTXT Method (Stream, Int32)
SaveToStreamTXT Method (Stream, Int32, String)
SaveToStreamTXT Method (Stream, Int32, String, String)
SaveToStreamTXT Method (Stream, Int32, String, String, Encoding)
SaveToStreamTXT Method (Stream, Int32, String, String, Encoding, Boolean)
SaveToStreamXLS Method
SaveToStreamXLSX Method
SaveToStreamXLSX Method (Stream)
SaveToStreamXLSX Method (Stream, String)
SaveToStreamXML Method
SaveToStreamXML Method (Stream, Int32)
SaveToStreamXML Method (Stream, Int32, Encoding)
Worksheet Method
Spreadsheet Events
OnCalcError Event
Spreadsheet Fields
LoadProgress Field
SpreadsheetChartException Class
SpreadsheetChartException Constructor
SpreadsheetChartException Constructor
SpreadsheetChartException Constructor (String)
SpreadsheetChartException Constructor (SerializationInfo, StreamingContext)
SpreadsheetChartException Constructor (String, Exception)
SpreadsheetChartException Properties
SpreadsheetChartException Methods
SpreadsheetComponent Class
SpreadsheetComponent Constructor
SpreadsheetComponent Constructor
SpreadsheetComponent Constructor (IContainer)
SpreadsheetComponent Properties
Cache Property
Options Property
UserKey Property
UserName Property
Workbook Property
SpreadsheetComponent Methods
Close Method
Dispose Method
Dispose Method
Dispose Method (Boolean)
Finalize Method
GetAsBytesArray Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method (Int32)
GetAsBytesArrayTXT Method
GetAsBytesArrayXLS Method
GetAsBytesArrayXLSX Method
GetAsBytesArrayXML Method
LoadFromFile Method
LoadFromFile Method (String)
LoadFromFile Method (String, CacheType)
LoadFromFile Method (String, CacheType, String)
LoadFromFile Method (String, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding, String)
LoadFromStream Method
LoadFromStream Method (Stream)
LoadFromStream Method (Stream, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)
SaveAs Method
SaveAs Method (String)
SaveAs Method (String, SpreadsheetFormatType)
SaveAsCSV Method
SaveAsCSV Method (String, Int32)
SaveAsCSV Method (String, Int32, String)
SaveAsHTML Method
SaveAsHTML Method (String)
SaveAsHTML Method (String, Boolean)
SaveAsTXT Method
SaveAsXLS Method
SaveAsXLSX Method
SaveAsXML Method
SaveToStream Method
SaveToStream Method (Stream)
SaveToStream Method (Stream, SpreadsheetFormatType)
SaveToStreamCSV Method
SaveToStreamCSV Method (Stream, Int32)
SaveToStreamCSV Method (Stream, Int32, String)
SaveToStreamHTML Method
SaveToStreamHTML Method (Stream)
SaveToStreamHTML Method (Stream, Int32)
SaveToStreamTXT Method
SaveToStreamXLS Method
SaveToStreamXLSX Method
SaveToStreamXML Method
Worksheet Method
SpreadsheetComponent Events
SpreadsheetException Class
SpreadsheetException Constructor
SpreadsheetException Constructor
SpreadsheetException Constructor (String)
SpreadsheetException Constructor (SerializationInfo, StreamingContext)
SpreadsheetException Constructor (String, Exception)
SpreadsheetException Properties
SpreadsheetException Methods
SpreadsheetFont Class
SpreadsheetFont Constructor
SpreadsheetFont Constructor (String, Single)
SpreadsheetFont Constructor (String, Single, FontStyle, Color, FontEscapementType, FontUnderlineStyle, Byte)
SpreadsheetFont Properties
Bold Property
CharacterSet Property
Escapement Property
Font Property
FontColor Property
FontName Property
Height Property
Italic Property
StruckOut Property
Style Property
Underline Property
SpreadsheetFont Methods
Dispose Method
Dispose Method
Dispose Method (Boolean)
Equals Method
Equals Method (Object)
Equals Method (SpreadsheetFont)
Finalize Method
GetHashCode Method
SpreadsheetFont Operators
Equality Operator
Inequality Operator
SpreadsheetFormulaException Class
SpreadsheetFormulaException Constructor
SpreadsheetFormulaException Constructor
SpreadsheetFormulaException Constructor (String)
SpreadsheetFormulaException Constructor (SerializationInfo, StreamingContext)
SpreadsheetFormulaException Constructor (String, Exception)
SpreadsheetFormulaException Properties
SpreadsheetFormulaException Methods
SpreadsheetOptions Class
SpreadsheetOptions Constructor
SpreadsheetOptions Properties
AutoFitRowsBeforeSave Property
CSVDetectDataTypes Property
MaxColumnCountAllowed Property
MaxRowCountAllowed Property
MaxStringLengthAllowedPerCell Property
ThrowExceptionOnCalculateError Property
ThrowExceptionOnUnsupportedFormula Property
ThrowExceptionsOnFormatIncompatibilities Property
ThrowExceptionsOnFormatLimits Property
SpreadsheetOptions Methods
SetExcel2003Limits Method
SetExcel2007Limits Method
SetOpenOffice3Limits Method
SpreadsheetProtectionException Class
SpreadsheetProtectionException Constructor
SpreadsheetProtectionException Constructor
SpreadsheetProtectionException Constructor (String)
SpreadsheetProtectionException Constructor (SerializationInfo, StreamingContext)
SpreadsheetProtectionException Constructor (String, Exception)
SpreadsheetProtectionException Properties
SpreadsheetProtectionException Methods
SpreadsheetProtectionPasswordRequired Class
SpreadsheetProtectionPasswordRequired Constructor
SpreadsheetProtectionPasswordRequired Constructor
SpreadsheetProtectionPasswordRequired Constructor (String)
SpreadsheetProtectionPasswordRequired Constructor (SerializationInfo, StreamingContext)
SpreadsheetProtectionPasswordRequired Constructor (String, Exception)
SpreadsheetProtectionPasswordRequired Properties
SpreadsheetProtectionPasswordRequired Methods
SpreadsheetProtectionXLSSheetLimitationsException Class
SpreadsheetProtectionXLSSheetLimitationsException Constructor
SpreadsheetProtectionXLSSheetLimitationsException Constructor
SpreadsheetProtectionXLSSheetLimitationsException Constructor (String)
SpreadsheetProtectionXLSSheetLimitationsException Constructor (SerializationInfo, StreamingContext)
SpreadsheetProtectionXLSSheetLimitationsException Constructor (String, Exception)
SpreadsheetProtectionXLSSheetLimitationsException Properties
SpreadsheetProtectionXLSSheetLimitationsException Methods
SpreadsheetReferenceException Class
SpreadsheetReferenceException Constructor
SpreadsheetReferenceException Constructor
SpreadsheetReferenceException Constructor (String)
SpreadsheetReferenceException Constructor (SerializationInfo, StreamingContext)
SpreadsheetReferenceException Constructor (String, Exception)
SpreadsheetReferenceException Properties
SpreadsheetReferenceException Methods
SpreadsheetWebControl Class
SpreadsheetWebControl Constructor
SpreadsheetWebControl Properties
Cache Property
Options Property
UserKey Property
UserName Property
Workbook Property
SpreadsheetWebControl Methods
Close Method
Dispose Method
Finalize Method
GetAsBytesArray Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method (Int32)
GetAsBytesArrayTXT Method
GetAsBytesArrayXLS Method
GetAsBytesArrayXLSX Method
GetAsBytesArrayXML Method
LoadFromFile Method
LoadFromFile Method (String)
LoadFromFile Method (String, CacheType)
LoadFromFile Method (String, String)
LoadFromFile Method (String, CacheType, String)
LoadFromFile Method (String, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding, String)
LoadFromStream Method
LoadFromStream Method (Stream)
LoadFromStream Method (Stream, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)
RenderBeginTag Method
RenderContents Method
RenderEndTag Method
SaveAs Method
SaveAs Method (String)
SaveAs Method (String, SpreadsheetFormatType)
SaveAsCSV Method
SaveAsHTML Method
SaveAsHTML Method (String)
SaveAsHTML Method (String, Boolean)
SaveAsTXT Method
SaveAsXLS Method
SaveAsXLSX Method
SaveAsXML Method
SaveToStream Method
SaveToStream Method (Stream)
SaveToStream Method (Stream, SpreadsheetFormatType)
SaveToStreamCSV Method
SaveToStreamHTML Method
SaveToStreamHTML Method (Stream)
SaveToStreamHTML Method (Stream, Int32)
SaveToStreamTXT Method
SaveToStreamXLS Method
SaveToStreamXLSX Method
SaveToStreamXML Method
Worksheet Method
SpreadsheetWebControl Events
Validation Class
Validation Properties
AlertStyle Property
ErrorMessage Property
ErrorTitle Property
Formula1 Property
Formula2 Property
IgnoreBlank Property
IMEMode Property
InCellDropdown Property
InputMessage Property
InputTitle Property
Operator Property
ShowError Property
ShowInput Property
Type Property
Value Property
Validation Methods
Equals Method
GetHashCode Method
Validation Operators
Equality Operator
Inequality Operator
Workbook Class
Workbook Properties
AddInFunctionsNamesLocale Property
AutoCalculation Property
Charts Property
Colors Property
DefaultFont Property
DocumentProperties Property
EncryptionKeyLength Property
EncryptionType Property
ExternalReferenceUpdate Property
Locale Property
Names Property
Password Property
Properties Property
ProtectStructure Property
ProtectWindows Property
RangeSelectionMethod Property
ReadOnlyRecommended Property
Worksheets Property
Workbook Methods
Calculate Method
Protect Method
ProtectFromModifications Method
RemovePassword Method
UnProtect Method
Worksheet Class
Worksheet Constructor
Worksheet Properties
Active Property
BackgroundPicture Property
Charts Property
Columns Property
DefaultColumnWidth Property
HPageBreaks Property
Hyperlinks Property
IsEmpty Property
Item Property
Item Property (String)
Item Property (Int32, Int32)
Name Property
NotEmptyColumnMax Property
NotEmptyColumnMin Property
NotEmptyRowMax Property
NotEmptyRowMin Property
PageSetup Property
Pictures Property
Protected Property
ProtectionOptions Property
Rows Property
UsedRangeColumnMax Property
UsedRangeColumnMin Property
UsedRangeRowMax Property
UsedRangeRowMin Property
ViewOptions Property
Visible Property
VPageBreaks Property
Worksheet Methods
AutoFitRows Method
Calculate Method
Cell Method
Cell Method (String)
Cell Method (Int32, Int32)
Find Method
Find Method
Find Method (String, Boolean, Boolean, Boolean)
FindNext Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayTXT Method
GetAsBytesArrayXML Method
Protect Method
Protect Method (String)
Protect Method (String, EnhancedSheetProtection)
Range Method
Range Method (String)
Range Method (Int32, Int32, Int32, Int32)
SaveAsCSV Method
SaveAsCSV Method (Stream)
SaveAsCSV Method (String)
SaveAsCSV Method (Stream, ConversionOptions)
SaveAsCSV Method (Stream, String)
SaveAsCSV Method (String, ConversionOptions)
SaveAsCSV Method (String, String)
SaveAsCSV Method (Stream, String, String)
SaveAsCSV Method (String, String, String)
SaveAsCSV Method (Stream, String, String, Encoding)
SaveAsCSV Method (String, String, String, Encoding)
SaveAsCSV Method (Stream, String, String, Encoding, Boolean)
SaveAsCSV Method (String, String, String, Encoding, Boolean)
SaveAsHTML Method
SaveAsHTML Method (Stream)
SaveAsHTML Method (StreamWriter)
SaveAsHTML Method (String)
SaveAsPDF Method
SaveAsPDF Method (Stream)
SaveAsPDF Method (String)
SaveAsPDF Method (Stream, Boolean)
SaveAsPDF Method (String, Boolean)
SaveAsTXT Method
SaveAsTXT Method (Stream)
SaveAsTXT Method (String)
SaveAsTXT Method (Stream, ConversionOptions)
SaveAsTXT Method (Stream, String)
SaveAsTXT Method (String, ConversionOptions)
SaveAsTXT Method (String, String)
SaveAsTXT Method (Stream, String, String)
SaveAsTXT Method (String, String, String)
SaveAsTXT Method (Stream, String, String, Encoding)
SaveAsTXT Method (String, String, String, Encoding)
SaveAsTXT Method (Stream, String, String, Encoding, Boolean)
SaveAsTXT Method (String, String, String, Encoding, Boolean)
SaveAsXML Method
SaveAsXML Method (Stream)
SaveAsXML Method (String)
SaveAsXML Method (Stream, Encoding)
SaveAsXML Method (String, Encoding)
UnProtect Method
Worksheets Class
Worksheets Constructor
Worksheets Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
Worksheets Methods
Add Method
Add Method
Add Method (String)
AddFromFile Method
AddFromFile Method (String)
AddFromFile Method (String, String, Encoding)
ByName Method
Copy Method
Copy Method (Int32, Int32, String)
Copy Method (Int32, Int32, String, Boolean)
Delete Method
Delete Method (Int32)
Delete Method (String)
DeleteAll Method
GetEnumerator Method
IndexOf Method
Insert Method
Move Method
Bytescout.Spreadsheet.BaseClasses
CellAddress Class
CellAddress Constructor
CellAddress Constructor
CellAddress Constructor (Int32, Int32)
CellAddress Properties
Column Property
ColumnRelative Property
Row Property
RowRelative Property
CellAddress Methods
GetCellAddress Method
IsEmpty Method
ToString Method
CellRangeAddress Structure
CellRangeAddress Constructor
CellRangeAddress Methods
GetCellRangeAddress Method
CellRangeAddress Fields
FirstColumn Field
FirstColumnRelative Field
FirstRow Field
FirstRowRelative Field
LastColumn Field
LastColumnRelative Field
LastRow Field
LastRowRelative Field
MD4 Class
MD4 Constructor
MD4 Methods
Clone Method
GetByteHashFromByte Method
GetByteHashFromBytes Method
GetByteHashFromString Method
GetHexHashFromByte Method
GetHexHashFromBytes Method
GetHexHashFromString Method
PageSetup Class
PageSetup Constructor
PageSetup Properties
BlackAndWhite Property
BottomMargin Property
CenterFooter Property
CenterHeader Property
CenterHorizontally Property
CenterVertically Property
Copies Property
Draft Property
FirstPageNumber Property
FitToPage Property
FitToPagesTall Property
FitToPagesWide Property
FooterMargin Property
HeaderMargin Property
LeftFooter Property
LeftHeader Property
LeftMargin Property
Order Property
Orientation Property
PaperSize Property
PrintComments Property
PrintErrors Property
PrintGridLines Property
PrintNotes Property
PrintQualityHorizontal Property
PrintQualityVertical Property
RightFooter Property
RightHeader Property
RightMargin Property
TopMargin Property
UseFirstPageNumber Property
Zoom Property
PageSetup Methods
ViewOptions Class
ViewOptions Properties
ActivePane Property
FrozenNoSplit Property
GridLineColor Property
GridLinesColorEnabled Property
PageBreakPreview Property
Paged Property
PanesFrozen Property
RightToLeft Property
Selected Property
ShowFormulas Property
ShowGridLines Property
ShowGuts Property
ShowSheetHeaders Property
ShowZeroValues Property
SplitColumn Property
SplitHorizontal Property
SplitRow Property
SplitVertical Property
Zoom Property
ViewOptions Methods
XLSCompoundFile Class
XLSCompoundFile Methods
Bytescout.Spreadsheet.Charts
AbstractTitle Class
AbstractTitle Constructor
AbstractTitle Properties
Border Property
Fill Property
Font Property
Left Property
Shadow Property
Text Property
Top Property
AbstractTitle Methods
AxisCrossingPoint Enumeration
AxisOrientation Enumeration
AxisPosition Enumeration
AxisTitle Class
AxisTitle Properties
Border Property
Caption Property
Fill Property
Font Property
Left Property
Shadow Property
Text Property
Top Property
AxisTitle Methods
BarGrouping Enumeration
BubbleSizeRepresents Enumeration
CategoryAxis Class
CategoryAxis Properties
AutomaticCategory Property
LabelAlignment Property
LabelOffset Property
ShowLabelAsFlatText Property
CategoryAxis Methods
Chart Class
Chart Properties
BackWall Property
ChartArea Property
ChartGroups Property
ChartTitle Property
ChartType Property
DepthPercent Property
DisplayBlanksAs Property
Elevation Property
Floor Property
HeightPercent Property
Legend Property
Name Property
Perspective Property
PlacementType Property
PlotArea Property
PlotVisibleOnly Property
RightAngleAxes Property
Rotation Property
RoundedCorners Property
SeriesCollection Property
ShowAutoTitle Property
ShowDataLabelsOverMax Property
SideWall Property
XAxis Property
YAxis Property
ZAxis Property
Chart Methods
Axes Method
ChartArea Class
ChartArea Properties
Height Property
Left Property
Top Property
Width Property
ChartArea Methods
ChartAxis Class
ChartAxis Properties
AxisTitle Property
CrossingPoint Property
CrossingValue Property
DoNotDraw Property
HasTitle Property
MajorTickMark Property
MinorTickMark Property
Orientation Property
Position Property
ShowMajorGridLines Property
ShowMinorGridLines Property
TickLabelPosition Property
TickLabels Property
ChartAxis Methods
ChartCollection Class
ChartCollection Properties
Count Property
IsSynchronized Property
Item Property
SyncRoot Property
ChartCollection Methods
AddChart Method
AddChart Method (ChartType)
AddChart Method (Int32, Int32, ChartType)
AddChartAndFitInto Method
CopyTo Method
GetEnumerator Method
ChartFormat Class
ChartFormat Constructor
ChartFormat Properties
Line Property
ChartFormat Methods
ChartGroup Class
ChartGroup Constructor
ChartGroup Properties
BubbleScale Property
DoughnutHoleSize Property
FirstSliceAngle Property
GapWidth Property
HasHiLoLines Property
HiLoLines Property
ShowNegativeBubbles Property
SizeRepresents Property
VaryByCategories Property
ChartGroup Methods
ChartGroupCollection Class
ChartGroupCollection Constructor
ChartGroupCollection Properties
Count Property
Item Property
ChartGroupCollection Methods
GetEnumerator Method
ChartLineStyle Enumeration
ChartTitle Class
ChartTitle Properties
Border Property
Fill Property
Font Property
Left Property
Orientation Property
Shadow Property
Text Property
Top Property
ChartTitle Methods
ChartType Enumeration
ColorFormat Class
ColorFormat Properties
Color Property
RGB Property
SchemeColor Property
ColorFormat Methods
DataLabels Class
DataLabels Constructor
DataLabels Properties
ShowBubbleSize Property
ShowCategoryName Property
ShowLeaderLines Property
ShowLegendKey Property
ShowPercent Property
ShowSeriesName Property
ShowValue Property
DataLabels Methods
DisplayBlanksAs Enumeration
FillFormat Class
FillFormat Constructor
FillFormat Properties
BackColor Property
ForeColor Property
Pattern Property
FillFormat Methods
Equals Method
GetHashCode Method
FillFormat Operators
Equality Operator
Inequality Operator
Grouping Enumeration
HiLoLines Class
HiLoLines Constructor
HiLoLines Properties
Border Property
HiLoLines Methods
LabelAlignment Enumeration
Layout Class
Layout Constructor
Layout Properties
Auto Property
Height Property
Left Property
Top Property
Width Property
Layout Methods
Legend Class
Legend Constructor
Legend Properties
Layout Property
MayBeOverlapped Property
Position Property
Legend Methods
LegendPosition Enumeration
LineFormat Class
LineFormat Constructor
LineFormat Properties
ForeColor Property
Weight Property
LineFormat Methods
Marker Class
Marker Constructor
Marker Properties
Size Property
Style Property
Marker Methods
MarkerStyle Enumeration
Outline Class
Outline Properties
Color Property
LineStyle Property
Width Property
Outline Methods
PlotArea Class
PlotArea Properties
Border Property
Interior Property
Layout Property
PlotArea Methods
Series Class
Series Constructor
Series Constructor (Range)
Series Constructor (Range, Range)
Series Constructor (Range, Range, Range)
Series Properties
BubbleSizes Property
ChartType Property
DataLabels Property
Explosion Property
Format Property
Has3DEffect Property
InvertIfNegative Property
MarkerSize Property
MarkerStyle Property
Name Property
ShapeProperties Property
Smooth Property
Values Property
XValues Property
Series Methods
SeriesAxis Class
SeriesAxis Properties
SeriesAxis Methods
SeriesCollection Class
SeriesCollection Properties
Count Property
IsSynchronized Property
Item Property
SyncRoot Property
SeriesCollection Methods
Add Method
CopyTo Method
GetEnumerator Method
SeriesCollection Fields
m_series Field
ShapeProperties Class
ShapeProperties Constructor
ShapeProperties Properties
FillColor Property
Outline Property
ShapeProperties Methods
Surface Class
Surface Constructor
Surface Properties
Thickness Property
Surface Methods
TickLabelPosition Enumeration
TickLabels Class
TickLabels Properties
NumberFormat Property
TickLabels Methods
TickMark Enumeration
ValueAxis Class
ValueAxis Properties
CrossesBetweenCategories Property
MajorUnit Property
MinorUnit Property
ValueAxis Methods
ValuesSeries Class
ValuesSeries Constructor
ValuesSeries Properties
ValuesSeries Methods
XlAxisType Enumeration
Bytescout.Spreadsheet.COM
ICell Interface
ICell Properties
ContainsArrayFormula Property
Formula Property
IsInteger Property
Merged Property
MergedWith Property
MergedWithCell Property
NumberFormatString Property
Value Property
ValueAsBoolean Property
ValueAsDateTime Property
ValueAsDouble Property
ValueAsExcelDisplays Property
ValueAsHTML Property
ValueAsInteger Property
ValueAsString Property
ValueAsUnformattedString Property
ValueDataType Property
ValueDataTypeByNumberFormatString Property
ICell Methods
Calculate Method
Clear Method
GetAddress Method
ToDateTime Method
ToDouble Method
ToHTML Method
ToInteger Method
ToString Method
ICellAddress Interface
ICellAddress Properties
Column Property
ColumnRelative Property
Row Property
RowRelative Property
ICellAddress Methods
IsEmpty Method
ICellsRange Interface
ICellsRange Properties
FirstColumn Property
FirstRow Property
LastColumn Property
LastRow Property
ICellsRange Methods
Equals Method
GetHashCode Method
ToString Method
IColumn Interface
IColumn Properties
Hidden Property
IsFormatted Property
IsNotEmptyCells Property
Item Property
NumberFormat Property
Width Property
IColumn Methods
AutoFit Method
IColumns Interface
IColumns Properties
FirstFormatedColumn Property
Item Property
LastFormatedColumn Property
IColumns Methods
CopyAndPaste Method
Delete Method
Delete Method (Int32)
Delete Method (Int32, Int32)
Insert Method
Insert Method (Int32)
Insert Method (Int32, Int32)
IDefinedName Interface
IDefinedName Properties
Comment Property
Index Property
Name Property
RefersTo Property
Value Property
Visible Property
IDefinedNameList Interface
IDefinedNameList Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
IDefinedNameList Methods
Add Method
IndexOf Method
RemoveAt Method
IDocumentSummaryInformation Interface
IDocumentSummaryInformation Properties
Bytecount Property
Category Property
Cchwithspaces Property
Codepage Property
Company Property
Contentstatus Property
Contenttype Property
Docparts Property
Docversion Property
Headingpair Property
Hiddencount Property
Hyperlinkschanged Property
Language Property
Linecount Property
Linksdirty Property
Manager Property
Mmclipcount Property
Notecount Property
Paracount Property
Presformat Property
Scale Property
Shareddoc Property
Slidecount Property
Version Property
IExtFormat Interface
IExtFormat Properties
AlignmentHorizontal Property
AlignmentVertical Property
BottomBorderColor Property
BottomBorderStyle Property
CellFormat Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternBackColorOLE Property
FillPatternForeColor Property
FillPatternForeColorOLE Property
HiddenFormula Property
Indent Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
LeftBorderColor Property
LeftBorderStyle Property
Locked Property
RightBorderColor Property
RightBorderStyle Property
Rotation Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
Wrap Property
IFontFormat Interface
IFontFormat Properties
Font Property
FontColor Property
FontColorIndex Property
FontEscapement Property
FontUnderline Property
IFontFormat Methods
SetFontColorRGB Method
SetFontProperties Method
IHyperLink Interface
IHyperLink Properties
Address Property
Range Property
ScreenTip Property
SubAddress Property
TextToDisplay Property
IHyperLinks Interface
IHyperLinks Properties
Count Property
Item Property
IHyperLinks Methods
Add Method
Add Method (HyperLink)
Add Method (CellsRange, String, String, String, String)
RemoveAt Method
IRange Interface
IRange Properties
AlignmentHorizontal Property
AlignmentVertical Property
BottomBorderColor Property
BottomBorderStyle Property
BottomRowIndex Property
CellFormat Property
DiagonalBorderColor Property
DiagonalBorderStyle Property
FillPattern Property
FillPatternBackColor Property
FillPatternForeColor Property
Font Property
FontColor Property
FontEscapement Property
FontUnderline Property
Formula Property
HiddenFormula Property
Indent Property
IsDiagonalDownLine Property
IsDiagonalUpLine Property
IsNotEmptyCells Property
LeftBorderColor Property
LeftBorderStyle Property
LeftColumnIndex Property
Locked Property
NumberFormatString Property
RightBorderColor Property
RightBorderStyle Property
RightColumnIndex Property
Rotation Property
ShrinkToFit Property
TextDirection Property
TopBorderColor Property
TopBorderStyle Property
TopRowIndex Property
Value Property
ValueAsHTML Property
ValueDataTypeByNumberFormatString Property
Wrap Property
IRange Methods
Calculate Method
CopyInto Method
CopyInto Method (String)
CopyInto Method (Int32, Int32)
IRow Interface
IRow Properties
ColumnMax Property
ColumnMin Property
Height Property
Hidden Property
IsFormatted Property
IsNotEmptyCells Property
Item Property
NumberFormat Property
UseStandardHeight Property
IRow Methods
AutoFit Method
DeleteCell Method
InsertCell Method
IRows Interface
IRows Properties
FirstFormatedRow Property
Item Property
LastFormatedRow Property
IRows Methods
CopyAndPaste Method
Delete Method
Delete Method (Int32)
Delete Method (Int32, Int32)
Insert Method
Insert Method (Int32)
Insert Method (Int32, Int32)
ISearchOptions Interface
ISearchOptions Properties
CaseSensitiveSearch Property
RegexSearch Property
SearchBackwards Property
SearchString Property
ISpreadsheet Interface
ISpreadsheet Properties
Options Property
RegistrationKey Property
RegistrationName Property
SearchOptions Property
Workbook Property
Worksheets Property
ISpreadsheet Methods
ExportTo2DArray Method
ExportTo2DArray Method
ExportTo2DArray Method (Int32)
ExportTo2DArray Method (String)
ExportToDataSet Method
ExportToDataSet Method
ExportToDataSet Method (DataSet)
ExportToDataSet Method (DataSet, Boolean)
ExportToDataTable Method
ExportToDataTable Method
ExportToDataTable Method (Int32)
ExportToDataTable Method (String)
ExportToDataTable Method (Int32, Boolean)
ExportToDataTable Method (String, Boolean)
ExportToJSON Method
ExportToList Method
ExportToList Method (IList)
ExportToList Method (IList, Int32)
ExportToList Method (IList, String)
GetAsBytesArray Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method
GetAsBytesArrayHTML Method (Int32)
GetAsBytesArrayTXT Method
GetAsBytesArrayXLS Method
GetAsBytesArrayXLSX Method
GetAsBytesArrayXML Method
ImportFrom2DArray Method
ImportFrom2DArray Method (String[,])
ImportFrom2DArray Method (String[,], Int32)
ImportFrom2DArray Method (String[,], String)
ImportFromDataSet Method
ImportFromDataTable Method
ImportFromDataTable Method (DataTable)
ImportFromDataTable Method (DataTable, Int32)
ImportFromDataTable Method (DataTable, String)
ImportFromJSON Method
ImportFromList Method
ImportFromList Method (IList)
ImportFromList Method (IList, Int32)
ImportFromList Method (IList, String)
LoadFromFile Method
LoadFromFile Method (String)
LoadFromFile Method (String, CacheType)
LoadFromFile Method (String, String)
LoadFromFile Method (String, CacheType, String)
LoadFromFile Method (String, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding)
LoadFromFile Method (String, CacheType, String, Encoding, String)
LoadFromStream Method
LoadFromStream Method (Stream)
LoadFromStream Method (Stream, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType)
LoadFromStream Method (Stream, CacheType, String)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)
LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)
LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding, String)
SaveAs Method
SaveAs Method (String)
SaveAs Method (String, SpreadsheetFormatType)
SaveAsCSV Method
SaveAsCSV Method (String, Int32)
SaveAsCSV Method (String, Int32, String)
SaveAsCSV Method (String, Int32, String, String)
SaveAsCSV Method (String, Int32, String, String, Encoding)
SaveAsCSV Method (String, Int32, String, String, Encoding, Boolean)
SaveAsHTML Method
SaveAsHTML Method (String)
SaveAsHTML Method (String, Boolean)
SaveAsPDF Method
SaveAsPDF Method (String)
SaveAsPDF Method (String, Boolean)
SaveAsTXT Method
SaveAsTXT Method (String, Int32)
SaveAsTXT Method (String, Int32, String)
SaveAsTXT Method (String, Int32, String, String)
SaveAsTXT Method (String, Int32, String, String, Encoding)
SaveAsTXT Method (String, Int32, String, String, Encoding, Boolean)
SaveAsXLS Method
SaveAsXLSX Method
SaveAsXLSX Method (String)
SaveAsXLSX Method (String, String)
SaveAsXML Method
SaveAsXML Method (String, Int32)
SaveAsXML Method (String, Int32, Encoding)
SaveToStream Method
SaveToStream Method (Stream)
SaveToStream Method (Stream, SpreadsheetFormatType)
SaveToStreamCSV Method
SaveToStreamCSV Method (Stream, Int32)
SaveToStreamCSV Method (Stream, Int32, String)
SaveToStreamCSV Method (Stream, Int32, String, String)
SaveToStreamCSV Method (Stream, Int32, String, String, Encoding)
SaveToStreamCSV Method (Stream, Int32, String, String, Encoding, Boolean)
SaveToStreamHTML Method
SaveToStreamHTML Method (Stream)
SaveToStreamHTML Method (Stream, Int32)
SaveToStreamTXT Method
SaveToStreamTXT Method (Stream, Int32)
SaveToStreamTXT Method (Stream, Int32, String)
SaveToStreamTXT Method (Stream, Int32, String, String)
SaveToStreamTXT Method (Stream, Int32, String, String, Encoding)
SaveToStreamTXT Method (Stream, Int32, String, String, Encoding, Boolean)
SaveToStreamXLS Method
SaveToStreamXLSX Method
SaveToStreamXLSX Method (Stream)
SaveToStreamXLSX Method (Stream, String)
SaveToStreamXML Method
SaveToStreamXML Method (Stream, Int32)
SaveToStreamXML Method (Stream, Int32, Encoding)
Worksheet Method
ISpreadsheetFont Interface
ISpreadsheetFont Properties
Bold Property
CharacterSet Property
Escapement Property
Font Property
FontColor Property
FontName Property
Height Property
Italic Property
StruckOut Property
Underline Property
ISpreadsheetFont Methods
Equals Method
GetHashCode Method
ISpreadsheetOptions Interface
ISpreadsheetOptions Properties
AutoFitRowsBeforeSave Property
CSVDetectDataTypes Property
MaxColumnCountAllowed Property
MaxRowCountAllowed Property
MaxStringLengthAllowedPerCell Property
ThrowExceptionsOnFormatIncompatibilities Property
ThrowExceptionsOnFormatLimits Property
ISpreadsheetOptions Methods
SetExcel2003Limits Method
SetExcel2007Limits Method
SetOpenOffice3Limits Method
ISummaryInformation Interface
ISummaryInformation Properties
ApplicationName Property
Author Property
CharCount Property
Codepage Property
Comments Property
CreateDateTime Property
EditTime Property
Keywords Property
LastAuthor Property
LastPrinted Property
LastSavedDateTime Property
PageCount Property
RevisionNumber Property
Security Property
Subject Property
Template Property
Title Property
WordCount Property
IViewOptions Interface
IViewOptions Properties
ActivePane Property
FrozenNoSplit Property
GridLineColor Property
GridLinesColorEnabled Property
PageBreakPreview Property
Paged Property
PanesFrozen Property
RightToLeft Property
Selected Property
ShowFormulas Property
ShowGridLines Property
ShowGuts Property
ShowSheetHeaders Property
ShowZeroValues Property
SplitColumn Property
SplitHorizontal Property
SplitRow Property
SplitVertical Property
Zoom Property
IVtHeadingPair Interface
IVtHeadingPair Properties
headerParts Property
headingString Property
IWorkbook Interface
IWorkbook Properties
AddInFunctionsNamesLocale Property
AutoCalculation Property
Colors Property
DefaultFont Property
DocumentProperties Property
ExternalReferenceUpdate Property
Locale Property
Names Property
RangeSelectionMethod Property
Worksheets Property
IWorkbook Methods
Calculate Method
IWorksheet Interface
IWorksheet Properties
Active Property
BackgroundPicture Property
Columns Property
DefaultColumnWidth Property
Hyperlinks Property
IsEmpty Property
Item Property
Item Property (String)
Item Property (Int32, Int32)
Name Property
NotEmptyColumnMax Property
NotEmptyColumnMin Property
NotEmptyRowMax Property
NotEmptyRowMin Property
PageSetup Property
Pictures Property
Protected Property
ProtectionOptions Property
Rows Property
UsedRangeColumnMax Property
UsedRangeColumnMin Property
UsedRangeRowMax Property
UsedRangeRowMin Property
ViewOptions Property
Visible Property
IWorksheet Methods
Calculate Method
Cell Method
Cell Method (String)
Cell Method (Int32, Int32)
Find Method
Find Method
Find Method (String, Boolean, Boolean, Boolean)
FindNext Method
GetAsBytesArrayCSV Method
GetAsBytesArrayHTML Method
GetAsBytesArrayTXT Method
GetAsBytesArrayXML Method
Protect Method
Protect Method (String)
Protect Method (String, EnhancedSheetProtection)
Range Method
Range Method (String)
Range Method (Int32, Int32, Int32, Int32)
SaveAsCSV Method
SaveAsCSV Method (Stream)
SaveAsCSV Method (String)
SaveAsCSV Method (Stream, ConversionOptions)
SaveAsCSV Method (Stream, String)
SaveAsCSV Method (String, ConversionOptions)
SaveAsCSV Method (String, String)
SaveAsCSV Method (Stream, String, String)
SaveAsCSV Method (String, String, String)
SaveAsCSV Method (Stream, String, String, Encoding)
SaveAsCSV Method (String, String, String, Encoding)
SaveAsCSV Method (Stream, String, String, Encoding, Boolean)
SaveAsCSV Method (String, String, String, Encoding, Boolean)
SaveAsHTML Method
SaveAsHTML Method (Stream)
SaveAsHTML Method (StreamWriter)
SaveAsHTML Method (String)
SaveAsPDF Method
SaveAsPDF Method (Stream)
SaveAsPDF Method (String)
SaveAsPDF Method (Stream, Boolean)
SaveAsPDF Method (String, Boolean)
SaveAsTXT Method
SaveAsTXT Method (Stream)
SaveAsTXT Method (String)
SaveAsTXT Method (Stream, ConversionOptions)
SaveAsTXT Method (Stream, String)
SaveAsTXT Method (String, ConversionOptions)
SaveAsTXT Method (String, String)
SaveAsTXT Method (Stream, String, String)
SaveAsTXT Method (String, String, String)
SaveAsTXT Method (Stream, String, String, Encoding)
SaveAsTXT Method (String, String, String, Encoding)
SaveAsTXT Method (Stream, String, String, Encoding, Boolean)
SaveAsTXT Method (String, String, String, Encoding, Boolean)
SaveAsXML Method
SaveAsXML Method (Stream)
SaveAsXML Method (String)
SaveAsXML Method (Stream, Encoding)
SaveAsXML Method (String, Encoding)
UnProtect Method
IWorksheets Interface
IWorksheets Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
IWorksheets Methods
Add Method
Add Method
Add Method (String)
AddFromFile Method
AddFromFile Method (String)
AddFromFile Method (String, String, Encoding)
ByName Method
Copy Method
Delete Method
Delete Method (Int32)
Delete Method (String)
DeleteAll Method
IndexOf Method
Insert Method
Move Method
IXLSDocEngine Interface
IXLSDocEngine Methods
SetParameters Method
Bytescout.Spreadsheet.Constants
AlignmentHorizontal Enumeration
AlignmentVertical Enumeration
BIFF_VERSION Enumeration
BorderLineStyle Enumeration
BorderWeight Enumeration
CellType Enumeration
DataType Enumeration
EnhancedSheetProtection Enumeration
FontEscapementType Enumeration
FontUnderlineStyle Enumeration
FORMULAERROR Enumeration
LineStyle Enumeration
NumberFormatType Enumeration
PageOrder Enumeration
PageOrientation Enumeration
PaperSize Enumeration
PatternStyle Enumeration
PrintErrors Enumeration
PrintLocation Enumeration
ReadingOrder Enumeration
SHEETVISIBILITY Enumeration
SortDataOption Enumeration
SortOrder Enumeration
SortOrientation Enumeration
SpreadsheetFormatType Enumeration
XlCellType Enumeration
xlColorIndex Structure
xlColorIndex Methods
xlColorIndex Fields
Automatic Field
None Field
XlDVAlertStyle Enumeration
XlDVType Enumeration
XlFormatConditionOperator Enumeration
XlFormatConditionType Enumeration
XlIMEMode Enumeration
XLSPallette Class
XLSPallette Constructor
XLSPallette Methods
Colour Method
Index Method
Index Method (Color)
Index Method (Color, Color[])
XLSPallette Fields
Aqua Field
Black Field
Blue Field
BlueViolet Field
Brown Field
Cherry Field
Cherry2 Field
Coral Field
CornFlower Field
DarkBlueGrey Field
DarkBlueGrey2 Field
DarkGreen Field
DarkSky Field
DarkTurquois Field
DarkViolet Field
Emerald Field
Fuchsia Field
Gold Field
Grass Field
Gray Field
Green Field
Grey40 Field
Grey80 Field
Indigo Field
Ivory Field
LightBrown Field
LightOrange Field
LightTurquois Field
LightYellow Field
Lilac Field
Lime Field
Magenta Field
Maroon Field
Navy Field
Olive Field
Olive2 Field
Orange Field
PaleGreen Field
PaleSky Field
PastelSky Field
Purple Field
Red Field
Rose Field
Silver Field
Sky Field
Teal Field
White Field
Yellow Field
XlSpecialCellsValue Enumeration
Bytescout.Spreadsheet.Generic
DefinedNameList Class
DefinedNameList Properties
Count Property
Item Property
Item Property (Int32)
Item Property (String)
DefinedNameList Methods
Add Method
IndexOf Method
RemoveAt Method
HPageBreaks Class
HPageBreaks Properties
Item Property
HPageBreaks Methods
Add Method
Add Method (CellsRange)
Add Method (Range)
IPictures Interface
IPictures Properties
Count Property
Item Property
IPictures Methods
Add Method
Add Method (Double, Double, String)
Add Method (Int32, Int32, String)
Add Method (String, Int32, Int32)
Add Method (Int32, Int32, String, Int32, Int32)
Add Method (String, Int32, Int32, Int32, Int32)
AddAndFitInto Method
AddAndFitInto Method (Int32, Int32, Int32, Int32, String)
AddAndFitInto Method (String, Double, Double, Double, Double)
PageBreaks Class
PageBreaks Properties
Count Property
PageBreaks Methods
Pictures Class
Pictures Constructor
Pictures Properties
Count Property
Item Property
Pictures Methods
Add Method
Add Method (Double, Double, Image)
Add Method (Double, Double, String)
Add Method (Image, Int32, Int32)
Add Method (Int32, Int32, Image)
Add Method (Int32, Int32, String)
Add Method (String, Int32, Int32)
Add Method (Image, Int32, Int32, Int32, Int32)
Add Method (Int32, Int32, Image, Int32, Int32)
Add Method (Int32, Int32, String, Int32, Int32)
Add Method (String, Int32, Int32, Int32, Int32)
AddAndFitInto Method
AddAndFitInto Method (Image, Double, Double, Double, Double)
AddAndFitInto Method (Int32, Int32, Int32, Int32, Image)
AddAndFitInto Method (Int32, Int32, Int32, Int32, String)
AddAndFitInto Method (String, Double, Double, Double, Double)
GetEnumerator Method
VPageBreaks Class
VPageBreaks Properties
Item Property
VPageBreaks Methods
Add Method
Add Method (CellsRange)
Add Method (Range)
Bytescout.Spreadsheet.MSODrawing
FillFormat Class
FillFormat Constructor
FillFormat Properties
BackColor Property
ForeColor Property
GradientColorType Property
GradientDegree Property
GradientStyle Property
GradientVariant Property
Transparency Property
Visible Property
FillFormat Methods
OneColorGradient Method
Solid Method
TwoColorGradient Method
GradientColorType Enumeration
GradientStyle Enumeration
IFillFormat Interface
IFillFormat Properties
BackColor Property
ForeColor Property
GradientColorType Property
GradientDegree Property
GradientStyle Property
GradientVariant Property
Transparency Property
Visible Property
IFillFormat Methods
OneColorGradient Method
Solid Method
TwoColorGradient Method
ILineFormat Interface
ILineFormat Properties
DashStyle Property
ForeColor Property
Style Property
Visible Property
Weight Property
IPictureShape Interface
IPictureShape Properties
Brightness Property
ColorType Property
Contrast Property
CropFromBottom Property
CropFromLeft Property
CropFromRight Property
CropFromTop Property
Fill Property
Height Property
Left Property
LeftColumn Property
Line Property
LockAspectRatio Property
Locked Property
Name Property
Picture Property
PlacementType Property
Print Property
Rotation Property
Top Property
TopRow Property
Width Property
IPictureShape Methods
ScaleHeight Method
ScaleWidth Method
LineDashStyle Enumeration
LineFormat Class
LineFormat Constructor
LineFormat Properties
DashStyle Property
ForeColor Property
Style Property
Visible Property
Weight Property
LineFormat Methods
LineStyle Enumeration
PatternType Enumeration
PictureColorType Enumeration
PictureShape Class
PictureShape Constructor
PictureShape Properties
Brightness Property
ColorType Property
Contrast Property
CropFromBottom Property
CropFromLeft Property
CropFromRight Property
CropFromTop Property
Fill Property
Height Property
Left Property
LeftColumn Property
Line Property
LockAspectRatio Property
Locked Property
Name Property
Picture Property
PlacementType Property
Print Property
Rotation Property
Top Property
TopRow Property
Width Property
PictureShape Methods
ScaleHeight Method
ScaleWidth Method
Placement Enumeration
PresetGradientType Enumeration
PresetTexture Enumeration
Bytescout.Spreadsheet.Protection
EncryptionType Enumeration
Bytescout.Spreadsheet.Structures
CellsRange Class
CellsRange Constructor
CellsRange Constructor (String)
CellsRange Constructor (Int32, Int32, Int32, Int32)
CellsRange Properties
FirstColumn Property
FirstRow Property
LastColumn Property
LastRow Property
CellsRange Methods
Equals Method
GetHashCode Method
ToString Method
CellsRange Operators
Equality Operator
Inequality Operator
HPageBreak Class
HPageBreak Properties
Location Property
HPageBreak Methods
PageBreak Class
PageBreak Properties
Pt Property
PageBreak Methods
PaneTypes Enumeration
VPageBreak Class
VPageBreak Properties
Location Property
VPageBreak Methods
Microsoft.Office.Crypto.Agile
CipherConfig Class
CipherConfig Constructor
CipherConfig Properties
BlockBits Property
KeyBits Property
Mode Property
Name Property
CipherConfig Methods
Copy Method
GetAlg Method
ConsoleLog Class
ConsoleLog Constructor
ConsoleLog Methods
WriteBytes Method
WriteIndent Method
WriteLine Method
EncryptedStream Class
EncryptedStream Constructor
EncryptedStream Properties
CanRead Property
CanSeek Property
CanWrite Property
Length Property
Position Property
EncryptedStream Methods
Dispose Method
Dispose Method (Boolean)
Flush Method
Read Method
Seek Method
SetLength Method
Write Method
EncryptionConfig Class
EncryptionConfig Constructor
EncryptionConfig Properties
CipherConfig Property
HashConfig Property
PasswordKeyEncryptorConfig Property
SaltSize Property
EncryptionConfig Methods
EncryptionSession Class
EncryptionSession Constructor
EncryptionSession Properties
CipherBlockBytes Property
IsUnlocked Property
EncryptionSession Methods
AddIntegrityCheck Method
DoIntegrityCheck Method
GetDecryptor Method
GetEncryptedStream Method
GetEncryptor Method
LoadFromStream Method
LoadFromStream Method (Stream)
LoadFromStream Method (Stream, Boolean)
UnlockWithPassword Method
WriteToStream Method
HashConfig Class
HashConfig Constructor
HashConfig Properties
HashBits Property
Name Property
HashConfig Methods
Copy Method
GetAlg Method
ICipherProvider Interface
ICipherProvider Properties
BlockBytes Property
ICipherProvider Methods
GetCryptoTransform Method
ILog Interface
ILog Methods
WriteBytes Method
WriteLine Method
Log Class
Log Methods
IndentLevel Method
PeekScope Method
PopScope Method
PushScope Method
WriteBytes Method
WriteLine Method
Log Fields
Instance Field
PasswordKeyEncryptorConfig Class
PasswordKeyEncryptorConfig Constructor
PasswordKeyEncryptorConfig Properties
CipherConfig Property
HashConfig Property
SaltSize Property
SpinCount Property
PasswordKeyEncryptorConfig Methods
Utils Class
Utils Methods
AllElementsIsZero Method
CloneToFit Method
CloneToFit Method (Byte[], Int32)
CloneToFit Method (Byte[], Int32, Byte)
CopyFromFile Method
CopyToFile Method
EqualBytes Method
GetCryptoTransform Method
GetDecryptor Method
GetDecryptor Method (ICipherProvider, Byte[])
GetDecryptor Method (ICipherProvider, Int32, Int32)
GetEncryptor Method
GetEncryptor Method (ICipherProvider, Byte[])
GetEncryptor Method (ICipherProvider, Int32, Int32)
ReadBytes Method
ReadInt16 Method
ReadInt32 Method
ReadInt64 Method
RoundUp Method
TransformInPlace Method
WriteInt16 Method
WriteInt32 Method
WriteInt64 Method
Supported formulas
ActiveX Notice
Console version (command line) options
Installation Tasks (.NET)
Installation Tasks (ActiveX for VB6 and other)
History
License Agreement
How To Buy
This page uses an IFRAME but your browser does not support it.