DEV Community

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

Collapse
 
envoy_ profile image
Vedant Chainani

You can use the openpyxl library in python

Collapse
 
lohitbadiger profile image
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.