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).
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.
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.
PivotViewSourceRecord
This record contains an integer that defines the data source for a PivotTable.
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.
SQLDataTypeIdRecord
This record contains a SQL datatype identifier.
SelectionInfoRecord
This record stores PivotTable selection information.
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.
Enums
DataConsolidationInfoRecord.FunctionTypes
Function types.
LineItem.LineItemType
Item type.
PivotViewItemRecord.ItemTypes
Possible item types.
PivotViewSourceRecord.DataSourceTypes
Possible data sources.
RuleFilterRecord.FunctionType
Represents the Function types.
SQLDataTypeIdRecord.SQLDataType
The SQL datatypes.