search

OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.
https://learn.microsoft.com/javascript/api/overview
Other
675 stars 95 forks source link

Update PivotTable DataSource with the Office Excel JavaScript API #2953

Closed anton-advasoftware closed 1 year ago

anton-advasoftware commented 1 year ago

It was possible to change an existing pivot table's data source when developing an Excel COM add-in and when using VBA, but currently that does not seem to be possible in the JavaScript API.

It would be helpful to add this functionality to the JavaScript API because currently you can only set the PivotTable data source when creating a new pivot table. It's common for Excel users to change a pivot table's data source, so it would be helpful to support it programmatically in the JavaScript API.

Link to Ideas Forum: https://techcommunity.microsoft.com/t5/microsoft-365-developer-platform/update-pivottable-datasource-with-the-office-excel-javascript/idi-p/3565018

KelBowen commented 1 year ago

Thank you for this feature request and for posting it to the Ideas forum. (I upvoted your idea there.) We track feature requests on the Ideas area so closing this here. Please check back there and encourage friends to upvote your idea.