------------------------------------------------------------------------ Path: /DataTable Description: Specifies whether a data table is displayed on the plot area next to the category axis. ------------------------------------------------------------------------ Path: /DataTable///Range Element: Type: string Description: Contains the range or list of ranges that applies to a conditional text format, a data validation range, or a data source. ------------------------------------------------------------------------ Path: /DataTable///RowInputCell Element: Type: string Description: Contains the row index of a cell used to calculate the values in a data table. ------------------------------------------------------------------------ Path: /DataTable///ColumnInputCell Element: Type: string Description: Contains the column index of a cell used to calculate the values in a data table. ------------------------------------------------------------------------ Path: /ExcelWorkbook Description: Contains the properties of a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///PublishObjects Element: Type: PublishObjectsType Description: Contains information about all published items in a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///SupBook Element: Type: SupBookType Description: Contains information about references and links to other workbooks and data sources. ------------------------------------------------------------------------ Path: /ExcelWorkbook///SelectedSheets Element: Type: int Element: Default: 1 Description: Specifies the number of sheets selected in a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowHidden Description: Specifies whether a workbook window is hidden. ------------------------------------------------------------------------ Path: /ExcelWorkbook///HideHorizontalScrollBar Description: Specifies whether the horizontal scroll bar in a workbook window is hidden. ------------------------------------------------------------------------ Path: /ExcelWorkbook///HideVerticalScrollBar Description: Specifies whether the vertical scroll bar in a workbook window is hidden. ------------------------------------------------------------------------ Path: /ExcelWorkbook///HideWorkbookTabs Description: Specifies whether the worksheet tabs in a workbook window are hidden. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowHeight Element: Type: long Description: Contains a value specifying the height in points of a workbook window. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowWidth Element: Type: long Description: Contains a value in points that specifies the width of a workbook window. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowTopX Element: Type: long Description: Contains a value in points that specifies the horizontal position of a workbook window relative to the left border of the application window. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowTopY Element: Type: long Description: Contains a value in points that specifies the vertical position of a workbook window relative to the top border of the application window. ------------------------------------------------------------------------ Path: /ExcelWorkbook///ActiveSheet Element: Type: int Element: Default: 1 Description: Contains the index number of the active worksheet in a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///ActiveChart Element: Type: string Description: Contains the name of the active chart in a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///FirstVisibleSheet Element: Type: int Element: Default: 1 Description: Specifies that all worksheets before to the worksheet identified in this element are hidden and that no navigation tabs are shown for hidden sheets. ------------------------------------------------------------------------ Path: /ExcelWorkbook///HidePivotTableFieldList Description: Prevents the PivotTable Field List dialog box from appearing when the user moves the input focus to the PivotTable view. ------------------------------------------------------------------------ Path: /ExcelWorkbook///ProtectStructure Element: Type: TrueFalseType Description: Specifies whether the structure of a workbook is protected. ------------------------------------------------------------------------ Path: /ExcelWorkbook///ProtectWindows Element: Type: TrueFalseType Description: Specifies whether the worksheet windows are protected. ------------------------------------------------------------------------ Path: /ExcelWorkbook///DisplayInkNotes Element: Type: TrueFalseType Description: Specifies whether ink comments are displayed. ------------------------------------------------------------------------ Path: /ExcelWorkbook///EmbedSaveSmartTags Description: Causes smart tags in the document to be saved to the XML spreadsheet. ------------------------------------------------------------------------ Path: /ExcelWorkbook///FutureVer Element: Type: string Description: Enables Excel 2002 to warn users that they may lose data on save back to XMLSS, when the XMLSS loaded was created with Excel 2003. This element will only be written into the XMLSS if were writing out the MapInfo collection (new feature in Excel 2003). ------------------------------------------------------------------------ Path: /ExcelWorkbook///TabRatio Element: Type: int Element: Default: 600 Description: Specifies the ratio of the worksheet tab area width to the width of the horizontal scroll bar. ------------------------------------------------------------------------ Path: /ExcelWorkbook///WindowIconic Description: Specifies whether a workbook window is minimized. ------------------------------------------------------------------------ Path: /ExcelWorkbook///DisplayDrawingObjects Element: Default: DisplayShapes Description: Specifies whether drawing objects are displayed, placeholders are displayed in their place, or all drawing objects are hidden in a workbook. Restriction: Base: string Enumeration: Value: DisplayShapes Enumeration: Value: PlaceHolders Enumeration: Value: HideAll ------------------------------------------------------------------------ Path: /ExcelWorkbook///CreateBackup Description: Specifies whether a backup file is created when you save a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///Calculation Element: Type: CalculationWorkbookType Element: Default: AutomaticCalculation Description: Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///DoNotCalculateBeforeSave Description: Specifies whether a workbook is calculated before it is saved. ------------------------------------------------------------------------ Path: /ExcelWorkbook///Date1904 Description: Specifies the date system used in a workbook. ------------------------------------------------------------------------ Path: /ExcelWorkbook///RefModeR1C1 Description: Specifies that references are in R1C1 reference style. ------------------------------------------------------------------------ Path: /ExcelWorkbook///Iteration Description: Specifies whether to track the number of iterations through circular references in formulas. ------------------------------------------------------------------------ Path: /ExcelWorkbook///MaxIterations Description: Specifies the maximum number of iterations when resolving circular references in Excel. ------------------------------------------------------------------------ Path: /ExcelWorkbook///MaxChange Element: Type: double Element: Default: 0.001 Description: Specifies the maximum amount of change for a value between each iteration when Excel resolves circular references in formulas. ------------------------------------------------------------------------ Path: /ExcelWorkbook///PrecisionAsDisplayed Description: Specifies whether calculations are performed using the precision of numbers as they are displayed. ------------------------------------------------------------------------ Path: /ExcelWorkbook///DoNotSaveLinkValues Description: Specifies whether the values in linked cells are saved. ------------------------------------------------------------------------ Path: /ExcelWorkbook///NoAutoRecover Description: Suppresses autorecovery of documents if Excel fails. ------------------------------------------------------------------------ Path: /ExcelWorkbook///AcceptLabelsInFormulas Description: Specifies whether range names are allowed in formulas. ------------------------------------------------------------------------ Path: /ExcelWorkbook///Uncalced Description: Specifies whether a workbook has already been calculated. ------------------------------------------------------------------------ Path: /Name Element: Type: string Description: Specifies the name of the spreadsheet ------------------------------------------------------------------------ Path: /DataValidation Element: Type: DataValidationType Description: Contains the data validation criteria, an input message, and elements related to error messages for a specified range. ------------------------------------------------------------------------ Path: /AutoFilter Description: Contains information about autofilters. Element: Ref: AutoFilterColumn ------------------------------------------------------------------------ Path: /AutoFilter//Range Attribute: Type: string Attribute: Use: required Description: Specifies the range to which the autofilter applies. ------------------------------------------------------------------------ Path: /AutoFilterColumnType Description: Contains the autofilter criteria for a column in an autofilter range. ------------------------------------------------------------------------ Path: /AutoFilterColumnType//AutoFilterCondition Element: Type: AutoFilterConditionType Description: Contains information about the test applied in an autofilter. ------------------------------------------------------------------------ Path: /AutoFilterColumnType//AutoFilterOr Description: Contains an autofilter condition that can be combined with other conditions using the OR operator. ------------------------------------------------------------------------ Path: /AutoFilterColumnType//AutoFilterOr///AutoFilterCondition Element: Type: AutoFilterConditionType Description: Specifies the criteria for the autofilter. ------------------------------------------------------------------------ Path: /AutoFilterColumnType//AutoFilterAnd Description: Contains an autofilter condition that can be combined with other conditions using the AND operator. ------------------------------------------------------------------------ Path: /AutoFilterColumnType//AutoFilterAnd///AutoFilterCondition Element: Type: AutoFilterConditionType Description: Specifies the criteria for the autofilter. ------------------------------------------------------------------------ Path: /AutoFilterColumnType/Index Attribute: Type: integer Attribute: Use: optional Description: Specifies the column in the autofilter range to which the current autofilter applies. ------------------------------------------------------------------------ Path: /AutoFilterColumnType/Type Attribute: Use: required Description: Specifies the type of autofilter to apply to the column. Restriction: Base: string Enumeration: Value: Top Enumeration: Value: Bottom Enumeration: Value: TopPercent Enumeration: Value: BottomPercent Enumeration: Value: Custom ------------------------------------------------------------------------ Path: /AutoFilterColumnType/Value Attribute: Type: integer Attribute: Use: optional Description: Contains a value for the autofilter condition specified in the Type attribute. ------------------------------------------------------------------------ Path: /AutoFilterConditionType Description: Contains information about the test applied in an autofilter. ------------------------------------------------------------------------ Path: /AutoFilterConditionType/Operator Attribute: Use: required Description: Defines the test to apply in conjunction with the Value attribute. Restriction: Base: string Enumeration: Value: Equals Enumeration: Value: DoesNotEqual Enumeration: Value: GreaterThan Enumeration: Value: GreaterThanOrEqual Enumeration: Value: LessThan Enumeration: Value: LessThanOrEqual ------------------------------------------------------------------------ Path: /AutoFilterConditionType/Value Attribute: Type: string Attribute: Use: required Description: Defines the test to apply in conjunction with the Operator attribute. ------------------------------------------------------------------------ Path: /Sorting Element: Type: SortingType Description: Contains the sorting specifications and sort options used in the most recent sort. ------------------------------------------------------------------------ Path: /ConditionalFormatting Element: Type: ConditionalFormattingType Description: Contains information about conditional formatting. ------------------------------------------------------------------------ Path: /QueryTable Element: Type: QueryTableType Description: Contains information about a section of the spreadsheet that holds the results of a query. ------------------------------------------------------------------------ Path: /PivotTable Element: Type: PivotTableType Description: Contains information about a PivotTable view. ------------------------------------------------------------------------ Path: /WorksheetSource Description: Contains a hyperlink to the data source of a worksheet. ------------------------------------------------------------------------ Path: /WorksheetSource//Href Attribute: Type: string Attribute: Use: required Description: Specifies the path and file name of the data source. ------------------------------------------------------------------------ Path: /WorksheetOptions Element: Type: WorksheetOptionsType Description: Contains information about options related to the worksheet. ------------------------------------------------------------------------ Path: /Watches Description: Specifies the list of cells to be displayed in Watch window. ------------------------------------------------------------------------ Path: /Watches///Watch Description: Specifies a reference to a cell to be displayed in the Watch window. ------------------------------------------------------------------------ Path: /Watches///Watch///Source Element: Type: string Description: Specifies a reference to a cell to be displayed in the Watch window. ------------------------------------------------------------------------ Path: /PageBreaks Element: Type: PageBreaksType Description: Contains information about page breaks in a spreadsheet. ------------------------------------------------------------------------ Path: /PageBreaksType Description: Contains information about page breaks in a spreadsheet. ------------------------------------------------------------------------ Path: /PageBreaksType//ColBreaks Description: Specifies the list of columns where page breaks occur. ------------------------------------------------------------------------ Path: /PageBreaksType//ColBreaks///ColBreak Description: Contains a single column where a page break occurs. ------------------------------------------------------------------------ Path: /PageBreaksType//ColBreaks///ColBreak///Column Element: Type: int Description: Specifies the index to a column where a page break occurs. ------------------------------------------------------------------------ Path: /PageBreaksType//RowBreaks Description: Specifies the list of rows where page breaks occur. ------------------------------------------------------------------------ Path: /PageBreaksType//RowBreaks///RowBreak Description: Specifies a single row where a page break occurs ------------------------------------------------------------------------ Path: /PageBreaksType//RowBreaks///RowBreak///Row Element: Type: RowType Description: Contains information about the row where a page break occurs. ------------------------------------------------------------------------ Path: /CrnType Description: Contains a description of formula operands located in another workbook. ------------------------------------------------------------------------ Path: /CrnType//Row Element: Type: RowType Description: Specifies the row being referenced. ------------------------------------------------------------------------ Path: /CrnType//ColFirst Element: Type: int Description: Specifies the column in the referenced row that the referenced area begins with. ------------------------------------------------------------------------ Path: /CrnType//ColLast Element: Type: int Description: Specifies the column in the referenced row that the referenced area ends with. ------------------------------------------------------------------------ Path: /CrnType//Number Element: Type: double Description: Contains the data in the referenced cell if the data is numeric. ------------------------------------------------------------------------ Path: /CrnType//Text Element: Type: string Description: Contains the data in the referenced cell if the data is text. ------------------------------------------------------------------------ Path: /CrnType//Boolean Element: Default: False Description: Contains a Boolean operand. Restriction: Base: TrueFalseType ------------------------------------------------------------------------ Path: /CrnType//Error Element: Type: ErrorType Description: Contains the data in the referenced cell if the data is an Error data type. ------------------------------------------------------------------------ Path: /ErrorType Description: Contains an enumeration of Excel error values. Restriction: Base: string Enumeration: Value: #DIV/0! Enumeration: Value: #NAME? Enumeration: Value: #NULL! Enumeration: Value: #NUM! Enumeration: Value: #N/A Enumeration: Value: #REF! Enumeration: Value: #VALUE! ------------------------------------------------------------------------ Path: /AlignmentType Description: Specifies a PivotList specific complex type. ------------------------------------------------------------------------ Path: /AlignmentType//Horizontal Description: Specifies the type of horizontal alignment. Restriction: Base: string Enumeration: Value: Automatic Enumeration: Value: Center Enumeration: Value: Distributed Enumeration: Value: Justify Enumeration: Value: Left Enumeration: Value: Right. ------------------------------------------------------------------------ Path: /AlignmentType//Rotation Element: Type: int Description: Specifies that the content is rotated. ------------------------------------------------------------------------ Path: /AlignmentType//Vertical Description: Specifies the type of vertical alignment. Restriction: Base: string Enumeration: Value: Automatic Enumeration: Value: Bottom Enumeration: Value: Center Enumeration: Value: Distributed Enumeration: Value: Justify Enumeration: Value: Top ------------------------------------------------------------------------ Path: /AlignmentType//ReadingOrder Description: Specifies the direction of text. Restriction: Base: string Enumeration: Value: Context Enumeration: Value: LeftToRight Enumeration: Value: RightToLeft ------------------------------------------------------------------------ Path: /AutoFormatNameType Description: Contains an enumeration of the PivotTable view autoformat names. Restriction: Base: string Enumeration: Value: 3DEffects1 Enumeration: Value: 3DEffects2 Enumeration: Value: Accounting1 Enumeration: Value: Accounting2 Enumeration: Value: Accounting3 Enumeration: Value: Accounting4 Enumeration: Value: Classic1 Enumeration: Value: Classic2 Enumeration: Value: Classic3 Enumeration: Value: Colorful1 Enumeration: Value: Colorful2 Enumeration: Value: Colorful3 Enumeration: Value: Japan1 Enumeration: Value: Japan2 Enumeration: Value: Japan3 Enumeration: Value: Japan4 Enumeration: Value: List1 Enumeration: Value: List2 Enumeration: Value: List3 Enumeration: Value: None Enumeration: Value: PivotTableClassic Enumeration: Value: PivotTableNone Enumeration: Value: Report1 Enumeration: Value: Report2 Enumeration: Value: Report3 Enumeration: Value: Report4 Enumeration: Value: Report5 Enumeration: Value: Report6 Enumeration: Value: Report7 Enumeration: Value: Report8 Enumeration: Value: Report9 Enumeration: Value: Report10 Enumeration: Value: Simple Enumeration: Value: Table1 Enumeration: Value: Table2 Enumeration: Value: Table3 Enumeration: Value: Table4 Enumeration: Value: Table5 Enumeration: Value: Table6 Enumeration: Value: Table7 Enumeration: Value: Table8 Enumeration: Value: Table9 Enumeration: Value: Table10 ------------------------------------------------------------------------ Path: /CalculationPivotFieldType Description: Contains an enumeration indicating the type of calculation being done for the PivotField which is in the data area of the PivotTable report. Restriction: Base: string Enumeration: Value: DifferenceFrom Enumeration: Value: Index Enumeration: Value: Normal Enumeration: Value: PercentDifferenceFrom Enumeration: Value: PercentOf Enumeration: Value: PercentOfColumn Enumeration: Value: PercentOfRow Enumeration: Value: PercentOfTotal Enumeration: Value: RunningTotalIn ------------------------------------------------------------------------ Path: /CalculationWorkbookType Description: Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook. Restriction: Base: string Enumeration: Value: AutomaticCalculation Enumeration: Value: ManualCalculation Enumeration: Value: SemiAutomaticCalculation ------------------------------------------------------------------------ Path: /ColumnType Description: Specifies the index of a row page break in a worksheet, or for a PivotList component, represents a column of cells. ------------------------------------------------------------------------ Path: /ColumnType//Path Element: Type: string Description: Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. ------------------------------------------------------------------------ Path: /ColumnType//Left Element: Type: int Description: Specifies the horizontal position of an object within the chart area or Chart component, or for a PivotList component, the column index of the first visible detail column, or the index of the member visible at the left of a view. ------------------------------------------------------------------------ Path: /ColumnType//Cell Description: Contains the properties of a cell in the PivotList component. ------------------------------------------------------------------------ Path: /ColumnType//Cell///Path Element: Type: string Description: Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. ------------------------------------------------------------------------ Path: /ColumnType//Cell///Top Element: Type: double Description: Specifies the vertical position of an object within a chart area or Chart component, or for a PivotList component, the row index visible at the top of a cell or view. ------------------------------------------------------------------------ Path: /ColumnType//Cell///NotInverted Description: Specifies whether a cell's expanded state is the same as its default state. ------------------------------------------------------------------------ Path: /ColumnInfoType Description: Contains information about a column. ------------------------------------------------------------------------ Path: /ColumnInfoType//Id Element: Type: long Description: Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range. ------------------------------------------------------------------------ Path: /ColumnInfoType//Clipped Description: Specifies whether there are enough columns to import all fields and columns returned by a query. ------------------------------------------------------------------------ Path: /ColumnInfoType//Descending Description: Specifies the direction of the sort. ------------------------------------------------------------------------ Path: /ColumnInfoType//FillDown Description: Specifies whether formulas to the right of a query table that use values in this column are copied when the data is refreshed and new rows of data are added to a query table. ------------------------------------------------------------------------ Path: /ColumnInfoType//Name Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /ColumnInfoType//Name///Href Attribute: Type: string Attribute: Use: optional Description: Specifies the location and name of a text file. ------------------------------------------------------------------------ Path: /ColumnInfoType//RowNumbers Description: Specifies whether row numbers are included in a database query. ------------------------------------------------------------------------ Path: /ColumnInfoType//SortKey Description: Specifies the sort order of a column. Restriction: Base: int ------------------------------------------------------------------------ Path: /ColumnInfoType//User Description: Specifies whether the column was inserted by the user. ------------------------------------------------------------------------ Path: /ConditionalFormattingType Description: Contains the conditions and the formatting elements that are applied to the specified range when the conditions are true. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Range Element: Type: string Description: Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition Description: Contains a condition and the formatting that is applied to a cell when the condition is true. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition///Qualifier Description: Contains the qualifier of a condition in conditional text formatting and data validation. Restriction: Base: string Enumeration: Value: Between Enumeration: Value: NotBetween Enumeration: Value: Equal Enumeration: Value: NotEqual Enumeration: Value: Greater Enumeration: Value: Less Enumeration: Value: GreaterOrEqual Enumeration: Value: LessOrEqual ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition///Value1 Element: Type: string Description: Contains a text string specifying the value or formula used in conditional text formatting. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition///Value2 Element: Type: string Description: Contains a text string specifying the value or formula used in the second part of conditional text formatting. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition///Format Description: Specifies the text formatting that is applied to a cell when the condition is true. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition///Format//Style Attribute: Type: string Attribute: Use: required Description: A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. ------------------------------------------------------------------------ Path: /ConditionalFormattingType//Condition//Style Attribute: Type: string Attribute: Use: optional Description: A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. ------------------------------------------------------------------------ Path: /ConsolidationReferenceType Description: Contains the properties of a range data source. ------------------------------------------------------------------------ Path: /ConsolidationReferenceType//FileName Element: Type: string Description: Contains the name of the file that contains the source range of a PivotTable report. ------------------------------------------------------------------------ Path: /ConsolidationReferenceType//Name Element: Type: string Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /ConsolidationReferenceType//Reference Element: Type: string Description: Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element. ------------------------------------------------------------------------ Path: /DataValidationType Description: Contains the data validation criteria, input message, and error message elements of the specified range. ------------------------------------------------------------------------ Path: /DataValidationType//Range Element: Type: string Description: Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source. ------------------------------------------------------------------------ Path: /DataValidationType//Type Element: Default: AnyValue Description: Specifies the type of axis scaling, chart, data source, 3-D shape, or trendline, the data validation constraints on data entered into a range, or the position of legend entries. Restriction: Base: string Enumeration: Value: Custom Enumeration: Value: Date Enumeration: Value: Decimal Enumeration: Value: List Enumeration: Value: TextLength Enumeration: Value: Time Enumeration: Value: Whole Enumeration: Value: AnyValue ------------------------------------------------------------------------ Path: /DataValidationType//CellRangeList Description: Specifies whether a list of values is used for data validation. ------------------------------------------------------------------------ Path: /DataValidationType//Qualifier Description: Contains the qualifier of a condition in conditional text formatting and data validation. Restriction: Base: string Enumeration: Value: Between Enumeration: Value: NotBetween Enumeration: Value: Equal Enumeration: Value: NotEqual Enumeration: Value: Greater Enumeration: Value: Less Enumeration: Value: GreaterOrEqual Enumeration: Value: LessOrEqual ------------------------------------------------------------------------ Path: /DataValidationType//UseBlank Description: Specifies whether blank cells in a range are used when validating input data. ------------------------------------------------------------------------ Path: /DataValidationType///Min Element: Type: string Description: Specifies the minimum value to be used for tests that use the BETWEEN operator. ------------------------------------------------------------------------ Path: /DataValidationType///Max Element: Type: string Description: Specifies the maximum value to be used for tests that use the BETWEEN operator. ------------------------------------------------------------------------ Path: /DataValidationType///Value Element: Type: string Description: Specifies the value to be tested. ------------------------------------------------------------------------ Path: /DataValidationType///ComboHide Description: Suppresses the list of acceptable values. ------------------------------------------------------------------------ Path: /DataValidationType//IMEMode Description: Specifies the status of the Input Method Editor (IME). Restriction: Base: string Enumeration: Value: 0 Enumeration: Value: 1 Enumeration: Value: 2 Enumeration: Value: 3 Enumeration: Value: 4 Enumeration: Value: 5 Enumeration: Value: 6 Enumeration: Value: 7 Enumeration: Value: 8 Enumeration: Value: 9 Enumeration: Value: 10 ------------------------------------------------------------------------ Path: /DataValidationType//InputHide Description: Specifies whether an input dialog box is displayed during data validation. ------------------------------------------------------------------------ Path: /DataValidationType//InputTitle Element: Type: string Description: Contains the title of an input dialog box displayed during data validation. ------------------------------------------------------------------------ Path: /DataValidationType//InputMessage Element: Type: string Description: Contains the input message displayed during data validation. ------------------------------------------------------------------------ Path: /DataValidationType//ErrorHide Description: Specifies whether error messages are displayed during data validation. ------------------------------------------------------------------------ Path: /DataValidationType//ErrorStyle Description: Contains the style of a data validation error message. Restriction: Base: string Enumeration: Value: Info Enumeration: Value: Stop Enumeration: Value: Warn ------------------------------------------------------------------------ Path: /DataValidationType//ErrorMessage Element: Type: string Description: Contains the data validation error message that is displayed when invalid data is entered. ------------------------------------------------------------------------ Path: /DataValidationType//ErrorTitle Element: Type: string Description: Contains the title of an error dialog box displayed during data validation. ------------------------------------------------------------------------ Path: /ExternNameType Description: Contains information about a DDE or OLE link, or a referenced name that is defined in another workbook. ------------------------------------------------------------------------ Path: /ExternNameType//Name Element: Type: string Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /ExternNameType//Formula Element: Type: string Description: Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item. ------------------------------------------------------------------------ Path: /ExternNameType//OleLink Description: Specifies whether the ExternName element describes an OLE link. ------------------------------------------------------------------------ Path: /ExternNameType//WantAdvise Description: Specifies whether the ExternName element contains a description of a DDE or OLE link, and specifies the type of link. ------------------------------------------------------------------------ Path: /ExternNameType//WantPict Description: Specifies whether data is in clipboard format. ------------------------------------------------------------------------ Path: /ExternNameType//Cf Element: Type: int Description: Contains an index to the clipboard data format. ------------------------------------------------------------------------ Path: /FormatSettingsType Description: Contains the cell data type format settings for the columns of imported text. ------------------------------------------------------------------------ Path: /FormatSettingsType//FieldType Element: Default: AutoFormat Description: Specifies the cell data type formatting for a column. Restriction: Base: string Enumeration: Value: AutoFormat Enumeration: Value: Text Enumeration: Value: MDY Enumeration: Value: DMY Enumeration: Value: YMD Enumeration: Value: MYD Enumeration: Value: DYM Enumeration: Value: YDM Enumeration: Value: Skip ------------------------------------------------------------------------ Path: /FormatSettingsType//FieldStart Element: Type: int Description: Contains the starting column number of a field used when importing text. ------------------------------------------------------------------------ Path: /HTMLTablesType Description: Specifies the HTML tables on a Web page that are imported into a query table. ------------------------------------------------------------------------ Path: /HTMLTablesType//Number Element: Type: integer Description: Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. ------------------------------------------------------------------------ Path: /HTMLTablesType//Text Element: Type: string Description: Contains a string operand or the name of an HTML table in a Web page. ------------------------------------------------------------------------ Path: /HTMLTablesType//Missing Element: Type: string Description: Indicates that no information is specified. ------------------------------------------------------------------------ Path: /LeafColumnMemberType Description: Contains the properties of a leaf column member that has been expanded or collapsed since the view's state changed. ------------------------------------------------------------------------ Path: /LeafColumnMemberType//Path Element: Type: string Description: Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. ------------------------------------------------------------------------ Path: /LeafColumnMemberType//SeqNum Element: Type: int Description: Contains the index of the last expand or collapse operation performed on a member. ------------------------------------------------------------------------ Path: /LeafColumnMemberType//Expanded Description: Specifies whether the field members are expanded by default, or whether a leaf member was expanded. ------------------------------------------------------------------------ Path: /LeafRowMemberType Description: Contains the properties of a leaf row member that has been expanded or collapsed since the view's state changed. ------------------------------------------------------------------------ Path: /LeafRowMemberType//Path Element: Type: string Description: Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. ------------------------------------------------------------------------ Path: /LeafRowMemberType//SeqNum Element: Type: int Description: Contains the index of the last expand or collapse operation performed on a member. ------------------------------------------------------------------------ Path: /LeafRowMemberType//Expanded Description: Specifies whether the field members are expanded by default, or whether a leaf member was expanded. ------------------------------------------------------------------------ Path: /MoperType Description: Contains the data referenced by a DDE link. ------------------------------------------------------------------------ Path: /MoperType//RowLast Element: Type: integer Description: Specifies the index of the last row of data being represented. ------------------------------------------------------------------------ Path: /MoperType//ColLast Element: Type: int Description: Specifies the index of the last column of a row of data being represented. ------------------------------------------------------------------------ Path: /MoperType//Number Element: Type: integer Description: Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. ------------------------------------------------------------------------ Path: /MoperType//Text Element: Type: string Description: Contains a string operand or the name of an HTML table in a Web page. ------------------------------------------------------------------------ Path: /MoperType//Boolean Element: Default: False Description: Contains a Boolean operand. Restriction: Base: TrueFalseType ------------------------------------------------------------------------ Path: /MoperType//Error Element: Type: ErrorType Description: Contains an error string. ------------------------------------------------------------------------ Path: /PanesType Description: Contains the Pane elements corresponding to the panes of a worksheet window. ------------------------------------------------------------------------ Path: /PanesType//Pane Element: Type: PaneType Description: Contains the properties of a pane in a worksheet window, or specifies a pane containing the structured selection of a PivotTable report. ------------------------------------------------------------------------ Path: /PaneType Description: Contains the properties of a pane in a worksheet window, or specifies a pane containing the structured selection of a PivotTable report. ------------------------------------------------------------------------ Path: /PaneType//Number Description: Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. Restriction: Base: int ------------------------------------------------------------------------ Path: /PaneType//ActiveRow Element: Type: int Element: Default: 1 Description: Contains the index number of a pane's active row in a worksheet window. ------------------------------------------------------------------------ Path: /PaneType//ActiveCol Element: Type: int Element: Default: 1 Description: Contains the index number of a pane's active column in a worksheet window. ------------------------------------------------------------------------ Path: /PaneType//RangeSelection Element: Type: string Description: Contains the selected range of a pane in a worksheet window. ------------------------------------------------------------------------ Path: /PaneType//Selection Element: Type: SelectionType Description: Contains the properties of structured selections in a PivotTable report. ------------------------------------------------------------------------ Path: /ParameterTypeE Description: Contains information about a query parameter. ------------------------------------------------------------------------ Path: /ParameterTypeE//ExcelType Element: Default: Text Description: Specifies the data type of a query parameter. Restriction: Base: string Enumeration: Value: Boolean Enumeration: Value: Float Enumeration: Value: Integer Enumeration: Value: Text ------------------------------------------------------------------------ Path: /ParameterTypeE//Formula Element: Type: string Description: Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item. ------------------------------------------------------------------------ Path: /ParameterTypeE//Name Element: Type: string Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /ParameterTypeE//ParameterType Element: Default: Prompt Description: Specifies a parameter type. Restriction: Base: string Enumeration: Value: Prompt Enumeration: Value: Value Enumeration: Value: Formula ------------------------------------------------------------------------ Path: /ParameterTypeE//ParameterValue Element: Type: string Description: Specifies the value of a query parameter. ------------------------------------------------------------------------ Path: /ParameterTypeE//PromptString Element: Type: string Description: Contains the message displayed when the user is prompted for a query parameter. ------------------------------------------------------------------------ Path: /ParameterTypeE//NonDefaultName Description: Specifies whether a query parameter has a user-defined name. ------------------------------------------------------------------------ Path: /ParameterTypeE//SQLType Element: Type: SQLTypeType Element: Default: Character Description: Specifies the SQL data type of a query parameter or PivotTable field. ------------------------------------------------------------------------ Path: /ParameterTypeE//RefreshOnChange Description: Specifies whether the data from an external data source is refreshed when a cell used to calculate a parameter formula is changed. ------------------------------------------------------------------------ Path: /PivotAxisType Description: Specifies additional information about a PivotTable view axis or location. ------------------------------------------------------------------------ Path: /PivotAxisType//DisplayEmptyMembers Description: Specifies a Boolean value indicating whether empty items should be displayed in the PivotTable view. ------------------------------------------------------------------------ Path: /PivotAxisType//Label Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotAxisType//Label///Caption Element: Type: string Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotAxisType//Label///NotVisible Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotAxisType//Label//Style Attribute: Type: string Attribute: Use: required Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotAxisType//Orientation Description: Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. Description: Contains an enumerated value indicating where a field is located in a PivotTable area. Restriction: Base: string Enumeration: Value: Hidden Enumeration: Value: Row Enumeration: Value: Column Enumeration: Value: Filter Enumeration: Value: Data ------------------------------------------------------------------------ Path: /PivotCache Description: Contains information about the data held in a spreadsheet to support a PivotTable view. ------------------------------------------------------------------------ Path: /PivotCache///CacheIndex Element: Type: int Element: Default: 1 Description: Specifies the index of PivotCache. Element: Ref: s:Schema Element: Ref: rs:data ------------------------------------------------------------------------ Path: /PTPivotData Description: Contains a description of the state of PivotTable data, including whether members are expanded and the position of a view. ------------------------------------------------------------------------ Path: /PTPivotData///Top Element: Type: int Description: Specifies the vertical position of an object within a chart area or Chart component, or for a PivotList component, the row index visible at the top of a cell or view. ------------------------------------------------------------------------ Path: /PTPivotData///Left Element: Type: int Description: Specifies the horizontal position of an object within the chart area or Chart component, or for a PivotList component, the column index of the first visible detail column, or the index of the member visible at the left of a view. ------------------------------------------------------------------------ Path: /PTPivotData///InvertedRowMember Element: Type: string Description: Specifies whether a row member has a different expanded state than its default state. ------------------------------------------------------------------------ Path: /PTPivotData///InvertedColumnMember Element: Type: string Description: Specifies whether a column member has a different expanded state than its default state. ------------------------------------------------------------------------ Path: /PTPivotData///LeafRowMember Element: Type: LeafRowMemberType Description: Contains the properties of a leaf row member that has been expanded or collapsed since the view's state changed. ------------------------------------------------------------------------ Path: /PTPivotData///LeafColumnMember Element: Type: LeafColumnMemberType Description: Contains the properties of a leaf column member that has been expanded or collapsed since the view's state changed. ------------------------------------------------------------------------ Path: /PTPivotData///Column Element: Type: ColumnType Description: Specifies the index of a row page break in a worksheet, or for a PivotList component, represents a column of cells. ------------------------------------------------------------------------ Path: /MapChildItemsType Description: Contains information about child field items. ------------------------------------------------------------------------ Path: /MapChildItemsType//Item Element: Type: string Description: Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element. ------------------------------------------------------------------------ Path: /AutoShowRangeType Description: Specifies the order in which a range is displayed when a filter is applied to a PivotTable field. Restriction: Base: string Enumeration: Value: Top Enumeration: Value: Bottom ------------------------------------------------------------------------ Path: /AutoShowTypeType Description: Specifies whether a filter is automatically applied to a PivotTable field. Restriction: Base: string Enumeration: Value: Auto Enumeration: Value: Manual ------------------------------------------------------------------------ Path: /AutoSortOrderType Description: Specifies the sort order of a PivotTable field. Restriction: Base: string Enumeration: Value: Ascending Enumeration: Value: Descending Enumeration: Value: Manual ------------------------------------------------------------------------ Path: /FunctionType Description: Contains the function used to summarize a data field or total. Restriction: Base: string Enumeration: Value: Avg Enumeration: Value: Count Enumeration: Value: CountNums Enumeration: Value: Max Enumeration: Value: Min Enumeration: Value: Product Enumeration: Value: StdDev Enumeration: Value: StdDevP Enumeration: Value: Sum Enumeration: Value: Var Enumeration: Value: VarP ------------------------------------------------------------------------ Path: /GroupTypeType Description: Specifies how groups are ordered in a PivotTable field. Restriction: Base: string Enumeration: Value: Range Enumeration: Value: Seconds Enumeration: Value: Minutes Enumeration: Value: Hours Enumeration: Value: Days Enumeration: Value: Months Enumeration: Value: Quarters Enumeration: Value: Years ------------------------------------------------------------------------ Path: /OrientationType Description: Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. For an axis scale, specifies whether the direction of the axis is from minimum to maximum or maximum to minimum. For an error bar, specifies whether the error bar is horizontal or vertical. Restriction: Base: string Enumeration: Value: Column Enumeration: Value: Data Enumeration: Value: Hidden Enumeration: Value: Page Enumeration: Value: Row ------------------------------------------------------------------------ Path: /SubtotalType Description: Specifies the type of subtotal to display for a field. Restriction: Base: string Enumeration: Value: Sum Enumeration: Value: None Enumeration: Value: Default Enumeration: Value: Avg Enumeration: Value: Count Enumeration: Value: CountNums Enumeration: Value: Max Enumeration: Value: Min Enumeration: Value: Product Enumeration: Value: StdDev Enumeration: Value: StdDevP Enumeration: Value: Sum Enumeration: Value: Var Enumeration: Value: VarP ------------------------------------------------------------------------ Path: /SubtotalFormatType Description: Specifies the text formatting that is applied to a subtotal. ------------------------------------------------------------------------ Path: /SubtotalFormatType/Style Attribute: Type: string Attribute: Use: required Description: A text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal. ------------------------------------------------------------------------ Path: /TotalAlignmentType Description: Specifies the horizontal alignment of a total. Restriction: Base: string Enumeration: Value: Automatic Enumeration: Value: Center Enumeration: Value: Left Enumeration: Value: Right ------------------------------------------------------------------------ Path: /TotalCaptionAlignmentType Description: Specifies the horizontal alignment of the caption for a total. Restriction: Base: string Enumeration: Value: Automatic Enumeration: Value: Center Enumeration: Value: Left Enumeration: Value: Right ------------------------------------------------------------------------ Path: /PLPivotFieldType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Name Element: Type: string Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /PLPivotFieldType//SourceName Element: Type: string Description: Contains the name of a field or item as it appears in a PivotTable cache. ------------------------------------------------------------------------ Path: /PLPivotFieldType//BoundField Description: Specifies whether the PivotTable field is the bound field of an automatic date field set. ------------------------------------------------------------------------ Path: /PLPivotFieldType//DataType Element: Type: DataTypeType Element: Default: String Description: Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources. ------------------------------------------------------------------------ Path: /PLPivotFieldType//FilterCaption Element: Type: string Description: Contains the caption of a field set when the field set is the current filter. ------------------------------------------------------------------------ Path: /PLPivotFieldType//PLDataOrientation Element: Type: int Description: Specifies whether a field is on the detail grid. ------------------------------------------------------------------------ Path: /PLPivotFieldType//PLPosition Element: Type: string Description: Specifies the position of a field in the detail grid. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Orientation Element: Type: OrientationType Element: Default: Hidden Description: Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Position Description: Specifies the position of a PivotField when multiple fields are used. ------------------------------------------------------------------------ Path: /PLPivotFieldType//ShowAllItems Description: Contains a Boolean value indicating whether all PivotItems should be shown even if they have no data. ------------------------------------------------------------------------ Path: /PLPivotFieldType//NumberFormat Element: Type: NumberFormatType Description: Specifies the display formatting to use when displaying the PivotItem or aggregate value. ------------------------------------------------------------------------ Path: /PLPivotFieldType//CurrentPage Element: Type: string Element: Default: All Description: Specifies the name of the PivotItem selected for a PivotField when the PivotField is in the page area. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Caption Element: Type: string Description: Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name. ------------------------------------------------------------------------ Path: /PLPivotFieldType//NewItemsHidden Description: Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Subtotal Description: Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types. Restriction: Base: string Enumeration: Value: Sum Enumeration: Value: None Enumeration: Value: Default ------------------------------------------------------------------------ Path: /PLPivotFieldType//PLSubtotal Element: Type: double Description: Contains the subtotal to display when a PivotTable field is not on the column or row axis. ------------------------------------------------------------------------ Path: /PLPivotFieldType//DetailFormat Description: Specifies the text formatting that is applied to a field when it is on the detail grid. ------------------------------------------------------------------------ Path: /PLPivotFieldType//DetailFormat//Style Attribute: Type: string Attribute: Use: required Description: Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field. ------------------------------------------------------------------------ Path: /PLPivotFieldType//SubtotalFormat Description: Specifies the text formatting that is applied to a subtotal. ------------------------------------------------------------------------ Path: /PLPivotFieldType//SubtotalFormat//Style Attribute: Type: string Attribute: Use: required Description: Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal. ------------------------------------------------------------------------ Path: /PLPivotFieldType//DetailWidth Element: Type: int Description: Specifies the width of a field (in pixels) when it appears on the detail axis. ------------------------------------------------------------------------ Path: /PLPivotFieldType//GroupedWidth Element: Type: int Element: Default: 50 Description: Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis. ------------------------------------------------------------------------ Path: /PLPivotFieldType//Expanded Description: Specifies whether the field members are expanded by default, or whether a leaf member was expanded. ------------------------------------------------------------------------ Path: /PLPivotFieldType//TotalWidth Element: Type: int Description: Specifies the width of a total and whether the width is automatically set. ------------------------------------------------------------------------ Path: /PLPivotFieldType//PivotItem Element: Type: PivotItemType Description: Contains information on an item (PivotItem) in the PivotField. ------------------------------------------------------------------------ Path: /DataTypeType Description: Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources. Restriction: Base: string Enumeration: Value: Number Enumeration: Value: Bin.Hex Enumeration: Value: Boolean Enumeration: Value: DateTime Enumeration: Value: Float Enumeration: Value: Integer Enumeration: Value: I1 Enumeration: Value: I2 Enumeration: Value: I8 Enumeration: Value: Int Enumeration: Value: String Enumeration: Value: UI1 Enumeration: Value: UI2 Enumeration: Value: UI4 Enumeration: Value: UI8 ------------------------------------------------------------------------ Path: /PivotFieldType Description: Contains information about a PivotField. ------------------------------------------------------------------------ Path: /PivotFieldType//DataField Description: Indicates that the PivotField element contains information for the data field of the report. ------------------------------------------------------------------------ Path: /PivotFieldType//Name Element: Type: string Description: Specifies the name of the PivotField. Also specifies the field in the data source that the PivotField represents. If the name of the PivotField and the name of the field in the data source are different, the SourceName element must also be used. ------------------------------------------------------------------------ Path: /PivotFieldType//MapChildItems Element: Type: MapChildItemsType Description: Specifies the group to which mapped PivotItem belongs. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoShowCount Element: Type: int Description: Contains a number indicating what PivotItems to display based on the values of the PivotItems. Used in conjunction with AutoShowField, AutoShowRange and AutoShowType. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoShowField Element: Type: string Description: Specifies the name of the PivotField in the data area of the PivotTable report from which to get the PivotItem value to be used when determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowRange and AutoShowType. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoShowRange Element: Type: AutoShowRangeType Element: Default: Top Description: Contains an enumeration indicating which range of values to use in determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowField and AutoShowType. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoShowType Element: Type: AutoShowTypeType Element: Default: Manual Description: Contains an enumeration indicating whether all PivotItems are displayed for a PivotField or whether the PivotItems displayed are based on the value falling within a user-specified range. Used in conjunction with AutoShowCount, AutoShowField and AutoShorRange. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoSortOrder Element: Type: AutoSortOrderType Element: Default: Manual Description: Contains an enumeration indicating how PivotItems, for this PivotField, are sorted in the PivotTable report. Used in conjunction with AutoSortField. ------------------------------------------------------------------------ Path: /PivotFieldType//AutoSortField Element: Type: string Description: Specifies the name of the PivotField being used to determine the sort order of the PivotItems in this PivotField. ------------------------------------------------------------------------ Path: /PivotFieldType//BaseField Element: Type: string Description: Specifies the name of the PivotField that this PivotField is derived from. Used for PivotFields in the data area and for PivotFields that have had their PivotItems grouped. ------------------------------------------------------------------------ Path: /PivotFieldType//BaseItem Element: Type: string Description: Specifies the name of the PivotItem that this PivotField is derived from. Used for PivotFields in the data area for certain calculation types. Used in conjunction with BaseField and Calculation. ------------------------------------------------------------------------ Path: /PivotFieldType//BlankLineAfterItems Description: Specifies that a blank line is to be inserted after each change in value. ------------------------------------------------------------------------ Path: /PivotFieldType//Calculation Element: Type: CalculationPivotFieldType Element: Default: Normal Description: Contains an enumeration indicating the type of calculation being done for the PivotField that is in the data area of the PivotTable report. ------------------------------------------------------------------------ Path: /PivotFieldType//CantGetUniqueItems Description: Contains a Boolean indicating that a list of unique items from the data source for this PivotField was unavailable. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupBy Element: Type: int Element: Default: 1 Description: Specifies the size of the groups for PivotItems when PivotItems have been grouped. Used in conjunction with GroupStart, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupStart Element: Type: string Description: Indicates the first PivotItem of the first group when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupEnd Element: Type: string Description: Indicates the last PivotItem of the last group when PivotItems have been grouped. Used in conjunction with GroupBy, GroupStart, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupStartAuto Description: Indicates that the first PivotItem of the first group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupEndAuto, GroupType, ParentField and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupEndAuto Description: Indicates that the last PivotItem of the last group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, ParentField and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//GroupType Element: Type: GroupTypeType Description: Contains an enumeration that indicates how the PivotItems of this PivotField are grouped. ------------------------------------------------------------------------ Path: /PivotFieldType//LayoutPageBreak Description: A Boolean indicating that a page break should be placed after each change in value for this PivotField. ------------------------------------------------------------------------ Path: /PivotFieldType//NumberFormat Element: Type: NumberFormatType Description: Specifies the display formatting to use when displaying the PivotItem or aggregate value. ------------------------------------------------------------------------ Path: /PivotFieldType//ParentField Element: Type: string Description: Specifies the name of the PivotField that is the parent (one level up) of this lower-level grouped PivotField. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, GroupEnd and BaseField. ------------------------------------------------------------------------ Path: /PivotFieldType//SourceName Element: Type: string Description: Specifies the field in the data source that the PivotField represents. Not required if the name element of the PivotField matches the field name in the data source. ------------------------------------------------------------------------ Path: /PivotFieldType//Orientation Element: Type: OrientationType Description: Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden. ------------------------------------------------------------------------ Path: /PivotFieldType//Function Element: Type: FunctionType Element: Default: Sum Description: Contains an aggregation to be performed to calculate the value in the cell. ------------------------------------------------------------------------ Path: /PivotFieldType//Subtotal Element: Type: SubtotalType Element: Default: Default Description: Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types. ------------------------------------------------------------------------ Path: /PivotFieldType//LayoutForm Element: Type: LayoutFormType Description: Specifies how items appear in a PivotTable report. ------------------------------------------------------------------------ Path: /PivotFieldType//LayoutSubtotalLocation Element: Type: LayoutSubtotalLocationType Description: Specifies where subtotals are displayed in a PivotTable report. ------------------------------------------------------------------------ Path: /PivotFieldType//NoDragToRow Description: Specifies that the field cannot be dragged to create column headers. ------------------------------------------------------------------------ Path: /PivotFieldType//NoDragToColumn Description: Specifies that the field cannot be dragged to create row headers. ------------------------------------------------------------------------ Path: /PivotFieldType//NoDragToData Description: Specifies that the field cannot be dragged to the data area. ------------------------------------------------------------------------ Path: /PivotFieldType//NoDragToHide Description: Specifies that the field cannot be dragged out of the pivot area. ------------------------------------------------------------------------ Path: /PivotFieldType//NoDragToPage Description: Specifies that the field cannot be dragged to the page area. ------------------------------------------------------------------------ Path: /PivotFieldType//MemberProperty Element: Type: MemberPropertyType Description: Contains additional information (member property information) about a field in OLAP-based PivotTable view or report. ------------------------------------------------------------------------ Path: /PivotFieldType//MemberPropertiesOrder Description: Specifies the order of a member property if a cube field is associated with multiple OLAP member properties. ------------------------------------------------------------------------ Path: /PivotFieldType//HideDropDowns Description: Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown. ------------------------------------------------------------------------ Path: /PivotFieldType//DrilledLevel Description: Contains a Boolean that indicates for a PivotField in an OLAP- based PivotTable whether this PivotField was shown due to the user navigating down an entire hierarchy level. ------------------------------------------------------------------------ Path: /PivotFieldType//ServerSortOrder Description: Contains a Boolean that indicates for a PivotField in an OLAP- based PivotTable whether the order of the PivotItems comes from the server or is determined by Excel. ------------------------------------------------------------------------ Path: /PivotFieldType//IsMemberProperty Description: Contains a Boolean value indicating whether OLAP member property information is displayed for a field. ------------------------------------------------------------------------ Path: /PivotFieldType//CurrentPage Element: Type: string Element: Default: All Description: Specifies the name of the PivotItem selected for this PivotField when the PivotField is in the page area. ------------------------------------------------------------------------ Path: /PivotFieldType//Caption Element: Type: string Description: Specifies the display text or caption for a PivotField in an OLAP- based PivotTable. ------------------------------------------------------------------------ Path: /PivotFieldType//FilterMember Description: Contains information about OLAP cube members that are selected when an OLAP hierarchy is shown in the page area of the PivotTable view. ------------------------------------------------------------------------ Path: /PivotFieldType//FilterMember///UniqueName Element: Type: string Description: Specifies a unique name for a OLAP cube member. ------------------------------------------------------------------------ Path: /PivotFieldType//FilterMember///Level Element: Type: integer Description: Contains the zero-based level index on which an OLAP cube member resides. ------------------------------------------------------------------------ Path: /PivotFieldType//FilterMember///Caption Element: Type: string Description: Specifies a caption for the OLAP cube member. ------------------------------------------------------------------------ Path: /PivotFieldType//Position Element: Type: int Element: Default: 1 Description: Specifies the order of the fields when several PivotFields are used. ------------------------------------------------------------------------ Path: /PivotFieldType//DataType Element: Type: DataTypeType Description: Specifies the data type of the field. ------------------------------------------------------------------------ Path: /PivotFieldType//ServerBased Description: Contains a Boolean indicating whether the server is queried every time the user changes the selected PivotItem for the PivotField that is in the page area. ------------------------------------------------------------------------ Path: /PivotFieldType//ShowAllItems Description: Contains a Boolean indicating whether all PivotItems should be shown or not even if they have no data. ------------------------------------------------------------------------ Path: /PivotFieldType//SQLType Element: Type: SQLTypeType Element: Default: Character Description: Specifies the data type using SQL Server data types. ------------------------------------------------------------------------ Path: /PivotFieldType//SubtotalName Element: Type: string Element: Default: Subtotal Description: Specifies the custom text to display for the subtotal label for this PivotField. ------------------------------------------------------------------------ Path: /PivotFieldType//PLTPivotItem Element: Type: PivotItemType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotFieldType//DetailFormat Element: Type: DetailFormatType Description: Specifies the text formatting that is applied to a field when it is on the detail grid. ------------------------------------------------------------------------ Path: /PivotFieldType//DetailWidth Element: Type: int Description: Specifies the width of a field (in pixels) when it appears on the detail axis. ------------------------------------------------------------------------ Path: /PivotFieldType//Expanded Description: Specifies whether the field members are expanded by default, or whether a leaf member was expanded. ------------------------------------------------------------------------ Path: /PivotFieldType//FilterCaption Element: Type: string Description: Contains the caption of a field set when the field set is the current filter. ------------------------------------------------------------------------ Path: /PivotFieldType//Formula Element: Type: string Description: Specifies the formula used to calculate the values for a PivotField in the data area. ------------------------------------------------------------------------ Path: /PivotFieldType//FormulaV10 Element: Type: string Description: Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element. ------------------------------------------------------------------------ Path: /PivotFieldType//ParseFormulaAsV10 Description: Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula). ------------------------------------------------------------------------ Path: /PivotFieldType//GroupedWidth Element: Type: int Element: Default: 50 Description: Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis. ------------------------------------------------------------------------ Path: /PivotFieldType//NewItemsHidden Description: Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed. ------------------------------------------------------------------------ Path: /PivotFieldType//PLCaption Element: Type: string Description: Specifies the contains the caption of a PivotList field. ------------------------------------------------------------------------ Path: /PivotFieldType//PLDataOrientation Description: Specifies whether a field is on the detail grid. ------------------------------------------------------------------------ Path: /PivotFieldType//PLGroupType Element: Type: string Description: Specifies whether a field is the Weeks field of a weekly automatic date field set. ------------------------------------------------------------------------ Path: /PivotFieldType//PLName Element: Type: string Description: Contains the name of a total when a PivotField element represents a total. ------------------------------------------------------------------------ Path: /PivotFieldType//PLPosition Element: Type: int Description: Specifies the position of a field in the detail grid. ------------------------------------------------------------------------ Path: /PivotFieldType//PLSubtotal Element: Type: double Description: Contains the subtotal to display when a PivotTable field is not on the column or row axis. ------------------------------------------------------------------------ Path: /PivotFieldType//SourceHierarchy Element: Type: string Description: Specifies the name of the hierarchy this PivotField belongs to in an OLAP-based PivotTable. ------------------------------------------------------------------------ Path: /PivotFieldType//MemberPropertyParent Element: Type: integer Description: Contains an index of the hierarchy level to which a particular OLAP member property applies. ------------------------------------------------------------------------ Path: /PivotFieldType//SourceHierarchyLevel Element: Type: string Description: Specifies a number indicating what level in the hierarchy this PivotField belongs to in an OLAP-based PivotTable. ------------------------------------------------------------------------ Path: /PivotFieldType//PivotItem Element: Type: PivotItemType Description: Contains information on an item (PivotItem) in the PivotField. ------------------------------------------------------------------------ Path: /PivotFieldType//SubtotalFormat Element: Type: SubtotalFormatType Description: Specifies the text formatting that is applied to a subtotal. ------------------------------------------------------------------------ Path: /PivotFieldType//TotalAlignment Element: Type: TotalAlignmentType Element: Default: Automatic Description: Specifies the horizontal alignment of a total. ------------------------------------------------------------------------ Path: /PivotFieldType//TotalCaptionAlignment Element: Type: TotalCaptionAlignmentType Description: Specifies the horizontal alignment of the caption for a total. ------------------------------------------------------------------------ Path: /PivotFieldType//TotalWidth Element: Type: int Description: Specifies the width of a total and whether the width is automatically set. ------------------------------------------------------------------------ Path: /PositionType Description: Contains the index position of a PivotTable field within its current orientation, or specifies the position of a PivotTable field on an axis, the position of a chart title or data label, or the base position of a label entry. Restriction: Base: string Enumeration: Value: Column Enumeration: Value: Data Enumeration: Value: Page Enumeration: Value: Row ------------------------------------------------------------------------ Path: /LayoutFormType Description: Specifies how items appear in a PivotTable report. Restriction: Base: string Enumeration: Value: Outline Enumeration: Value: Tabular ------------------------------------------------------------------------ Path: /LayoutSubtotalLocationType Description: Specifies how items appear in a PivotTable report. Restriction: Base: string Enumeration: Value: Top Enumeration: Value: Bottom ------------------------------------------------------------------------ Path: /DetailFormatType Description: Specifies the text formatting that is applied to a field when it is on the detail grid. ------------------------------------------------------------------------ Path: /DetailFormatType/Style Attribute: Type: string Attribute: Use: required Description: Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field. ------------------------------------------------------------------------ Path: /NumberFormatType Description: Specifies the number format to apply to data field items and totals. Restriction: Base: string Enumeration: Value: General Date Enumeration: Value: Short Date Enumeration: Value: Medium Date Enumeration: Value: Long Date Enumeration: Value: Short Time Enumeration: Value: Medium Time Enumeration: Value: Long Time Currency Enumeration: Value: Fixed Enumeration: Value: General Enumeration: Value: General Number Enumeration: Value: Percent Enumeration: Value: Scientific Enumeration: Value: Standard (#,##0.00) Enumeration: Value: On/Off Enumeration: Value: True/False Enumeration: Value: Yes/No Enumeration: Value: General Restriction: Base: string ------------------------------------------------------------------------ Path: /PivotItemType Description: Contains information on an item (PivotItem) in a PivotField. ------------------------------------------------------------------------ Path: /PivotItemType//Name Element: Type: string Description: Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. ------------------------------------------------------------------------ Path: /PivotItemType//Formula Element: Type: string Description: Specifies a formula used to set the value of the PivotItem. ------------------------------------------------------------------------ Path: /PivotItemType//FormulaV10 Element: Type: string Description: Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element. ------------------------------------------------------------------------ Path: /PivotItemType//ParseFormulaAsV10 Description: Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula). ------------------------------------------------------------------------ Path: /PivotItemType//FormulaIndex Element: Type: int Description: Specifies the order in which formulas are to be calculated for PivotItems that use multiple formulas. ------------------------------------------------------------------------ Path: /PivotItemType//Hidden Description: Specifies that the item is to be hidden. ------------------------------------------------------------------------ Path: /PivotItemType//HideDetail Description: Contains a Boolean indicating if detail data should not be shown for this PivotItem. ------------------------------------------------------------------------ Path: /PivotItemType//Missing Description: Contains a Boolean indicating whether or not the PivotItem is currently used in the data source. ------------------------------------------------------------------------ Path: /PivotItemType//CachePosition Element: Type: int Description: Indicates what data source item this PivotItem maps to in a PivotField that has been grouped. ------------------------------------------------------------------------ Path: /PivotItemType//Member Description: Specifies whether the PivotItem element contains the name of a member instead of another string or value. ------------------------------------------------------------------------ Path: /PivotItemType//SourceName Element: Type: string Description: Specifies the name of the item in the data source that data is to be drawn from. Required only when the value of the Name element is different from the name of the item in the data source. ------------------------------------------------------------------------ Path: /PivotItemType//DrilledMember Description: Contains a boolean value that indicated that the user has drilled down on an OLAP based PivotTable. ------------------------------------------------------------------------ Path: /PivotTableType Description: Contains information on a PivotTable. ------------------------------------------------------------------------ Path: /PivotTableType//Name Element: Type: string Description: Specifies the name of the PivotTable. ------------------------------------------------------------------------ Path: /PivotTableType//DataValueEditing Description: Contains a Boolean value indicating that the user is allowed to edit the cells in the data area of the PivotTable view or report. ------------------------------------------------------------------------ Path: /PivotTableType//QTSource Element: Type: QTSourceType Description: Describes the properties of the query table on which a PivotTable view or report is based. ------------------------------------------------------------------------ Path: /PivotTableType//ErrorString Element: Type: string Description: Specifies the string to display in cells with errors. Used in conjunction with DisplayErrorString. ------------------------------------------------------------------------ Path: /PivotTableType//NullString Element: Type: string Description: Specifies the string to display in cells with no value. Used in conjunction with NoDisplayNullString. ------------------------------------------------------------------------ Path: /PivotTableType//PageFieldOrder Element: Type: PageFieldOrderType Element: Default: DownThenOver Description: Contains an enumeration indicating how the page fields are laid out when there are multiple PivotFields in the page area. ------------------------------------------------------------------------ Path: /PivotTableType//PageFieldWrapCount Element: Type: PageFieldWrapCountType Description: Specifies a number indicating how many page fields to display before starting another row or column. ------------------------------------------------------------------------ Path: /PivotTableType//DisableDrillDown Description: Contains a Boolean indicating if the user is prevented from drilling down (double clicking) on a PivotItem or aggregate value. ------------------------------------------------------------------------ Path: /PivotTableType//DisableFieldDialog Description: Contains a Boolean indicating if the user is prevented from displaying the PivotField properties dialogs. ------------------------------------------------------------------------ Path: /PivotTableType//DisableWizard Description: Contains a Boolean indicating if the user is prevented from displaying the PivotTable Wizard. ------------------------------------------------------------------------ Path: /PivotTableType//DisplayErrorString Description: Causes the ErrorString to be displayed. Used in conjunction with ErrorString. ------------------------------------------------------------------------ Path: /PivotTableType//NoPreserveFormatting Description: Contains a Boolean indicating whether the formatting applied by the user to the PivotTable cells is discarded on refresh. ------------------------------------------------------------------------ Path: /PivotTableType//HasNoAutoFormat Description: Contains a Boolean indicating whether autoformatting has been applied to the PivotTable view. Used in conjunction with AutoFormatName, AutoFormatNumber, AutoFormatBorder, AutoFormatPattern, AutoFormatAlignment and NoAutoFormatWidth. ------------------------------------------------------------------------ Path: /PivotTableType//SubtotalHiddenPageItems Description: Specifies that data for hidden PivotItems for PivotFields in the data area are not excluded from subtotals. ------------------------------------------------------------------------ Path: /PivotTableType//NoAutoFormatWidth Description: Specifies that column widths from the style specified in the AutoFormatName element are not to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//NoRowGrand Description: Contains a Boolean indicating if no grand totals should be displayed for the PivotTable rows. ------------------------------------------------------------------------ Path: /PivotTableType//NoColumnGrand Description: Contains a Boolean indicating if no grand totals should be displayed for the PivotTable columns. ------------------------------------------------------------------------ Path: /PivotTableType//NoDisplayNullString Description: Contains a Boolean indicating whether the custom NULL string should not be displayed. Used in conjunction with NullString. ------------------------------------------------------------------------ Path: /PivotTableType//NoPrintRepeatItems Description: Contains a Boolean indicating whether PivotItem names should be repeated at the top of each printed page. ------------------------------------------------------------------------ Path: /PivotTableType//PivotView Element: Type: PivotViewType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//Selection Element: Type: SelectionType Description: Contains information about the current PivotTable selection. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatAlignment Description: Specifies that alignments from the style defined in the AutoFormatName element are to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatBorder Description: Specifies that border settings from the style defined in the AutoFormatName element are to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatFont Description: Specifies that fonts from the style defined in the AutoFormatName element are to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatName Element: Type: AutoFormatNameType Element: Default: PivotTableClassic Description: Specifies the name of the built-in format to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatNumber Description: Specifies that number formatting from the style defined in the AutoFormatName element is to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//AutoFormatPattern Description: Specifies that the pattern from the style defined in the AutoFormatName element is to be applied. ------------------------------------------------------------------------ Path: /PivotTableType//GrandTotalString Element: Type: string Element: Default: Grand Total Description: Specifies the string to be displayed for grand totals. ------------------------------------------------------------------------ Path: /PivotTableType//PrintSetTitles Description: Specifies the row and column titles from the PivotTable to be printed (rather than the titles from the spreadsheet). ------------------------------------------------------------------------ Path: /PivotTableType//MergeLabels Description: Specifies that row or column titles that span multiple cells should be merged into a single cell. ------------------------------------------------------------------------ Path: /PivotTableType//PageFieldStyle Element: Type: string Description: Specifies the name of the Excel style to apply to each of the PivotField-PivotItem headers displayed in the page area. ------------------------------------------------------------------------ Path: /PivotTableType//PLExport Description: Contains a Boolean indicating whether the PivotTable was created by the Office Web Components PivotList control. ------------------------------------------------------------------------ Path: /PivotTableType//ImmediateItemsOnDrop Description: Specifies that the PivotTable view is to be immediately updated when new items are dropped into it. ------------------------------------------------------------------------ Path: /PivotTableType//ShowPageMultipleItemLabel Description: Specifies the text to display for the PivotItem header in the page area when two or more PivotItems, but not all PivotItems, have been selected. ------------------------------------------------------------------------ Path: /PivotTableType//SmallGrid Description: Contains a Boolean indicating if a PivotTable view without a data field should show the small grid, which doesn't have very big drop areas. ------------------------------------------------------------------------ Path: /PivotTableType//TableStyle Element: Type: string Description: Specifies the name of the Excel style to apply to the main table area of the PivotTable. ------------------------------------------------------------------------ Path: /PivotTableType//Tag Element: Type: string Description: Specifies a user-defined string that is associated with this PivotTable. ------------------------------------------------------------------------ Path: /PivotTableType//VacatedStyle Element: Type: string Description: Specifies the name of the Excel style to apply to the cells left blank when a PivotTable shrinks during a refresh operation. ------------------------------------------------------------------------ Path: /PivotTableType//HideTotalsAnnotation Description: Specifies that asterisks be displayed in subtotals and totals when visual totals are not used in OLAP-based PivotTable views. ------------------------------------------------------------------------ Path: /PivotTableType//ShowCellBackgroundFromOLAP Description: Contains a Boolean value indicating that a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source. ------------------------------------------------------------------------ Path: /PivotTableType//HideDropDowns Description: Contains a Boolean value indicating whether the drop-down lists for the fields in the PivotTable view should be shown. ------------------------------------------------------------------------ Path: /PivotTableType//NoViewCalculatedMembers Description: Contains a Boolean value indicating whether calculated members should be hidden in a PivotTable view or report. ------------------------------------------------------------------------ Path: /PivotTableType//VisualTotals Description: Indicates that totals should be based on visible data only for OLAP-based PivotTable views. ------------------------------------------------------------------------ Path: /PivotTableType//Location Element: Type: string Description: Specifies the bounding cell reference the PivotTable occupies including the page area. ------------------------------------------------------------------------ Path: /PivotTableType//PLPivotField Element: Type: PLPivotFieldType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//PLTotal Element: Type: PLTotalType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//DataMember Element: Type: string Description: Specifies whether the data source of a PivotList component is data from Microsoft Excel that was saved to a Web page or data from a Data Source Control component. ------------------------------------------------------------------------ Path: /PivotTableType//DataAxisEmpty Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//DisplayFieldList Description: Contains a Boolean indicating that the PivotField list window should not be shown. ------------------------------------------------------------------------ Path: /PivotTableType//NoAutoFit Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//Height Element: Type: double Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//Width Element: Type: double Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//MaxHeight Element: Type: double Element: Default: 32000 Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//MaxWidth Element: Type: double Element: Default: 32000 Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//MemberExpand Element: Type: MemberExpandType Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//ConnectionString Element: Type: string Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//CacheDetails Element: Type: CacheDetailsType Element: Default: True Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//FieldListTop Element: Type: int Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//FieldListBottom Element: Type: int Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//FieldListRight Element: Type: int Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//FieldListLeft Element: Type: int Description: This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. ------------------------------------------------------------------------ Path: /PivotTableType//PivotAxis Element: Type: PivotAxisType Description: Specifies additional information about a PivotTable axis or location. ------------------------------------------------------------------------ Path: /PivotTableType//VersionUpdateableMin Element: Type: string Description: Contains a number indicating the earliest version of Excel that can update this PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//VersionLastUpdate Element: Type: string Description: Contains a number indicating which version of Excel last updated this PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//VersionRefreshableMin Element: Type: string Description: Contains a number indicating the earliest version of Excel that can refresh this PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//DefaultVersion Element: Type: string Description: Contains a number indicating what version of Excel was used to create this PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//PivotField Element: Type: PivotFieldType Description: Contains information about a PivotField. ------------------------------------------------------------------------ Path: /PivotTableType//CubeField Element: Type: CubeFieldType Description: Contains information about a cube field (a hierarchy in an OLAP- based PivotTable view). ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember Description: Contains information about a calculated member in an OLAP-based PivotTable view or report. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///Name Element: Type: string Description: Specifies the name of the OLAP calculated member. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///MemberName Element: Type: string Description: Specifies a caption (display name) for the custom OLAP calculated member (not used for sets). ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///ParentUniqueName Element: Type: string Description: Specifies a unique name for the parent member of the OLAP calculated member (not used for sets). ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///SourceHierarchy Element: Type: string Description: Specifies a unique name for the hierarchy with which the OLAP calculated member is associated (not used for sets). ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///SourceHierarchyLevel Element: Type: integer Description: Contains an index of the hierarchy level to which a particular OLAP member property applies. A value of 32767 indicates that the OLAP member property applies to all the levels in a hierarchy. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///Formula Element: Type: string Description: Contains the MDX representation of the formula for the OLAP calculated member. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///SolveOrder Element: Type: integer Description: Specifies where in a sequence of calculations a calculated member will be computed and applied. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///Invalid Description: Contains a Boolean value indicating that the OLAP cube changed in such a way as to invalidate the OLAP calculated member. ------------------------------------------------------------------------ Path: /PivotTableType//CalculatedMember///Set Description: Contains a Boolean value indicating that a calculation creates a custom OLAP set. ------------------------------------------------------------------------ Path: /PivotTableType//PTLineItems Element: Type: PTLineItemsType Description: Contains information describing the detailed layout of a PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//PTSource Element: Type: PTSourceType Description: Contains information describing the data source of the PivotTable view. ------------------------------------------------------------------------ Path: /PivotTableType//PTFormula Element: Type: PTFormulaType Description: Contains information describing a PivotTable formula that doesn't apply to a whole PivotField or all PivotItems with the same name. ------------------------------------------------------------------------ Path: /PivotTableType//PTFormat Element: Type: PTFormatType Description: Contains information describing some formatting applied to the PivotTable view. ------------------------------------------------------------------------ Path: /QTSourceType Description: Describes the properties of the query table on which a PivotTable view or report is based. ------------------------------------------------------------------------ Path: /QTSourceType//DataMember Element: Type: string Element: Default: XLDataSource Description: Specifies the data source of the PivotTable view or report. It is set to the text "XLDataSource". ------------------------------------------------------------------------ Path: /QTSourceType//CacheFile Description: Specifies the name of the file containing the supporting records for a PivotTable view or report. ------------------------------------------------------------------------ Path: /QTSourceType//CacheFile//Href Attribute: Type: string Attribute: Use: required Description: Specifies the name of the file containing the supporting records for a PivotTable view or report. ------------------------------------------------------------------------ Path: /QTSourceType//QuerySource Element: Type: QTQuerySourceType Description: Describes the data source that a query table was based on when it was created from an external source. ------------------------------------------------------------------------ Path: /QTSourceType//CacheIndex Element: Type: integer Description: Contains a unique identifier for the cache containing the supporting records for a PivotTable view or report. ------------------------------------------------------------------------ Path: /CubeFieldType Description: Contains the properties of a cube field. ------------------------------------------------------------------------ Path: /CubeFieldType//UniqueName Element: Type: string Description: Contains the unique name of a field. ------------------------------------------------------------------------ Path: /CubeFieldType//Caption Element: Type: string Description: Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name. ------------------------------------------------------------------------ Path: /CubeFieldType//DefaultItem Element: Type: string Description: Contains the name of the default page field item in a hierarchy. ------------------------------------------------------------------------ Path: /CubeFieldType//AllItemName Element: Type: string Description: Contains the unique name displayed for the page field when the user chooses to display all levels of a hierarchy. ------------------------------------------------------------------------ Path: /CubeFieldType//Dimension Element: Type: string Description: Contains the unique name of the dimension of a field. ------------------------------------------------------------------------ Path: /CubeFieldType//DontShowInFieldList Element: Type: string Description: Contains a Boolean value indicating whether a cube field should be shown in the field list for a PivotTable view or report. ------------------------------------------------------------------------ Path: /CubeFieldType//Measure Description: Specifies whether a field is a measure or hierarchy. ------------------------------------------------------------------------ Path: /CubeFieldType//Set Description: Contains a Boolean value indicating whether a cube field is a user-defined set. ------------------------------------------------------------------------ Path: /CubeFieldType//NoDragToData Description: Specifies whether a PivotTable field can be dragged to a data position. ------------------------------------------------------------------------ Path: /CubeFieldType//NoDragToHide Description: Contains a Boolean value indicating that a cube field cannot be removed from a PivotTable view or report. ------------------------------------------------------------------------ Path: /CubeFieldType//NoDragToRow Description: Specifies whether a PivotTable field can be dragged to a row position. ------------------------------------------------------------------------ Path: /CubeFieldType//NoDragToColumn Description: Specifies whether a PivotTable field can be dragged to a column position. ------------------------------------------------------------------------ Path: /CubeFieldType//NoDragToPage Description: Specifies whether a PivotTable field can be dragged to a page position. ------------------------------------------------------------------------ Path: /CubeFieldType//EnableMultiplePageItems Description: Contains a Boolean value indicating that the user is allowed to select two or more OLAP cube members when a given cube field is in the page area of the PivotTable view. ------------------------------------------------------------------------ Path: /CubeFieldType//LayoutForm Element: Type: LayoutFormType Description: Specifies how items appear in a PivotTable report. ------------------------------------------------------------------------ Path: /CubeFieldType//LayoutSubtotalLocation Element: Type: LayoutSubtotalLocationType Description: Specifies where subtotals are displayed in a PivotTable report. ------------------------------------------------------------------------ Path: /CubeFieldType//Orientation Element: Type: OrientationType Element: Default: Hidden Description: Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. ------------------------------------------------------------------------ Path: /CubeFieldType//MemberProperty Element: Type: MemberPropertyType Description: Contains information about an OLAP member property field. ------------------------------------------------------------------------ Path: /CubeFieldType//MemberPropertiesOrder Description: Specifies the order of a member property if a cube field is associated with multiple OLAP member properties. ------------------------------------------------------------------------ Path: /CubeFieldType//HideDropDowns Description: Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown. ------------------------------------------------------------------------ Path: /CubeFieldType//GroupLevel Description: Describes the grouping properties for a hierarchy level in an OLAP-based PivotTable view or report. ------------------------------------------------------------------------ Path: /CubeFieldType//GroupLevel///IsGroupLevel Description: Contains a Boolean value indicating that an OLAP hierarchy level is a custom group level rather than a level from the original OLAP cube. ------------------------------------------------------------------------ Path: /CubeFieldType//GroupLevel///UniqueName Element: Type: string Description: Specifies a unique name for an OLAP hierarchy group level. ------------------------------------------------------------------------ Path: /CubeFieldType//GroupLevel///Name Element: Type: string Description: Specifies a caption (display name) for an OLAP hierarchy group level. ------------------------------------------------------------------------ Path: /CubeFieldType//GroupLevel///GroupDefinition Element: Type: GroupDefinitionType Description: Describes a particular grouping of OLAP members in a hierarchy level in an OLAP-based PivotTable view or report. ---------------------------------------