Link Search Menu Expand Document

ISpreadsheet Methods

The ISpreadsheet type exposes the following members.

Methods
NameDescription
Public methodExportTo2DArray
Return spreadsheet rows and columns as two-dimensional array;
Public methodExportTo2DArray(Int32)
Return spreadsheet rows and columns as two-dimensional array;
Public methodExportTo2DArray(String)
Return spreadsheet rows and columns as two-dimensional array;
Public methodExportToDataSet
Return new DataSet filled from spreadsheet.
Public methodExportToDataSet(DataSet)
Fill provided DataSet with DataTables created from spreadsheet's worksheets.
Public methodExportToDataSet(DataSet, Boolean)
Fill provided DataSet with DataTables created from spreadsheet's worksheets.
Public methodExportToDataTable
Return new DataTable object filled from first worksheet.
Public methodExportToDataTable(Int32)
Return new DataTable object filled from specified worksheet.
Public methodExportToDataTable(String)
Return new DataTable object filled from specified worksheet.
Public methodExportToDataTable(Int32, Boolean)
Return new DataTable object filled from specified worksheet.
Public methodExportToDataTable(String, Boolean)
Return new DataTable object filled from specified worksheet.
Public methodExportToJSON
Return JSON data filled from spreadsheet.
Public methodExportToList(IList)
Export rows to provided IList. Each row is String[] array of column values.
Public methodExportToList(IList, Int32)
Export the worksheet specified by index to the list
Public methodExportToList(IList, String)
Export the named worksheet to the list
Public methodGetAsBytesArray
Gets the bytes of spreadsheet saved as document with specified type.
Public methodGetAsBytesArrayCSV
Gets the bytes of spreadsheet saved as CSV document.
Public methodGetAsBytesArrayHTML
Gets the bytes of spreadsheet saved as HTML document.
Public methodGetAsBytesArrayHTML(Int32)
Gets the bytes of specified worksheet page saved as HTML document.
Public methodGetAsBytesArrayTXT
Gets the bytes of spreadsheet saved as text document.
Public methodGetAsBytesArrayXLS
Gets the bytes of spreadsheet saved as XLS document.
Public methodGetAsBytesArrayXLSX
Gets the bytes of spreadsheet saved as XLSX document.
Public methodGetAsBytesArrayXML
Gets the bytes of spreadsheet saved as XML document.
Public methodImportFrom2DArray(String)
Import from two-dimensional array.
Public methodImportFrom2DArray(String, Int32)
Import from two-dimensional array to the specified worksheet
Public methodImportFrom2DArray(String, String)
Import from two-dimensional array to the specified worksheet
Public methodImportFromDataSet
Import from DataSet. Create a worksheet for every DataTable in DataSet.
Public methodImportFromDataTable(DataTable)
Import rows and columns from DataTable to first worksheet.
Public methodImportFromDataTable(DataTable, Int32)
Import rows and columns from DataTable to specified worksheet.
Public methodImportFromDataTable(DataTable, String)
Import rows and columns from DataTable to specified worksheet.
Public methodImportFromJSON
Fills the spreadsheet with rows and columns from JSON data string.
Public methodImportFromList(IList)
Import from IList of rows. Each row will contain IList of columns.
Public methodImportFromList(IList, Int32)
Import from IList of rows to the specified worksheet
Public methodImportFromList(IList, String)
Import from IList of rows to the specified worksheet
Public methodLoadFromFile(String)
Load data from file.
Public methodLoadFromFile(String, CacheType)
Load data from file.
Public methodLoadFromFile(String, String)
Load data from file.
Public methodLoadFromFile(String, CacheType, String)
Load data from file.
Public methodLoadFromFile(String, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding, String)
Load data from file.
Public methodLoadFromStream(Stream)
Load data from stream.
Public methodLoadFromStream(Stream, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType)
Load data from stream.
Public methodLoadFromStream(Stream, CacheType, String)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, String, Encoding)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding, String)
Load data from stream.
Public methodSaveAs(String)
Saves data in XLS or XLSX file FileName.
Public methodSaveAs(String, SpreadsheetFormatType)
Saves data in XLS or XLSX file FileName.
Public methodSaveAsCSV(String, Int32)
Saves data in CSV file with specified name.
Public methodSaveAsCSV(String, Int32, String)
Saves data in CSV file with specified name.
Public methodSaveAsCSV(String, Int32, String, String)
Saves data in CSV file with specified name.
Public methodSaveAsCSV(String, Int32, String, String, Encoding)
Saves data in CSV file with specified name.
Public methodSaveAsCSV(String, Int32, String, String, Encoding, Boolean)
Saves data in CSV file with specified name.
Public methodSaveAsHTML(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.
Public methodSaveAsHTML(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.
Public methodSaveAsPDF(Stream)
Exports spreadsheet to stream in PDF format.
Public methodSaveAsPDF(String)
Saves spreadsheet to PDF file with specified name.
Public methodSaveAsPDF(Stream, Boolean)
Exports spreadsheet to stream in PDF format.
Public methodSaveAsPDF(String, Boolean)
Saves spreadsheet to PDF file with specified name.
Public methodSaveAsPDF(Stream, Boolean, String)
Exports spreadsheet to stream in PDF format.
Public methodSaveAsPDF(String, Boolean, String)
Saves spreadsheet to PDF file with specified name.
Public methodSaveAsTXT(String, Int32)
Saves data in TXT delimiter-separated file with specified name.
Public methodSaveAsTXT(String, Int32, String)
Saves data in TXT delimiter-separated file with specified name.
Public methodSaveAsTXT(String, Int32, String, String)
Saves data in TXT delimiter-separated file with specified name.
Public methodSaveAsTXT(String, Int32, String, String, Encoding)
Saves data in TXT delimiter-separated file with specified name.
Public methodSaveAsTXT(String, Int32, String, String, Encoding, Boolean)
Saves data in TXT delimiter-separated file with specified name.
Public methodSaveAsXLS
Saves data in XLS file FileName
Public methodSaveAsXLSX(String)
Saves data in XLSX file FileName
Public methodSaveAsXLSX(String, String)
Saves data in XLSX format to a file with specified name.
Public methodSaveAsXML(String, Int32)
Saves data in XML file with specified name.
Public methodSaveAsXML(String, Int32, Encoding)
Saves data in XML file with specified name.
Public methodSaveToStream(Stream)
Saves data in XLS format to a given stream.
Public methodSaveToStream(Stream, SpreadsheetFormatType)
Saves data in XLS or XLSX format to a given stream.
Public methodSaveToStreamCSV(Stream, Int32)
Saves data in CSV format to a given stream.
Public methodSaveToStreamCSV(Stream, Int32, String)
Saves data in CSV format to a given stream.
Public methodSaveToStreamCSV(Stream, Int32, String, String)
Saves data in CSV format to a given stream.
Public methodSaveToStreamCSV(Stream, Int32, String, String, Encoding)
Saves data in CSV format to a given stream.
Public methodSaveToStreamCSV(Stream, Int32, String, String, Encoding, Boolean)
Saves data in CSV format to a given stream.
Public methodSaveToStreamHTML(Stream)
Saves first worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamHTML(Stream, Int32)
Saves a worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamTXT(Stream, Int32)
Saves data in TXT format to a given stream.
Public methodSaveToStreamTXT(Stream, Int32, String)
Saves data in TXT format to a given stream.
Public methodSaveToStreamTXT(Stream, Int32, String, String)
Saves data in TXT format to a given stream.
Public methodSaveToStreamTXT(Stream, Int32, String, String, Encoding)
Saves data in TXT format to a given stream.
Public methodSaveToStreamTXT(Stream, Int32, String, String, Encoding, Boolean)
Saves data in TXT format to a given stream.
Public methodSaveToStreamXLS
Saves data in XLS format to a given stream.
Public methodSaveToStreamXLSX(Stream)
Saves data in XLSX format to a given stream.
Public methodSaveToStreamXLSX(Stream, String)
Saves data in XLSX format to a given stream.
Public methodSaveToStreamXML(Stream, Int32)
Saves data in XML format to a given stream.
Public methodSaveToStreamXML(Stream, Int32, Encoding)
Saves data in XML format to a given stream.
Public methodWorksheet
Return Worksheet the specified index.
Top
See Also

Reference