Description

The ExcelWorkbook type exposes the following methods.

Methods

 Public

 Protected
 Instance

 Static
 Declared

 Inherited
 XNA Framework Only

 .NET Compact Framework Only

  Member Description
GetCellByName(String)
Returns cell with specified defined name.
GetListNamesOfCells()()()()
Returns array of defined names of cells.
ReadCSV(Stream)
Reads CSV TXT files from the stream.
ReadCSV(String)
Reads CSV TXT files and creates a workbook.
ReadCSV(Uri)
Reads CSV TXT files from remote URL address.
ReadCSV(Stream, ProgressEventHandler)
Reads CSV TXT files from the stream.
ReadCSV(String, ProgressEventHandler)
Reads CSV TXT files and creates a workbook.
ReadCSV(Uri, ProgressEventHandler)
Reads CSV TXT files from remote URL address.
ReadCSV(Stream, Char, Encoding)
Reads CSV TXT files from the stream.
ReadCSV(String, Char, Encoding)
Reads CSV TXT files and creates a workbook.
ReadCSV(Uri, Char, Encoding)
Reads CSV TXT files and creates a workbook.
ReadCSV(Stream, Char, Encoding, ProgressEventHandler)
Reads CSV TXT files from the stream.
ReadCSV(String, Char, Encoding, ProgressEventHandler)
Reads CSV TXT files and creates a workbook.
ReadCSV(Uri, Char, Encoding, ProgressEventHandler)
Reads CSV TXT files and creates a workbook.
ReadFromDataSet(DataSet)
Adds all DataTable to the ExcelWorkbook from specified DataSet.
ReadHTML(Stream)
This will create a new ExcelWorkbook object by parsing the HTML of memory stream.
ReadHTML(String)
This will create a new ExcelWorkbook object by parsing the HTML string, file or remote address.
ReadHTML(Uri)
This will create a new ExcelWorkbook object by parsing the HTML of remote address.
ReadXLS(Stream)
Reads the XLS file from the stream.
ReadXLS(String)
Reads the XLS file and loads the workbook.
ReadXLS(Uri)
Reads the XLS file from remote URL address.
ReadXLS(Stream, ProgressEventHandler)
Reads the XLS file from the stream.
ReadXLS(Stream, String)
Reads the XLS file from the stream.
ReadXLS(String, ProgressEventHandler)
ReadXLS(String, String)
Reads the XLS file and loads the workbook.
ReadXLS(Uri, ProgressEventHandler)
Reads the XLS file from remote URL address.
ReadXLS(Uri, String)
Reads the XLS file from remote URL address.
ReadXLS(Stream, String, ProgressEventHandler)
Reads the XLS file from the stream.
ReadXLS(String, String, ProgressEventHandler)
Reads the XLS file and loads the workbook.
ReadXLS(Uri, String, ProgressEventHandler)
Reads the XLS file from remote URL address.
ReadXLSX(Stream)
Reads the XLSX file from the stream.
ReadXLSX(String)
Reads the XLSX file and loads the workbook.
ReadXLSX(Uri)
Reads the XLSX file from remote URL address.
ReadXLSX(Stream, ProgressEventHandler)
Reads the XLSX file from the stream.
ReadXLSX(Stream, String)
Reads the XLSX file from the stream.
ReadXLSX(String, ProgressEventHandler)
Reads the XLSX file and loads the workbook.
ReadXLSX(String, String)
Reads the XLSX file and loads the workbook.
ReadXLSX(Uri, ProgressEventHandler)
Reads the XLSX file from remote URL address.
ReadXLSX(Uri, String)
Reads the XLSX file from remote URL address.
ReadXLSX(Stream, String, ProgressEventHandler)
Reads the XLSX file from the stream.
ReadXLSX(String, String, ProgressEventHandler)
Reads the XLSX file and loads the workbook.
ReadXLSX(Uri, String, ProgressEventHandler)
Reads the XLSX file from remote URL address.
SetLicenseCode(String)
Checks the specified license code for authenticity.
WriteCSV()()()()
Created in memory a new .CSV file which contains current Workbook.
WriteCSV(String)
Created a new .CSV file which contains current Workbook.
WriteHTML()()()()
Save ExcelWorksheet to string.
WriteHTML(Int32)
WriteHTML(String)
Save ExcelWorksheet to html file.
WriteHTML(Encoding)
Save ExcelWorksheet to stream.
WriteHTML(String, Int32)
Save ExcelWorksheet to html file.
WriteHTML(String, Encoding)
Save ExcelWorksheet to html file.
WriteHTML(Encoding, Int32)
WriteHTML(String, Encoding, Int32)
Save ExcelWorksheet to html file.
WriteToDataSet()()()()
Allows to get data of ExcelWorkbook as a DataSet.
WriteXLS()()()()
Creates in memory a new XLS file which contains current Workbook.
WriteXLS(String)
Writes the Workbook to the XLS file.
WriteXLSX()()()()
Creates in memory a new XLSX file which contains current Workbook.
WriteXLSX(String)
Writes the Workbook to the XLSX file.

See Also