English
Close
 简体中文
 Русский
 عربي
 Français
 Deutsch
 Italiano
 Español
 Svenska
 Türkçe
English
简体中文 Русский عربي Français Deutsch Italiano Español Svenska Türkçe
  • caret-down
      • caret-closedCalculate
      • caret-closedConversion
      • caret-closedData Processing
      • caret-closedText Processing
      • caret-closedTransform
      • caret-closedManagement
      • caret-closedSearch and Replace
      • caret-closedProtection
      • caret-closedFiles and Storage
      • caret-downDeveloper Guide 3.0
          • caret-downSpreadsheet Elements
              • caret-closedAutoFilter
              • caret-closedCharts
              • caret-closedComments
              • caret-closedListObjects
              • caret-closedMetadata & Properties
              • caret-closedOleObjects
              • caret-closedPictures
              • caret-downPivotTables
                  • Get
                  • Get all
                  • Add pivot field
                  • Filters
                  • Delete
                  • Clear
                  • Format
                  • Format all
                  • Hide
                  • Move
              • caret-closedRange
              • caret-closedValidations
              • caret-closedWorksheets
              • caret-closed
              • caret-closed
              • caret-closed
              • caret-closed
              • caret-closed
              • caret-closed
              • caret-closed
          • caret-closedSpreadsheet Operations
          • caret-closedTasks
      • caret-closedOther Features
  1. Home
  2. Developer Center
  3. Developer Guide 3.0
  4. Spreadsheet Elements
  5. PivotTables

Working with Excel PivotTable

Contents
[ Hide ]
  1. Working with PivotTables on an Excel file

Working with PivotTables on an Excel file

  • How to get PivotTable information from an Excel worksheet.
  • How to get PivotTable information by index from an Excel worksheet.
  • How to add a PivotTable in a worksheet.
  • How to add a PivotField into a PivotTable.
  • How to delete all PivotTables from an Excel worksheet.
  • How to delete a PivotTable by index from an Excel worksheet.
  • How to update cell style for a PivotTable.
  • How to update style for all PivotTables.
  • How to add filters to a PivotTable.
  • How to hide a PivotField item in a PivotTable.
  • How to move a PivotTable on an Excel worksheet.
  • How to work with the CellsObjectOperate task.
  • How to convert a list object to a PivotTable.