Automate Excel Pivot Table With Python

Excel being the most popular spreadsheet application + Python being one of the most popular programming language, by integrating these two applications, we can build some really useful and sophisticate applications.

In this tutorial, we will learn how to automate Excel pivot table with Python using pywin32 (win32com) library.

▶ References

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#excel #python #ExcelAutomation

[intoperspective]

This video deserves a lot more views than this and I am sure it will. Very detailed, and simple to understand. Thank you for such a great video.

[gaben_aTan]

Спасибо за видео. Долго искал, как создать сводную. именно таким образом 😊👍👍👍👍👍👍👍👍👍

[hamletrex]

great video, thanks for the effort! Can you tell, or show, how would you filter out some value in 'Agency name' filter? I've been trying with CurrentPage and Add2, but I get the error every time.

Hi Jie!

Thanks for this video! It helped me a lot.

Regards from Colombia.

[manteshwarhajare]

Really impressed, im looking how to create pivot table by using python, instead of pandas, Because when we use pandas we cant use pivot table functionality. By using win32 we can achieve this.

[ghadirsaadati]

Many thanks.
First of all, I really appreciate your video.
Secondly, may I ask how we can add all fields_rows in one column ? Because with Excel Pivot table, when you put all data in rows, it will automatically put them in one column, one under another.

[zaozaoliu]

That is really helpful! Thanks! May I also ask if it is possible to add an calculated field into the pivot table, supposedly

[coffeeman]

Amazing tutorial, i used this on one of my project. @Jie Jenn is it possible to add a calculated field here? I find it hard to mimic the manual calculated field creation.

[bashashaik]

Thank you so much for publishing this video. Need your help to hide the subtotals, I used = False but its not working. Please provide the code if you have already.

[tridibbiswas]

Hi Thank you for your videos. Could you also share how is your vscode is configured for python dev.

[shinywilliam]

Can we able to add the field settings to this table ? like layout & print options ?

[ylnswzxlzdxy]

Hi Jie, if i want to not show subtotals and repeat all labels, how shud i write? trying out these for repeating all labels:
pt.ColumnAxisLayout(win32.constants.xlRepeatLabels), still getting error, do you have any ways to not show subtotals and repeating all labels ?

[champak_chacha]

How can I get first row number after applying filter in Excel sheet using xlwings?

[deyvisvalladares]

Great!!! I have a question...How to add filter in pivote table with py?

[aksharanganeshan]

Hey hi, I cant see any pivot table generated . I tried the exact same code

[intoperspective]

How did you get autocompletion for win32 attributes? For example, when you Type, xlApp.Visible, it should suggest .Visible
but mine is not doing that. Please help..

[raj]

Hi, if i don't want subtotal then what to do?

[ABCXYZ]

Can you tell how to add Filters just like columns and row and values in pt?

[victorbrax]

How to use "Show values as (example: % of Row Total)", like Value Field Settings when right clicking on field?

[intoperspective]

Hi Jie, do you have any ideas on how I would be able to group Pivot Table Fields of Months and Years? I've been trying:
Test = wsPivotTable.Range("B2")
Test.Group(Start=True, End=True, Periods=list([False, False, False, False, True, False, True]))

and it would group the Months only, but not the Years, even though I have its corresponding value to True....