ExcelXmlWorkbook Class

Yogesh.ExcelXml

A Sandcastle Documented Class Library ExcelXmlWorkbook Class
NamespacesYogesh.ExcelXmlExcelXmlWorkbook
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

Assembly: Yogesh.ExcelXml (Module: Yogesh.ExcelXml) Version: 2.89.501.2158