支持Google脚本的数据透视表 [英] Pivot table with Google Script

问题描述

我在Google电子表格中使用了脚本，它非常棒。

我遇到了问题。我试图创建（从一块已经加载的数据）创建一个数据透视报告..没有问题，在电子表格中的菜单选择（菜单日期 - >枢轴报告）...我找不到方法创建一个脚本，我可以自动执行此操作。

如何在Google Spreadsheet Script中创建数据透视表？

和'possible？

解决方案

虽然不是Google提供的帖子。请参阅其中可以在电子表格脚本galary中找到（只需从电子表格的菜单中进入工具>脚本galary;一旦搜索到了Pivot Table，并且Romain出现了。）

I use Script in Google spreadsheet and it is very great.

I had a problem.

I tried to create (from a piece of data already loaded) to create a Pivot Report .. no problem with the menu selection in the spreadsheet (Menu "date" -> "Pivot Report") ... I could not find a way to create a script that I can do this automatically.

How to create a pivot table in Google Spreadsheet Script?

And 'possible?

解决方案

A Pivot Table has been created though script, although its not Google's one that you mentioned in your post. See the Pivot Table through script by Romain Vialard which is available in the spreadsheet script galary (just go to the Tools>Script galary from the spreadsheet's menu; once there do a search for Pivot Table, and Romain's comes up.)

这篇关于支持Google脚本的数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！