Refreshing excel data and pivot tables using python

This video explains how to update data in an excel sheet using python and automatically refresh the pivot tables.

[justyz]

I've been looking for this for weeks! Awesome, thank you :)

[jamesvasanth]

Is it possible to change the filter of the pivot table ???

[Kusum]

This is brilliant Indranil. However, I'm looking for a way to refresh pivot while in-memory, delete the data sheet because my data is huge and then see the refreshed data as pivot table has a cache memory of its own. Also, I need to do this with openpyxl package bcoz I'm working on Databricks

[Morelifee]

Wowww!!! This is fantastic..thanku very much!! I had one query if u could help..what if the Marks data is in another Excel workbook which is updated daily and all other pivots are present in another workbook which needs to b refreshed automatically once data updates..slight change..please help!! Big thanku!!!

[lookforwardandsmile]

is it possible to refresh multiple excel sheets without stating every single directory?

[angeline]

Hey, I have tried this & it is only pasting int/float values too my excel sheet & leaves the object columns blank. Can you help me with this?

[brucesanders]

Could you share the code you used to refresh the pivot table. Thanks