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. |