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