API Reference

Class

LegacyXlsDataConsolidationReference

Namespace OfficeIMO.Excel.LegacyXls.Model
Assembly OfficeIMO.Excel
Modifiers sealed

Describes a preserve-only DConRef record that points at a consolidation or PivotTable source range.

Inheritance

  • Object
  • LegacyXlsDataConsolidationReference

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Constructors

public LegacyXlsDataConsolidationReference(Int32 recordOffset, UInt16 recordType, Int32 firstRow, Int32 lastRow, Int32 firstColumn, Int32 lastColumn, String cellRange, LegacyXlsDataConsolidationSourceKind sourceKind, String source, Nullable<Byte> sourcePrefix, Int32 unusedByteCount) #

Creates decoded DConRef metadata.

Parameters

recordOffset System.Int32 requiredposition: 0
recordType System.UInt16 requiredposition: 1
firstRow System.Int32 requiredposition: 2
lastRow System.Int32 requiredposition: 3
firstColumn System.Int32 requiredposition: 4
lastColumn System.Int32 requiredposition: 5
cellRange System.String requiredposition: 6
sourceKind OfficeIMO.Excel.LegacyXls.Model.LegacyXlsDataConsolidationSourceKind requiredposition: 7
source System.String requiredposition: 8
sourcePrefix System.Nullable{System.Byte} requiredposition: 9
unusedByteCount System.Int32 requiredposition: 10

Properties

public Int32 RecordOffset { get; } #

Gets the byte offset of the DConRef BIFF record.

public UInt16 RecordType { get; } #

Gets the BIFF record type.

public Int32 FirstRow { get; } #

Gets the first one-based row in the referenced source range.

public Int32 LastRow { get; } #

Gets the last one-based row in the referenced source range.

public Int32 FirstColumn { get; } #

Gets the first one-based column in the referenced source range.

public Int32 LastColumn { get; } #

Gets the last one-based column in the referenced source range.

public String CellRange { get; } #

Gets the referenced source range in A1 notation.

public Int32 RowSpan { get; } #

Gets the number of rows covered by the source range, or zero when the range is invalid.

public Int32 ColumnSpan { get; } #

Gets the number of columns covered by the source range, or zero when the range is invalid.

public LegacyXlsDataConsolidationSourceKind SourceKind { get; } #

Gets the decoded DConFile source kind.

public String Source { get; } #

Gets the workbook path or sheet name after the DConFile prefix.

public Nullable<Byte> SourcePrefix { get; } #

Gets the raw DConFile prefix byte when one was present.

public Int32 UnusedByteCount { get; } #

Gets the count of unused trailing bytes after the DConFile string.