Automate Your Excel Tasks Using Python

[@CodingIsFun]

*Want to spice up your spreadsheets with emojis 🤪? Check out my add-in:* pythonandvba.com/emojify Also, you can find the code from the video here: github.com/Sven-Bo/Automate_Excel_Using_Python Happy Excelling and automating! Cheers, Sven ✌

[@AiltonBarreto]

Thanks for the video man! you're amazing, I made a webapp to my job from a idea I watched on your channel. Regards from Brazil!!!

[@CodingIsFun]

That's really cool to hear. Comments like this motivate me to create more videos. Happy coding! Cheers, Sven ✌

[@sitrakaforler8696]

Hooo dam so...this is the FUTURE !!!! Imagine the financial world finally using python rather than VBA hahah bref, great vidéo man ! (regards from Luxembourg :p

[@CodingIsFun]

Hi Sitraka, thanks for watching! Yeah, I'm not sure if that would replace VBA tbh 😅 One of the biggest issues with a Python solution for office automation, at least in my opinion, is that you need to have Python installed. This can be problematic in larger corporations where installing Python might not be allowed, or when you want to distribute your solution, as the recipient also needs to have Python installed on their machine. VBA has the advantage of being integrated into Office/Excel, making it much easier to distribute your solutions. That said, if you're just looking to automate your own tasks and have access to Python in your work settings, xlwings can be a great option as shown in the video 😉 Greetings to Luxembourg. Cheers, Sven ✌

[@rogeryang18]

Hi Sven, this is great! But my question is that Power Query with M is built in Excel and it can easily and dynamically automate Excel. It can automate the job in this video easily too. What are python's advantages over PQ in terms of Excel automation?

[@edsonrodas3954]

Really good content, thanks for sharing.

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌

[@sujungpark5764]

It is amazing ! You help me always thank you :))

[@CodingIsFun]

Glad to hear that! Cheers, Sven ✌️

[@christianmller7330]

Hey, great video! I have to automate a lot of tables from excel to word. I have to create a docs for every firm, and there is a lot, and would like to automate it, do you have anything on that? The tables will be placed around text in the docstemplate.

[@CodingIsFun]

Glad to hear you liked the video. Regarding your the Excel/Word automation, check out the following video: kzbin.info/www/bejne/kKqcpKtqfNudi7s I hope it helps! Happy Automating! Cheers, Sven ✌️

[@AyieMedia]

Can you create google maps data scraper using pyqt6 using proxies to avoid ip blocking

[@CodingIsFun]

Thank you for watching the video & your suggestion!

[@Bolamagica59]

Is it possible to install and use xlwings on mac os?

[@CodingIsFun]

Thanks for watching. Yes, xlwings also works on macOS. Happy coding! Cheers, Sven ✌️

[@MdMilonMahamud-lb7it]

I want to learn Python for excel and Google sheet automation. is it demanding for freelancing in future?

[@CodingIsFun]

Honestly, I can’t predict the future, but Python for Excel and Google Sheets (or App Scripts) is super useful. I didn’t do much freelancing before KZbin, but since starting it, I’ve had quite a few requests. If you’re thinking about freelancing, maybe share your work online and try some freelance platforms. Good luck! 🍀 Cheers, Sven ✌️

[@MdMilonMahamud-lb7it]

@CodingIsFun So many thanks

[@SolutionsByPVV]

Beautiful design theme in VS code! Which one ?

[@CodingIsFun]

Thanks for watching. I am using "Cobalt 3". Cheers, Sven ✌️

[@valentinstanescu2683]

Why not using VBA directly??

[@CodingIsFun]

You can :) Here is my opinion on that: kzbin.info/www/bejne/fZa7YZprj89nh9U Cheers, Sven ✌️

[@glassbottle15]

i have no skin in this game, but i guess if someone is good with python, and haven’t used vba before could be one situation 🤷

[@stefankleinhans4895]

@CodingIsFun - I am hooked on you vidoe's, during my time learning Python. I am hoping you can help in showing us how to use Python to create an app to run and copy data from one excel to another. The one file is the transaction that will have new data. the 2nd or main file has all the history data and needs to be amended with the new data. also the columns are going to different column. For instance File1 - Sheet1 - Column A must go to File2 - Sheet1 - Column B. Or can you guide me on where I can get the how to videos somewhere.

[@CodingIsFun]

Thanks for watching my videos. I'm happy to hear that you find them useful. I already have many tutorials on copying data from one sheet or workbook to another. Have a look at my playlist here: kzbin.info/aero/PL7QI8ORyVSCb8UtcXlGkdz1miYKHWCA1j The code you find may not always match your exact use case but could be a good starting point. For extra guidance or adjusting the code, you can always try getting help from ChatGPT as well :) I hope this helps! Happy coding and learning! Cheers, Sven ✌️

[@andiglazkov4915]

Thanks

[@CodingIsFun]

You're very welcome! Thank you for watching! Cheers, Sven ✌️