Grabbing Info from a Pivot table and placing it into another excel non pivot file

[#0!]

Hello,

I was curious if anyone would be able to help me with something I've been working on. I currently have a Python file that reads excel files but I'm having problems grabbing information from an excel file that's also a pivot table (as I would like to change filters automatically in my Python script to grab different information). If this isn't possible that's fine but, if there is a different way to do this, that would be fantastic and I would love to be pointed in the right direction or somewhere with tutorials. The over all goal is to grab information from multiple pivot tables based on different filters for each category from one excel file and place them in another excel file into certain rows/columns.

Many Thanks,

#0!

[buran]

what's the source of the pivot table data? why not just grab the source data and process them in python, e.g. with pandas.pivot_table?

[#0!]

Is there a way to grab the csv from the excel file using python? cause if so that would make everything so much easier.

[buran]

of course, you can read all kind of files with python - e.g. csv, excel (xlsx, xls), json, connect to db

if you need help with python - you may want to join dedicated python forum