Struct XlsxSheet

Namespace

ExcelReader.Core.Reader.Xlsx

Assembly

ExcelReader.Core.dll

One sheet of an XlsxWorkbook. A value that holds no resources; each enumerator it creates reads independently.

public readonly record struct XlsxSheet : IExcelSheet, IExcelSheet<IExcelRowEnumerator>, IExcelSheet<XlsxWorkbook.Enumerator>, IEquatable<XlsxSheet>

Implements

IExcelSheet

IExcelSheet<IExcelRowEnumerator>

IExcelSheet<XlsxWorkbook.Enumerator>

IEquatable<XlsxSheet>

Inherited Members

ValueType.Equals(object)

ValueType.GetHashCode()

ValueType.ToString()

object.Equals(object, object)

object.GetType()

object.ReferenceEquals(object, object)

Extension Methods

ArrowConversionExtensions.ToArrowRecordBatch(IExcelSheet, ArrowReadOptions?)

Properties

Index

Gets the sheet's zero-based position in its workbook.

public int Index { get; }

Property Value

int

IsDate1904

Gets a value indicating whether the sheet's workbook uses the 1904 date system.

public bool IsDate1904 { get; }

Property Value

bool

Name

Gets the sheet's name. Empty for the single sheet of a CSV source.

public string Name { get; }

Property Value

string

Visibility

Gets whether the sheet is shown in the workbook's tab bar.

public ExcelSheetVisibility Visibility { get; }

Property Value

ExcelSheetVisibility

Remarks

Reported, never enforced: a hidden sheet enumerates its rows like any other.

Methods

GetAsyncEnumerator(CancellationToken)

Gets a new enumerator that reads the sheet's rows asynchronously from the start.

public XlsxWorkbook.Enumerator GetAsyncEnumerator(CancellationToken ct = default)

Parameters

ct CancellationToken

A token observed by that deferred setup and by every MoveNextAsync() call.

Returns

XlsxWorkbook.Enumerator

Remarks

Setup that needs I/O, such as opening the sheet part or loading shared strings, runs on the first MoveNextAsync(), so this call does not block.

Exceptions

ObjectDisposedException

The sheet's workbook was disposed.

InvalidOperationException

The source is a CSV over a non-seekable stream that was already enumerated.

GetEnumerator()

Gets a new enumerator that reads the sheet's rows synchronously from the start.

public XlsxWorkbook.Enumerator GetEnumerator()

Returns

XlsxWorkbook.Enumerator

Exceptions

ObjectDisposedException

The sheet's workbook was disposed.

InvalidOperationException

The source is a CSV over a non-seekable stream that was already enumerated.