Description
Represents a ExcelWorkbook.

Namespace: Docs.Excel
Assembly: Excel (in Excel.dll) Version: 3.1.0.0 (3.1)

Syntax

         
 C#  Visual Basic  Visual C++ 
public class ExcelWorkbook
Public Class ExcelWorkbook
public ref class ExcelWorkbook

Members

               
 All Members  Constructors   Properties   Methods   Events  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
ExcelWorkbook()()()()
Creats new blank ExcelWorkbook (without ExcelWorksheets).

Remarks

To add new ExcelWorksheets use Worksheets property, Add(String) method.
GetCellByName(String)
Returns cell with specified defined name.
GetListNamesOfCells()()()()
Returns array of defined names of cells.
Options
Represent option of ExcelWorkbook.
Progress
Occurs when was wrote some part input file.
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.
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.
Worksheets
Gets the collection of Excel Worksheets (ExcelWorksheet).
WriteCSV()()()()
Created in memory a new .CSV file which contains current Workbook.
WriteCSV(String)
Created a new .CSV file which contains current Workbook.
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.

Inheritance Hierarchy

System..::..Object
  Docs.Excel..::..ExcelWorkbook

See Also