Class ExcelExternalWorksheet¶

Namespace: OfficeOpenXml.ExternalReferences
Assembly: EPPlus.dll

A representation of an external cached worksheet.

public class ExcelExternalWorksheet : IExcelExternalNamedItem

Inheritance¶

object ← ExcelExternalWorksheet

Implements¶

IExcelExternalNamedItem

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

CachedNames¶

A collection of cached names for an external worksheet

public ExcelExternalNamedItemCollection<ExcelExternalDefinedName> CachedNames { get; }

Property Value¶

ExcelExternalNamedItemCollection<ExcelExternalDefinedName>

CellValues¶

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

public ExcelExternalCellCollection CellValues { get; }

Property Value¶

ExcelExternalCellCollection

Name¶

The name of the worksheet.

public string Name { get; }

Property Value¶

string

RefreshError¶

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

public bool RefreshError { get; }

Property Value¶

bool

SheetId¶

The sheet id

public int SheetId { get; }

Property Value¶

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

public ExcelAddressBase GetDimension()

Returns¶

ExcelAddressBase

ToString()¶

Returns a string that represents the current object.

public override string ToString()

Returns¶

string

A string that represents the current object.