Working With Pivot Tables in the Excel JavaScript API | Part 1

One of the more popular features of Excel is the Pivot Table, which allows us to slice and dice large amounts of data in no time. Being able to control these object using the JavaScript API will make adding new functionality to our Excel application easy. In this video, we explore the topic of Pivot tables, how to create them, how to add rows, and do aggregations.

Video Resources:
--------------------------------------------------
Resource: GitHub File

Resources:
--------------------------------------------------

Support Sigma Coding:
--------------------------------------------------

Related Topics:
--------------------------------------------------
Title: Conditional Formatting in the Excel JavaScript API

Title: How to Build Custom Excel Functions in the Excel JavaScript API

Title: How To Work With Tables in the Office JavaScript API

Title: Working With Pivot Tables in the Excel JavaScript API | Part 1

Title: How To Select Ranges of Cells in the Microsoft Office JavaScript API

Title: How To Work With Excel Ranges in the Office JavaScript API

Title: Working With the Workbook Object in the Office JavaScript API

Title: How To Work With a Worksheet in the Office JavaScript API

**Amazon Associates Disclosure:
--------------------------------------------------

Tags:
--------------------------------------------------
#Excel #JavaScriptAPI #PivotTables

[brandon-mrip]

4 years late here, i can see that in this example you specified a range is there a way to use the data to specify range like for instance you already had A2 selected, so using the data you want to import and the current selected cell to determine the range

[Kang_Do_Zhong]

Thank you for the video, I have subscribed your channel.
Is it possible to add a custom column to a pivot table by OfficeJS while the Pivot itself is still able
to reflect raw data and update aggregated values?
That issue brought me here as I can't do that thing with VBA or UI

[shanisuthar]

Hi Alex,
How to get the Pivot table name and pivot field name of the selected or active cell using Excel JavaScript API?