Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
The ISpreadsheet type exposes the following members.
Methods
Name | Description | |
---|---|---|
ExportTo2DArray |
Return spreadsheet rows and columns as two-dimensional array;
| |
ExportTo2DArray(Int32) |
Return spreadsheet rows and columns as two-dimensional array;
| |
ExportTo2DArray(String) |
Return spreadsheet rows and columns as two-dimensional array;
| |
ExportToDataSet |
Return new DataSet filled from spreadsheet.
| |
ExportToDataSet(DataSet) |
Fill provided DataSet with DataTables created from spreadsheet's worksheets.
| |
ExportToDataSet(DataSet, Boolean) |
Fill provided DataSet with DataTables created from spreadsheet's worksheets.
| |
ExportToDataTable |
Return new DataTable object filled from first worksheet.
| |
ExportToDataTable(Int32) |
Return new DataTable object filled from specified worksheet.
| |
ExportToDataTable(String) |
Return new DataTable object filled from specified worksheet.
| |
ExportToDataTable(Int32, Boolean) |
Return new DataTable object filled from specified worksheet.
| |
ExportToDataTable(String, Boolean) |
Return new DataTable object filled from specified worksheet.
| |
ExportToJSON |
Return JSON data filled from spreadsheet.
| |
ExportToList(IList) |
Export rows to provided IList. Each row is String[] array of column values.
| |
ExportToList(IList, Int32) |
Export the worksheet specified by index to the list
| |
ExportToList(IList, String) |
Export the named worksheet to the list
| |
GetAsBytesArray |
Gets the bytes of spreadsheet saved as document with specified type.
| |
GetAsBytesArrayCSV |
Gets the bytes of spreadsheet saved as CSV document.
| |
GetAsBytesArrayHTML |
Gets the bytes of spreadsheet saved as HTML document.
| |
GetAsBytesArrayHTML(Int32) |
Gets the bytes of specified worksheet page saved as HTML document.
| |
GetAsBytesArrayTXT |
Gets the bytes of spreadsheet saved as text document.
| |
GetAsBytesArrayXLS |
Gets the bytes of spreadsheet saved as XLS document.
| |
GetAsBytesArrayXLSX |
Gets the bytes of spreadsheet saved as XLSX document.
| |
GetAsBytesArrayXML |
Gets the bytes of spreadsheet saved as XML document.
| |
ImportFrom2DArray(String) |
Import from two-dimensional array.
| |
ImportFrom2DArray(String, Int32) |
Import from two-dimensional array to the specified worksheet
| |
ImportFrom2DArray(String, String) |
Import from two-dimensional array to the specified worksheet
| |
ImportFromDataSet |
Import from DataSet. Create a worksheet for every DataTable in DataSet.
| |
ImportFromDataTable(DataTable) |
Import rows and columns from DataTable to first worksheet.
| |
ImportFromDataTable(DataTable, Int32) |
Import rows and columns from DataTable to specified worksheet.
| |
ImportFromDataTable(DataTable, String) |
Import rows and columns from DataTable to specified worksheet.
| |
ImportFromJSON |
Fills the spreadsheet with rows and columns from JSON data string.
| |
ImportFromList(IList) |
Import from IList of rows. Each row will contain IList of columns.
| |
ImportFromList(IList, Int32) |
Import from IList of rows to the specified worksheet
| |
ImportFromList(IList, String) |
Import from IList of rows to the specified worksheet
| |
LoadFromFile(String) |
Load data from file.
| |
LoadFromFile(String, CacheType) |
Load data from file.
| |
LoadFromFile(String, String) |
Load data from file.
| |
LoadFromFile(String, CacheType, String) |
Load data from file.
| |
LoadFromFile(String, String, Encoding) |
Load data from file.
| |
LoadFromFile(String, CacheType, String, Encoding) |
Load data from file.
| |
LoadFromFile(String, CacheType, String, Encoding, String) |
Load data from file.
| |
LoadFromStream(Stream) |
Load data from stream.
| |
LoadFromStream(Stream, CacheType) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType) |
Load data from stream.
| |
LoadFromStream(Stream, CacheType, String) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, CacheType) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, String, Encoding) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding) |
Load data from stream.
| |
LoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding, String) |
Load data from stream.
| |
SaveAs(String) |
Saves data in XLS or XLSX file FileName.
| |
SaveAs(String, SpreadsheetFormatType) |
Saves data in XLS or XLSX file FileName.
| |
SaveAsCSV(String, Int32) |
Saves data in CSV file with specified name.
| |
SaveAsCSV(String, Int32, String) |
Saves data in CSV file with specified name.
| |
SaveAsCSV(String, Int32, String, String) |
Saves data in CSV file with specified name.
| |
SaveAsCSV(String, Int32, String, String, Encoding) |
Saves data in CSV file with specified name.
| |
SaveAsCSV(String, Int32, String, String, Encoding, Boolean) |
Saves data in CSV file with specified name.
| |
SaveAsHTML(String) |
Saves spreadsheet in a HTML format file.
The second and subsequent worksheets of the spreadsheet will be saved
in separate files with auto-generated names.
| |
SaveAsHTML(String, Boolean) |
Saves spreadsheet in a HTML format file.
The second and subsequent worksheets of the spreadsheet will be saved
in separate files with auto-generated names.
| |
SaveAsPDF(Stream) |
Exports spreadsheet to stream in PDF format.
| |
SaveAsPDF(String) |
Saves spreadsheet to PDF file with specified name.
| |
SaveAsPDF(Stream, Boolean) |
Exports spreadsheet to stream in PDF format.
| |
SaveAsPDF(String, Boolean) |
Saves spreadsheet to PDF file with specified name.
| |
SaveAsPDF(Stream, Boolean, String) |
Exports spreadsheet to stream in PDF format.
| |
SaveAsPDF(String, Boolean, String) |
Saves spreadsheet to PDF file with specified name.
| |
SaveAsTXT(String, Int32) |
Saves data in TXT delimiter-separated file with specified name.
| |
SaveAsTXT(String, Int32, String) |
Saves data in TXT delimiter-separated file with specified name.
| |
SaveAsTXT(String, Int32, String, String) |
Saves data in TXT delimiter-separated file with specified name.
| |
SaveAsTXT(String, Int32, String, String, Encoding) |
Saves data in TXT delimiter-separated file with specified name.
| |
SaveAsTXT(String, Int32, String, String, Encoding, Boolean) |
Saves data in TXT delimiter-separated file with specified name.
| |
SaveAsXLS |
Saves data in XLS file FileName
| |
SaveAsXLSX(String) |
Saves data in XLSX file FileName
| |
SaveAsXLSX(String, String) |
Saves data in XLSX format to a file with specified name.
| |
SaveAsXML(String, Int32) |
Saves data in XML file with specified name.
| |
SaveAsXML(String, Int32, Encoding) |
Saves data in XML file with specified name.
| |
SaveToStream(Stream) |
Saves data in XLS format to a given stream.
| |
SaveToStream(Stream, SpreadsheetFormatType) |
Saves data in XLS or XLSX format to a given stream.
| |
SaveToStreamCSV(Stream, Int32) |
Saves data in CSV format to a given stream.
| |
SaveToStreamCSV(Stream, Int32, String) |
Saves data in CSV format to a given stream.
| |
SaveToStreamCSV(Stream, Int32, String, String) |
Saves data in CSV format to a given stream.
| |
SaveToStreamCSV(Stream, Int32, String, String, Encoding) |
Saves data in CSV format to a given stream.
| |
SaveToStreamCSV(Stream, Int32, String, String, Encoding, Boolean) |
Saves data in CSV format to a given stream.
| |
SaveToStreamHTML(Stream) |
Saves first worksheet of spreadsheet as HTML document to a given stream.
| |
SaveToStreamHTML(Stream, Int32) |
Saves a worksheet of spreadsheet as HTML document to a given stream.
| |
SaveToStreamTXT(Stream, Int32) |
Saves data in TXT format to a given stream.
| |
SaveToStreamTXT(Stream, Int32, String) |
Saves data in TXT format to a given stream.
| |
SaveToStreamTXT(Stream, Int32, String, String) |
Saves data in TXT format to a given stream.
| |
SaveToStreamTXT(Stream, Int32, String, String, Encoding) |
Saves data in TXT format to a given stream.
| |
SaveToStreamTXT(Stream, Int32, String, String, Encoding, Boolean) |
Saves data in TXT format to a given stream.
| |
SaveToStreamXLS |
Saves data in XLS format to a given stream.
| |
SaveToStreamXLSX(Stream) |
Saves data in XLSX format to a given stream.
| |
SaveToStreamXLSX(Stream, String) |
Saves data in XLSX format to a given stream.
| |
SaveToStreamXML(Stream, Int32) |
Saves data in XML format to a given stream.
| |
SaveToStreamXML(Stream, Int32, Encoding) |
Saves data in XML format to a given stream.
| |
Worksheet |
Return Worksheet the specified index.
|
See Also