ExcelWorksheetInfo Class

Definition

Namespace

Bodu.Formats.Excel

Assembly

Bodu.Formats.Excel.Binary.dll

Package

Bodu.Formats.Excel.Binary 1.0.0

Source

ExcelWorksheetInfo.cs

Describes a sheet within a BIFF workbook: its name, position, visibility, type, and declared used range.

public sealed class ExcelWorksheetInfo

Inheritance

object

ExcelWorksheetInfo

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

ComparableExtensions.AtLeast<T>(T, T, IComparer<T>)

ComparableExtensions.AtMost<T>(T, T, IComparer<T>)

ComparableExtensions.IsEqualTo<T>(T, T, IComparer<T>)

ComparableExtensions.Max<T>(T, T, IComparer<T>)

ComparableExtensions.Min<T>(T, T, IComparer<T>)

Remarks

An instance is produced from the workbook's bound-sheet record and the DIMENSIONS record of the sheet's substream. Sheets of every ExcelSheetType are described; only a Worksheet yields cells when opened.

Properties

Dimensions

Gets the used range of the sheet, as declared by its DIMENSIONS record.

public ExcelWorksheetDimensions Dimensions { get; }

Property Value

ExcelWorksheetDimensions

The half-open span of rows and columns that bounds the populated cells; the default value (zero counts) when the sheet declares no DIMENSIONS record.

Index

Gets the zero-based position of the sheet within the workbook.

public int Index { get; }

Property Value

int

The sheet index in workbook order.

IsVisible

Gets a value indicating whether the sheet is visible.

public bool IsVisible { get; }

Property Value

bool

true when Visibility is Visible; otherwise false.

Name

Gets the sheet name.

public string Name { get; }

Property Value

string

The sheet name as declared in the workbook globals.

Type

Gets the sheet's declared type.

public ExcelSheetType Type { get; }

Property Value

ExcelSheetType

The kind of substream the sheet's bound-sheet record points to.

Visibility

Gets the sheet's declared visibility.

public ExcelSheetVisibility Visibility { get; }

Property Value

ExcelSheetVisibility

The visibility recorded by the sheet's bound-sheet record.

Applies to

Product	Versions
.NET	8, 10