A Sandcastle Documented Class Library
ExcelXmlWorkbook Class
Namespaces ► Yogesh.ExcelXml ► ExcelXmlWorkbook
This class represents a excel workbook
Declaration Syntax| C# | Visual Basic | Visual C++ |
public class ExcelXmlWorkbook
Public Class ExcelXmlWorkbook
public ref class ExcelXmlWorkbook
Members| All Members | Constructors | Methods | Properties | ||
|
|
|
|
|||
| Icon | Member | Description |
|---|---|---|
|
ExcelXmlWorkbook()()() |
Creates a new instance
|
|
|
Add()()() |
Adds a new sheet at the end of all sheets
|
|
|
Add(String) |
Adds a new sheet at the end of all sheets
|
|
|
AddNamedRange(Range, String) |
Add a named range to the book with a book scope
|
|
DataSetToWorkbook(DataSet) |
Converts a dataset to a work book
|
|
DefaultStyle |
Gets or sets default font options of the sheet
|
|
|
DeleteSheet(Int32) |
Delete a sheet by index
|
|
|
DeleteSheet(String) |
Delete a sheet by name
|
|
|
DeleteSheet(Worksheet) |
Delete a sheet by instance
|
|
|
Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
|
|
Export(String) |
Export the workbook to a file
|
|
|
Export(Stream) |
Export the workbook to a stream
|
|
Finalize()()() | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
|
|
GetHashCode()()() | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
|
|
GetSheetByName(String) |
Gets a Worksheet reference matching a particular name
|
|
|
GetType()()() | Gets the Type of the current instance. (Inherited from Object.) |
|
|
Import(String) |
Imports a excel xml workbook into a ExcelXmlWorkbook instance
|
|
|
Import(Stream) |
Imports a excel xml workbook into a ExcelXmlWorkbook instance
|
|
|
InsertAfter(Int32) |
Insert a new sheet after another sheet
|
|
|
InsertAfter(String) |
Insert a new sheet after another sheet
|
|
|
InsertAfter(Worksheet) |
Insert a new sheet after another sheet
|
|
|
InsertBefore(Int32) |
Insert a new sheet before another sheet
|
|
|
InsertBefore(String) |
Insert a new sheet before another sheet
|
|
|
InsertBefore(Worksheet) |
Insert a new sheet before another sheet
|
|
|
Item[([(Int32])]) |
Returns the sheet at a given position
|
|
|
Item[([(String])]) |
Returns the sheet by sheet name
|
|
|
MemberwiseClone()()() | Creates a shallow copy of the current Object. (Inherited from Object.) |
|
|
Properties |
Gets or sets document properties
|
|
|
SheetCount |
The number of sheets in this boook
|
|
|
ToString()()() | Returns a String that represents the current Object. (Inherited from Object.) |
Inheritance Hierarchy| Object | |
|
ExcelXmlWorkbook |