带有 Google Script 的数据透视表 [英] Pivot table with Google Script

问题描述

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

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

我遇到了问题.

我尝试创建(从一段已经加载的数据)来创建一个透视报告......电子表格中的菜单选择没有问题(菜单日期"->透视报告")......我不能找到一种方法来创建一个我可以自动执行此操作的脚本.

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.

如何在 Google 电子表格脚本中创建数据透视表?

How to create a pivot table in Google Spreadsheet Script?

还有'可能吗?

推荐答案

已经通过脚本创建了数据透视表，尽管它不是您在帖子中提到的 Google 的数据透视表.请参阅通过 Romain Vialard 编写的脚本的透视表在电子表格脚本库中可用(只需从电子表格的菜单中转到工具>脚本库；一旦搜索到数据透视表，就会出现 Romain 的.)

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 Script 的数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！