Hi,
Please let me know if there is any means to apply the filters in pivot table of excel sheet from the html page. what i am trying to do is to set the pivot filters from the html page and get corresponding data into html page by cell reference. i am able to get the data from excel into html page but not sure of applying filters through html by using javascript.

i have attached the sample excel file with a pivot table.

Thanks in advance!