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 Classic
ASP.NET C#
Display XLS as HTML | ASP.NET C#
ASP.NET VB.NET
Display XLS as HTML | ASP.NET VB.NET
C#
Add Area Chart | C#
Add Background Image | C#
Add Bar Chart | C#
Add Bubble Chart | C#
Add Column Chart | C#
Add Columns Into Existing Spreadsheet | C#
Add Combination Chart | C#
Add Doughnut Chart | C#
Add Header and Footer for Spreadsheet | C#
Add Image Into Existing Spreadsheet | C#
Add Image to Spreadsheet | C#
Add Images Advanced | C#
Add Images to Spreadsheet | C#
Add Line Chart | C#
Add Pie Chart | C#
Add Radar Chart | C#
Add Rows Into Existing Spreadsheet | C#
Add Stock Chart | C#
Add Surface Chart | C#
Add XYScatter Chart | C#
Calculate Auto Update On Cell Change | C#
Calculate Formula In Cell | C#
Calculate XIRR Function | C#
Calculations and Spreadsheet as Database | C#
Change Cell Width and Height | C#
Change Column Width and Row Height | C#
Change Data in Existing Spreadsheet | C#
Change Document Properties | C#
Convert CSV to SQL Server | C#
Convert CSV To XLS | C#
Convert ODS to SQL Server | C#
Convert Template To XLS | C#
Convert TXT to SQL Server | C#
Convert XLS to CSV | C#
Convert XLS to SQL Server | C#
Convert XLS to SQL Server (via CSV BULK INSERT) | C#
Convert XLS to TXT | C#
Convert XLS to XLSX | C#
Convert XLS to XML | C#
Convert XLS to XML and XML to XLS | C#
Convert XLSX to SQL Server | C#
Convert XML to XLS | C#
Copy Range | C#
Copy Worksheet | C#
CopyPaste Columns | C#
CopyPaste Rows | C#
Create Hello World Spreadsheet | C#
Create Worksheets | C#
Create XLSX | C#
Export To 2D Array | C#
Export To Dataset | C#
Export To DataTable | C#
Export To HTML | C#
Export To Jagged Array | C#
Export To JSON | C#
Export To List | C#
Export To PDF | C#
Export to WinForms DataGrid | C#
Font Style In Cell | C#
Fonts Available For Cells | C#
Freeze Rows And Columns | C#
Generate Invoice | C#
Get Cell Color | C#
Hidden Formula | C#
Hidden Rows And Columns | C#
Import From 2D Array | C#
Import From Data Table | C#
Import From Dataset | C#
Import From Jagged Array | C#
Import From JSON | C#
Import From List | C#
Import From WinForms DataGrid | C#
Insert Page Break | C#
Line Styles In Cells | C#
Merge Cells | C#
Merge Two Documents | C#
Read Cell Color | C#
Read CSV File | C#
Read Date From Cell | C#
Read Document Properties | C#
Read Formula From Cell | C#
Read Merged Cells | C#
Read Number Format In Cell | C#
Read ODS (Open Office Calc) Files | C#
Read TXT (Tab Delimited) | C#
Read XLSX (Office 2007) Files | C#
Read XML Spreadsheet (SpreadsheetML format) | C#
Remove Columns from Existing Spreadsheet | C#
Remove Rows from Existing Spreadsheet | C#
Rename Worksheet | C#
Search Text | C#
Select Active Worksheet | C#
Set Cell Alignment | C#
Set Cell Formula | C#
Set Date Formatting in Cells | C#
Set Number Format In Cells | C#
Set Rich Text Formatting in Cell | C#
Set ShrinkToFit for Cells | C#
Sort Range | C#
Swap Cells and Their Values | C#
Swap Worksheets | C#
Unmerge Cells | C#
Use Custom Functions | C#
Use Rich Formatting to Create Report | C#
Use Special Cells | C#
Use Unicode Text | C#
Validate Cell if Value is in Range | C#
Validate Cells with Dates | C#
Validate Data in Cell and Mark Wrong With Color | C#
View Spreadsheet | C#
C++ (managed)
Create Simple Spreadsheet | C++ (managed)
C++ (unmanaged)
Create Simple Spreasdsheet | C++ (unmanaged)
Console
Convert in Batch from XLS to CSV | Console
Convert in Batch to XLS | Console
VB.NET
Add Area Chart | VB.NET
Add Background Image | VB.NET
Add Bar Chart | VB.NET
Add Bubble Chart | VB.NET
Add Column Chart | VB.NET
Add Columns Into Existing Spreadsheet | VB.NET
Add Combination Chart | VB.NET
Add Doughnut Chart | VB.NET
Add Header and Footer | VB.NET
Add Images | VB.NET
Add Images Advanced | VB.NET
Add Line Chart | VB.NET
Add Pie Chart | VB.NET
Add Radar Chart | VB.NET
Add Rows Into Existing Spreadsheet | VB.NET
Add Stock Chart | VB.NET
Add Surface Chart | VB.NET
Add XYScatter Chart | VB.NET
Calculate Formula In Cell | VB.NET
Calculate XIRR Function | VB.NET
Calculations and Spreadsheet as Database | VB.NET
Change Cell Width and Height | VB.NET
Change Column Width and Row Height | VB.NET
Change Data in Existing Spreadsheet | VB.NET
Change Document Properties | VB.NET
Convert ODS to SQL Server | VB.NET
Convert Template To XLS | VB.NET
Convert TXT to SQL Server | VB.NET
Convert XLS to CSV | VB.NET
Convert XLS to SQL Server | VB.NET
Convert XLS to SQL Server (via CSV BULK INSERT) | VB.NET
Convert XLS to TXT | VB.NET
Convert XLS to XLSX | VB.NET
Convert XLS to XML | VB.NET
Convert XLS to XML and XML to XLS | VB.NET
Convert XLSX to SQL Server | VB.NET
Convert XML to XLS | VB.NET
Copy Range | VB.NET
Copy Worksheet | VB.NET
CopyPaste Columns | VB.NET
CopyPaste Rows | VB.NET
Create Simple Hello World Spreadsheet | VB.NET
Create Worksheets | VB.NET
Create XLSX | VB.NET
CSV to SQL Server | VB.NET
CSV to XLS | VB.NET
Export To 2D Array | VB.NET
Export To DataSet | VB.NET
Export To DataTable | VB.NET
Export To HTML | VB.NET
Export To Jagged Array | VB.NET
Export To JSON | VB.NET
Export To List | VB.NET
Export To PDF | VB.NET
Export to WinForms DataGrid | VB.NET
Font Style In Cell | VB.NET
Fonts Available For Cells | VB.NET
Freeze Rows And Columns | VB.NET
Generate Invoice | VB.NET
Get Cell Color | VB.NET
Import From 2D Array | VB.NET
Import From DataSet | VB.NET
Import From DataTable | VB.NET
Import From Jagged Array | VB.NET
Import From JSON | VB.NET
Import From List | VB.NET
Import From WinForms DataGrid | VB.NET
Insert Page Break | VB.NET
Line Styles In Cells | VB.NET
Merge Cells | VB.NET
Merge Two Documents | VB.NET
Number Format In Cells | VB.NET
Read Cell Color | VB.NET
Read CSV File | VB.NET
Read Date From Cell | VB.NET
Read Document Properties | VB.NET
Read Formula From Cell | VB.NET
Read Merged Cells | VB.NET
Read Number Format In Cell | VB.NET
Read ODS (Open Office Calc) Files | VB.NET
Read XLSX (Office 2007) Files | VB.NET
Read XML Spreadsheet (SpreadsheetML format) | VB.NET
Remove Columns from Existing Spreadsheet | VB.NET
Remove Rows from Existing Spreadsheet | VB.NET
Rename Worksheet | VB.NET
Rich Text Formatting in Cell | VB.NET
Search Text | VB.NET
Select Active Worksheet | VB.NET
Set Cell Alignment | VB.NET
Set Cell Formula | VB.NET
Set Custom Functions | VB.NET
Set Date Formatting in Cells | VB.NET
Set Hidden Formula | VB.NET
Set Hidden Rows And Columns | VB.NET
Set ShrinkToFit for Cells | VB.NET
Swap Cells and Their Values | VB.NET
Swap Worksheets | VB.NET
Unmerge Cells | VB.NET
Use Rich Formatting to Create Report | VB.NET
Use Unicode Text | VB.NET
Validate Cell if Value is in Range | VB.NET
Validate Cells with Dates | VB.NET
Validate Data in Cell and Mark Wrong With Color | VB.NET
View Spreadsheet | VB.NET
VB6
Create Spreadsheet | VB6
VBScript
Add Images to Spreadsheet | VBScript
Change Cell Background Color | VBScript
Change Column Height | VBScript
Change Row Height | VBScript
Convert CSV to XLS | VBScript
Copy Data Between Spreadsheets | VBScript
Create Barcode from Excel | VBScript
Create Simple Spreadsheet | VBScript
Export To HTML | VBScript
Merge Cells and Set Alignment | VBScript
Save As PDF | VBScript
Use Rich Text Formatting | VBScript
Web API Samples
C#
Convert CSV To PDF From Uploaded File | C#
Convert CSV To PDF From URL | C#
Convert CSV To PDF From URL Asynchronously | C#
cURL
Convert CSV To PDF From URL | cURL
Java
Convert CSV To PDF From Uploaded File | Java
Convert CSV To PDF From URL | Java
JavaScript
Convert CSV To PDF From Uploaded File (Node.js) | JavaScript
Convert CSV To PDF From Uploaded File (Node.js) - Async API | JavaScript
Convert CSV To PDF From URL (Node.js) | JavaScript
Convert CSV To PDF From URL (Node.js) - Async API | JavaScript
PHP
Convert CSV To PDF Asynchronously | PHP
Convert CSV To PDF From Uploaded File | PHP
PowerShell
Convert CSV To PDF From Uploaded File | PowerShell
Convert CSV To PDF From URL | PowerShell
Convert CSV To PDF From URL Asynchronously | PowerShell
VB.NET
Convert CSV To PDF From Uploaded File | VB.NET
Convert CSV To PDF From URL | VB.NET
Convert CSV To PDF From URL Asynchronously | VB.NET
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
PrintHeadings 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
FormatChecker
crc32 Class
crc32 Constructor
crc32 Methods
AddByteCRC Method
CRC Method
CRC Method (Byte[])
CRC Method (Stream)
CRC Method (String)
CRC Method (Stream, Int64, Int64)
EndByteCRC Method
StartByteCRC Method
Microsoft.Office.Crypto.Agile
ConsoleLog Class
ConsoleLog Constructor
ConsoleLog Methods
WriteBytes Method
WriteIndent Method
WriteLine 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.