Class ExcelExternalWorksheet

A representation of an external cached worksheet.

Inheritance

object

ExcelExternalWorksheet

Implements

IExcelExternalNamedItem

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Namespace: OfficeOpenXml.ExternalReferences

Assembly: EPPlus.dll

Syntax

public class ExcelExternalWorksheet : IExcelExternalNamedItem

Properties

CachedNames

A collection of cached names for an external worksheet

Declaration

public ExcelExternalNamedItemCollection<ExcelExternalDefinedName> CachedNames { get; }

Property Value

Type	Description
ExcelExternalNamedItemCollection<ExcelExternalDefinedName>

CellValues

Cached cell values for the worksheet. Only cells referenced in the workbook are stored in the cache.

Declaration

public ExcelExternalCellCollection CellValues { get; }

Property Value

Type	Description
ExcelExternalCellCollection

Name

The name of the worksheet.

Declaration

public string Name { get; }

Property Value

Type	Description
string

RefreshError

If errors have occured on the last update of the cached values.

Declaration

public bool RefreshError { get; }

Property Value

Type	Description
bool

SheetId

The sheet id

Declaration

public int SheetId { get; }

Property Value

Type	Description
int

Methods

GetDimension()

Dimension address for the worksheet for cells with a value or a style set. Top left cell to Bottom right. If the worksheet has no cells, null is returned

Declaration

public ExcelAddressBase GetDimension()

Returns

Type	Description
ExcelAddressBase

ToString()

Returns a string that represents the current object.

Declaration

public override string ToString()

Returns

Type	Description
string	A string that represents the current object.

Overrides

object.ToString()

Implements

IExcelExternalNamedItem