Namespace Syncfusion.XlsIO.Parser.Biff_Records.PivotTable

Classes

CacheDataExRecord This record is an extension of the CacheDataRecord. Both records contain PivotTable cache data. Corresponds to SXDBEX in Excel format specification.

CacheDataRecord This record is stored on a separate stream that maintains information about each PivotTable cache. The record is followed by a single CacheDataExRecord and several FDB records, one for each field in the PivotTable. SXDBEX in Excel specification.

DataConsolidationInfoRecord This record stores options from the Consolidate dialog box (Data menu).

DataConsolidationInfoRecord.FunctionTypes Function types.

DataItemRecord Summary description for DataItem.

ExternalSourceInfoRecord This record stores information about the SQL query string that retrieves external data for a PivotTable. The record is followed by SXSTRING records that contain the SQL strings and then by a SXSTRING record that contains the SQL server connection string.

LineItem LineItem class.

LineItem.LineItemType Item type.

LineItemArrayRecord This record stores an array of variable-length SXLI structures, which describe the row and column items in a PivotTable. There are two LineItemArrayRecords for each PivotTable: the first stores row items, and the second stores column items.

PageItemIndexesRecord This record stores an array of page item indexes that represent the table references for a multiple-consolidation PivotTable.

PageItemNameCountRecord This record stores the number of page item names in a multiple-consolidation PivotTable. The names are stored in SXSTRING records that follow this record.

PageItemRecord This record contains information about the PivotTable page item.

PageItemRecord.FieldInfo This class contains information about field

ParsedExpressionRecord This record stores a PivotTable parsed expression.

PivotBooleanRecord Summary description for PivotBooleanRecord.

PivotDateTimeRecord Contains information about date/time value in the pivot table.

PivotDoubleRecord Summary description for PivotDoubleRecord.

PivotEmptyRecord Summary description for PivotEmptyRecord.

PivotErrorRecord Summary description for PivotBooleanRecord.

PivotFieldRecord Summary description for PivotFieldRecord.

PivotFormatRecord This record stores formatting data.

PivotFormulaRecord This record stores a PivotTable formula.

PivotIndexListRecord Summary description for PivotIndexListRecord.

PivotNamePairRecord Summary description for PivotNamePairRecord.

PivotNameRecord This record stores a PivotTable name.

PivotSourceInfoRecord This record stores information about multiple-consolidation PivotTable source data.

PivotStringRecord This record contains an SQL query string, an SQL server connection string or page item name from a multiple-consolidation PivotTable.

PivotViewDefinitionRecord This record contains top-level PivotTable information.

PivotViewFieldsExRecord This record contains extended PivotTable view fields information.

PivotViewFieldsRecord This record contains PivotTable view fields and other information.

PivotViewItemRecord This record contains information about a PivotTable item.

PivotViewItemRecord.ItemTypes Possible item types.

PivotViewSourceRecord This record contains an integer that defines the data source for a PivotTable.

PivotViewSourceRecord.DataSourceTypes Possible data sources.

RowColumnFiledIdRecord This record stores an array of field ID numbers (2-byte integers) for the row fields and column fields in a PivotTable. Two RowColumnFieldIdRecords appear in the file: the first contains the array of row field IDs, and the second contains the array of column field IDs.

RuleDataRecord This record stores PivotTable rule data.

RuleFilterRecord This record stores PivotTable Rule Filter options.

RuleFilterRecord.FunctionType Represents the Function types.

SelectionInfoRecord This record stores PivotTable selection information.

SQLDataTypeIdRecord This record contains a SQL datatype identifier.

SQLDataTypeIdRecord.SQLDataType The SQL datatypes.

StreamIdRecord This record is a header record for a group of SXVS, SXEXT, and SXSTRING records that describe the PivotTable streams in the SX DB storage (the PivotTable cache storage). The StreamId field identifies the stream.

ViewExtendedInfoRecord This record follows the SXVIEW record and contains information about additional features added to PivotTables in Excel.