All geek questions in one place

PivotTable with Google Script

I use Script in a Google spreadsheet and it is very cool.

I had a problem.

I tried to create (from an already loaded part of the data) create a summary report .. no problems with choosing a menu in the spreadsheet (Menu "date" → "Summary report") ... I could not find a way to create a Script that I can do this automatically.

How to create a pivot table in a Google Script spreadsheet?

And, perhaps?

+3
source share
2 answers

A pivot table is created, although the script, although it is not Google, which you mentioned in your post. See the pivot table through a script from Romain Vialard , which is available in the script galary spreadsheet (just go to Tools> Script galary from the spreadsheet menu, then search the pivot table and Romain appears.)

+1
source

A new feature has appeared in the worksheet: Extended Sheets Service.

It has several more features, such as creating a pivot table.

This is an advanced service that must be activated before use.

This means you need to enable it twice:

Here is the code:

https://developers.google.com/apps-script/advanced/sheets#create_a_pivot_table

+2
source

Source: https://habr.com/ru/post/988324/

More articles:


All Articles