Automate Excel Reporting Using Python (Real-Life-Example) | Pandas, Plotly, Xlwings Tutorial

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
There’s a lot of pain points in Excel that make it a tool that’s cumbersome and repetitive for data manipulation. But did you know that you can also use Python to automate repetitive tasks in Excel? In this video, I will be sharing my favourite ways to automate Microsoft Excel using Python. In particular, we will be using the open-source tools: Pandas, xlwings & plotly. After this video, you will be able to create a custom Python script that allows you to combine excel files & create charts out of them.

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

*I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.*

[DoubleNation]

Perfect motivation and inspiration to automate some SAP reportings!

[johncheung]

Well, I did not see your video several years ago when I was learning python. I used VBA a lot, so I can do whatever I want with it. I tried using python on the same jobs in Excel. Yes, it can do them too. As you said, the biggest obstacle in distributing a python application is that the other user most probably does not have python installed in his computer. Thus, after learning the basics of python, trying to write a couple of games, and writing modules to solve Excel problems, I pretty much give up on python.

[noeldoller]

Thanks you again Sir Sven. I will study it now. I really need more of excel automation examples project. Especially the copy pasting different range of cells value from of different excel workbook source and into master excel workbook, I would really appreciate if you do exactly the same example project, please

[faisalag]

Thanks for sharing.
Any course that u recommended to take, to start of with python for Accountants.

[royalwinautomatedsoftware]

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

[janejane]

hi Sven, 2:57 why the column sales need to be written as df[" Sales"] instead of df["Sales"] - with and without space in front of the word Sales. What's the difference? 🤓

[angeline]

Hey, I am trying to paste the data using a data frame but then it is pasting only int/float values keeping the strings blank. Could you please help me with this

[phuppokadhabba]

Hi brother Can you help me Out?! As I want to create a data Entry Form Sheet from which data is saved of different different columns and on multiple sheets. Please guide me

[barcode]

Hi. Can you show us how to create pivot tables? Thank you

[omsangwan]

Hi Sir,

Great video.

Sir I tried using the same method but if the sheet has some blanks columns in between then how can i copy paste all the data in the sheet?

[pascalgerkensp]

Thanks for this vidéo, but I have error message when I use your code : attributeError : ´Range ´ object has no attribute ´ copy ´. Can you help me ?

[techie]

If I create an automated excel and send it to a person Z, so I just need to send ".xlxm file" ? while Z does not have xlwings installed?

[rachidbaha]

Hi Sven
How i Can refresh juste one single sheet in a workbook with several sheets . I am beginner . And for now i use pandas and openpyxl ?

[vanlapo]

can you solve that problem for me?
df = df.append(pd.read_excel(file), ignore_index = True)
FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

[ApteryxRex]

An additional disadvantage of VBA is that it is no longer being developed / improved by Microsoft. Basically, its as good now as it will ever be.

[ketuscorpion]

How can I automate an excel file which can give me daily report? Right now I download an excel file then I use vlook up to find 7 KPIs for a call center. Can you guide, sir

[amitm]

Please make VBA based automation video.

[lahcenabtil]

how to import a graph from excel to word

[sachindubey]

Videos is good bt you skip last part please make some videos to explain VBa automaion tasks with python .