How to create a Pivot Table in Excel with Javascript API

Question

Can someone tell me? How to create a pivot table in MS Excel using Javascript API? (Web Addins) I know how to create it with VSTO, VBA. But, I don't know how to create it with Javascript API. Is it real? How can I use add-ins if I can not even create a pivot table? Thanks

Answer 1

Currently, the PivotTable object only supports a refresh() method. There is a UserVoice request to support creating PivotTables that is currently listed as "In Backlog" but there isn't an ETA for what it might roll out.