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

Опубликовано: 19 Июль 2019
на канале: Sigma Coding
2,397
20

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
Link: https://github.com/areed1192/sigma_co...


Resources:
--------------------------------------------------
Facebook Page:   / codingsigma  
Facebook Group:   / sigmacoding  
GitHub Sigma Coding: https://github.com/areed1192/sigma_co...

Support Sigma Coding:
--------------------------------------------------
Patreon:   / sigmacoding  
Amazon Associates: https://amzn.to/3bsTI5P **

Related Topics:
--------------------------------------------------
Title: Conditional Formatting in the Excel JavaScript API
Link:    • Conditional Formatting in the Excel J...  

Title: How to Build Custom Excel Functions in the Excel JavaScript API
Link:    • How to Build Custom Excel Functions i...  

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

Title: Working With Pivot Tables in the Excel JavaScript API | Part 1
Link:    • Working With Pivot Tables in the Exce...  

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

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

Title: Working With the Workbook Object in the Office JavaScript API
Link:    • Working With the Workbook Object in t...  

Title: How To Work With a Worksheet in the Office JavaScript API
Link:    • How To Work With a Worksheet in the O...  


**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.

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


Смотрите видео Working With Pivot Tables in the Excel JavaScript API | Part 1 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Sigma Coding 19 Июль 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,39 раз и оно понравилось 2 людям.