JavaScript Method to change PivotTable Data Range Google Docs Spreadsheet

Question

What is the method to change the data range of a pivot table in a Google Docs spreadsheet?

The documentation for this is not on Google's support site.

See following answer on Stack Overflow: http://stackoverflow.com/questions/11326172/pivot-table-with-google-script — Jacob Jan Tuinstra, Nov 07 '12 at 19:32
https://stackoverflow.com/questions/11326172/pivot-table-with-google-script/52601364#52601364 — BuffK, Oct 02 '18 at 02:51

score 1 · Answer 1 · answered Dec 10 '15 at 16:25

I found a workaround that could help you.

Create a sheet dedicated to your data, row 1 = headers, all other rows = data.

Delete rows with no data.

If for example you use columns A through F, create a Pivot and use this range: SHEET_NAME!A:F

The pivot will "grow" to the news rows because the range is "all the data in the columns A to F".

score 0 · Answer 2 · answered Nov 15 '12 at 03:49

0

Unfortunately it's not possible to modify pivot table settings via Google Apps Script. If you'd like to see this feature please file a feature request on our issue tracker.

answered Nov 15 '12 at 03:49

Eric Koleda

12,420
1
33
51

JavaScript Method to change PivotTable Data Range Google Docs Spreadsheet

2 Answers2

Linked