English
Close
 简体中文
 Русский
 عربي
 Français
 Deutsch
 Italiano
 Español
 Svenska
 Türkçe
English
简体中文 Русский عربي Français Deutsch Italiano Español Svenska Türkçe
  • caret-downDeveloper Center
      • caret-closedWhat's new
      • caret-closedGetting Started
      • caret-closedLearn
      • caret-downDeveloper Guide
          • caret-closedCalculate
          • 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
      • caret-closedDocker
      • Release Notes
  1. Home
  2. Developer Center
  3. Developer Guide
  4. Developer Guide 3.0
  5. Spreadsheet Elements
  6. 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.