Table of Contents

Struct LoadResult

Namespace
SheetStream
Assembly
SheetStream.dll

The cells a load call wrote, for follow-up formatting such as charts or totals.

public readonly struct LoadResult
Inherited Members

Properties

DataRows

Number of data rows (excluding the header).

public int DataRows { get; }

Property Value

int

FirstColumn

First column written.

public int FirstColumn { get; }

Property Value

int

FirstRow

First row written (the header row when headers are printed).

public int FirstRow { get; }

Property Value

int

Headers

The column header texts in column order (empty when nothing was loaded). Pass them to AddPivotTable(string, string, string, int, int, IReadOnlyList<string>) on a later sheet: the source rows have already been streamed out, so the pivot cannot read them back.

public IReadOnlyList<string> Headers { get; }

Property Value

IReadOnlyList<string>

LastColumn

Last column written.

public int LastColumn { get; }

Property Value

int

LastRow

Last row written.

public int LastRow { get; }

Property Value

int

Range

The loaded block as an A1 range including the header row, e.g. "A2:F62"; the pivot source range.

public string Range { get; }

Property Value

string

Table

The Excel table created over the data when TableName was set, otherwise null.

public ExcelTable? Table { get; }

Property Value

ExcelTable