How can I scrape Excel sheet with Pivot tables using python?

Hi.
Currently I'm working on a project where I have to extract content from exel sheet, Which is having pivot or filter tables.

How can I easily extract using python. Is there any library.?

Is there any links whr I can learn this.

python #xlrd #xlsx #scraping

Comments

[Vedant Chainani]

You can use the openpyxl library in python

[Lohit Badiger]

Hi. Currently the files are in XLS format.
So openpyxl will not support XLS format.
And I know we cn use openpyxl in this situation. But I don't know how to handle the pivot tables.