I have an excel file which contains a pivot that was created on a text file, and the raw data does not appear in any sheet naturally.
Manually it is quite simple, you just double click a pivot cell and it will automatically generate a new sheet containing the raw data the pivot is based on.
Now, I have looked practically everywhere with no success of finding out how to perform this automatically - all I need is a python access to the "hidden data" behind the pivot.
I might have used wrong keywords due to lack of excel knowledge, any guidance regarding this matter will be appreciated.
Thank you