Class ProtoSheet

Namespace

ProtoTest.Sheets

Assembly

ProtoTest.Sheets.dll

One sheet. Reading a cell or range records a sheets.range observation, which is what the coverage collector aggregates: coverage is the ranges the test actually read, not what the file has.

public sealed class ProtoSheet

Inheritance

object

ProtoSheet

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

SheetModelAssertions.ShouldMatchShape<TRow>(TRow, object, JsonSerializerOptions?)

Properties

ColumnCount

Columns in the used range.

public int ColumnCount { get; }

Property Value

int

Index

The sheet's position in the workbook, hidden sheets included.

public int Index { get; }

Property Value

int

IsHidden

public bool IsHidden { get; }

Property Value

bool

Name

public string Name { get; }

Property Value

string

RowCount

Rows in the used range.

public int RowCount { get; }

Property Value

int

Methods

Cell(int, int)

Reads a cell by coordinates; row and column are 1-based.

public ProtoCell Cell(int row, int column)

Parameters

row int

column int

Returns

ProtoCell

Cell(string)

Reads one cell; a reference outside the file is an empty cell, never an error.

public ProtoCell Cell(string reference)

Parameters

reference string

Returns

ProtoCell

Range(string)

Reads a range like A1:C10, row by row.

public ProtoRange Range(string reference)

Parameters

reference string

Returns

ProtoRange

Table(params int[])

Header-aware view of the sheet. Pass one or more header rows; a merged group header spanning columns plus the subheaders under it become one header path per column.

public ProtoTable Table(params int[] headerRows)

Parameters

headerRows int[]

Returns

ProtoTable