3.8.5 PivotTable: BrtBeginPCDSRange
The BrtBeginPCDSRange (section 2.4.167) record specifies the properties of the range-based source data (section 2.2.5.2.1) for this PivotCache (section 2.2.5.2), as specified in the following table.
|
Size |
Structure |
Value |
|---|---|---|
|
002D |
BrtBeginPCDSRange - BrtBeginPCDSRange |
|
|
1 bit |
BYTE - fName |
0x0 |
|
7 bits |
BYTE - reserved1 |
0x00 |
|
1 bit |
BYTE - fBuiltIn |
0x0 |
|
7 bits |
BYTE - reserved2 |
0x00 |
|
1 bit |
BYTE - fLoadRelId |
0x0 |
|
1 bit |
BYTE - fLoadSheet |
0x1 |
|
6 bits |
BYTE - reserved3 |
0x00 |
|
001A |
XLWideString - sheetName |
Source Data |
|
0010 |
RfX - range |
|
|
0004 |
LONG - rwFirst |
0x00000000 |
|
0004 |
LONG - rwLast |
0x0000002C |
|
0004 |
LONG - colFirst |
0x00000000 |
|
0004 |
LONG - colLast |
0x00000004 |
Structure of BrtBeginPCDSRange
fName: 0x0 specifies that the source data (section 2.2.5.2.1) is not a defined name.
fBuiltIn: 0x0 specifies that the defined name is not a built-in name. This field is ignored, because the source data is not a defined name.
fLoadRelId: 0x0 specifies that the source data is not in an external workbook (section 2.1.10).
fLoadSheet: 0x1 specifies that the source data is scoped to a single sheet.
sheetName: Source Data specifies the name of the sheet to which the source data is scoped.
range: Specifies the source data range.
range.rwFirst: 0x00000000 specifies that the first row of the source data (section 2.2.5.2.1) range is row 1.
range.rwLast: 0x0000002C specifies that the last row of the source data range is row 45.
range.colFirst: 0x00000000 specifies that the first column (1) of the source data range is column (1) A.
range.colLast: 0x00000004 specifies that the last column (1) of the source data range is column (1) E.