Class ExcelWorkbook

Represents the Excel workbook and provides access to all the document properties and worksheets within the workbook.

Inheritance

System.Object

XmlHelper

ExcelWorkbook

Implements

System.IDisposable

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml

Assembly: Experior.Core.dll

Syntax

public sealed class ExcelWorkbook : XmlHelper, IDisposable

Properties

CalcMode

Calculation mode for the workbook.

Declaration

public ExcelCalcMode CalcMode { get; set; }

Property Value

Type	Description
ExcelCalcMode

CodeModule

Declaration

public ExcelVBAModule CodeModule { get; }

Property Value

Type	Description
ExcelVBAModule

MaxFontWidth

Max font width for the workbook This method uses GDI. If you use Asure or another environment that does not support GDI, you have to set this value manually if you don't use the standard Calibri font

Declaration

public decimal MaxFontWidth { get; set; }

Property Value

Type	Description
System.Decimal

Names

Provides access to named ranges

Declaration

public ExcelNamedRangeCollection Names { get; }

Property Value

Type	Description
ExcelNamedRangeCollection

Properties

The office document properties

Declaration

public OfficeProperties Properties { get; }

Property Value

Type	Description
OfficeProperties

Protection

Access properties to protect or unprotect a workbook

Declaration

public ExcelProtection Protection { get; }

Property Value

Type	Description
ExcelProtection

Styles

Package styles collection. Used internally to access style data.

Declaration

public ExcelStyles Styles { get; }

Property Value

Type	Description
ExcelStyles

StylesXml

Provides access to the XML data representing the styles in the package.

Declaration

public XmlDocument StylesXml { get; set; }

Property Value

Type	Description
System.Xml.XmlDocument

VbaProject

A reference to the VBA project. Null if no project exists. User Workbook.CreateVBAProject to create a new VBA-Project

Declaration

public ExcelVbaProject VbaProject { get; }

Property Value

Type	Description
ExcelVbaProject

View

Access to workbook view properties

Declaration

public ExcelWorkbookView View { get; }

Property Value

Type	Description
ExcelWorkbookView

WorkbookXml

Provides access to the XML data representing the workbook in the package.

Declaration

public XmlDocument WorkbookXml { get; }

Property Value

Type	Description
System.Xml.XmlDocument

Worksheets

Provides access to all the worksheets in the workbook.

Declaration

public ExcelWorksheets Worksheets { get; }

Property Value

Type	Description
ExcelWorksheets

Methods

CreateVBAProject()

Create an empty VBA project.

Declaration

public void CreateVBAProject()

Explicit Interface Implementations

IDisposable.Dispose()

Declaration

void IDisposable.Dispose()

Implements

System.IDisposable