script-lab

script-lab copied to clipboard

Description:

I need to know if I can change the number format in my pivot table using script lab. I tried to change the number format for my column in pivot table, doesn't work and throw an error.

by the way, I checked the number format in "Excel.DataPivotHierarchy class" document. There is no example or clear explanations to tell me how to use the property, so I log it out on my console and change the keyword from "General" to "Percentage". doesn't work.

Screenshot(s):

Please share you sample data and completed code here, if the issue still there

This is a great question for Stack Overflow with the office-js tag.