Automate Excel With Python - Python Excel Tutorial (OpenPyXL)

[@TechWithTim]

Start a high paying tech career making $60k+/year with NO DEBT: coursecareers.com/a/techwithtim

[@victor20214]

And support. Thanks tim

[@realitynowassigned]

What kind of keyboard are you using. I miss those clicks

[@anandsharma2516]

I think some bug is there not accepting the mobile number or land line no. with & without the city code and country code. Or a fake one

[@ardit9988]

🇬🇧🇽🇰🌟🌟

[@Bart_Depestele]

Did you love yourself amigo? :)

[@VladArnoldner]

I am working as a Senior Financial Officer dealing with financial reporting. This video gives me a new powerful tool to quickly manipulate and process a large volume of data. I think I will surprize my boss with my new skills! Thank you, Tim!!!

[@SwahiliSpicE]

I'm a tax accountant, this is exactly what I've been doing for the past couple of years. Bringing in so much value to the business, and plugging the cash leakages using coding skills, you get taken more seriously.

[@thefitfrontier]

@@SwahiliSpicE the excel docs are created from your ide or within excel? seems VS code will not bring in excel file created in excel?

[@martinkuliza]

You can do the same thing if you use SQL except the SQL C.L.I. is going to be easier to bring up a sheet and view it entirely , You just use the SHOW command perhaps also look into that i reckon there's a time and place for SQL CLI and a time and place for Python with Excel Python as a programming tool is unbelievable , to do financial analytics , Sure. But someone has to write the script to achieve your goal Excel is also good for that as well as importing data from external websites and databases but python is certainly more powerful than excel so.. Time and place for everything

[@NextManu]

recently got into learning python. my mind is blown with the versatility of python. I now wish i had done software engineering back in school..

[@derekwest8636]

New to python and starting my own project working with excel files. Tried to go through the documentation for openpyxl and was wasting alot of time learning unnecessary information based on what I was trying to accomplish. You've done a wonderful job with this and I was able to easily follow along and experiment along the way. Put together a py file for my notes on this module. Tim is Great!

[@gl4989]

Boomers at my work will now treat me as a god

[@salsabilahmedshrestho960]

I am at my final year, and just got to know about automation and how seniors don't know it. :v I also wanna feel how you said 😂

[@girishbhoite264]

🤣

[@mienzillaz]

No, they won't

[@videofandude99]

for a quick minute until they start doing themselves to save their jobs

[@Mr.Blumister]

Actually it is exactly like that! :D

[@boldtecmedia3003]

exactly what i needed, im a civil engineer and learning python. i was coding a building cost estimator desktop app in tkinter and needed python after calculating all materials for me, it should also create an excel workbook and type those results for me. so that i simply print out for the client in the shortest time possible. awesome video. thank you sir. im a complete beginner though, any one with a better way of doing it is welcome

[@tonyvelasquez6776]

Python is probably the best way to do that. I don't think you necessarily need tkinter though

[@furkankilicaslan]

Hi, I am an industrial engineer and currenly looking for ways to automate the process of some report that we do in excel. tkinter might be a good idea for people that don't have the expertise or the knowledge of python cause they are just going to use the interface. hope you get what you want. Really appreciate if you reply the result if you finish the project. You should try KNIME too. Good luck. Cheers!

[@lilrex2015]

This is quality stuff. This guy gets how to make a good tutorial video. No wasted time, points are explained enough to understand then moves on.

[@chaitanyakolluri2839]

Hands done one of the best Python training videos out there I’ve. Method of instruction, clarity and examples are brilliant. Thank you so much.

[@pythonenthusiast9292]

to those who are thinking @6:52 that you can directly open the workbook or directly save the workbook using that load_workbook command.. no ppl.. you need to first make or upload a workbook at the location of your text editor or some random location then take that location from there .

[@manndipp]

by far, the best video for starting excel with python

[@TheNameIsForty]

Actually did something similar a month ago, where I converted the excel file in to base64 in the end and sent it through an API to then generate it back into xlsc format through typescript. PyXl is amazing btw, anyone who watches this should try it. Very easy to use.

[@preisback24]

I've been learning Python by following a book and got confused and stuck for so long until I found this video. Thanks

[@MrSuspicious0]

For anyone like me who finds the lettering system tedious and annoying, rather than using the get column letter function you can just use sheet.cell(1,1) for example which would be cell A1, but I think this is nicer especially if youre using nested for loops.

[@ignoble_hierarch]

Thank you! So, to stick more to the tutorial, it will be like *ws.cell(1, 1).value = "Type something"*. By the way, you have a similar reference system in VBA as well.

[@PolytecGuy91]

thats the way to handle columns greater than "26" also.

[@dbdejonge2081]

Char(64+column number)

[@stevemorse5052]

As Tim noted, you cannot save the spreadsheet changes if it is opened in Excel (or in my case, Libre Office) for 'normal' use. I did figure a sort of workaround to this problem. If you open the spreadsheet as read only, your python code will run without a problem. Now to view the changes simply reload the spreadsheet. The reload command in Libre Office can be found under File >>> Reload (or press the keys Alt, f, l in that order(Note l is lowercase L)) Yes, you have to remember to reload the spreadsheet every time you make a change, but it is quicker than the close, reopen way, you could put a reminder in your python code. Note, if you want to edit the read only open file, there is a button on the top right that says Edit Document. but remember after editing it needs to be saved and reopened as read only. Use the python command try when doing a workbook save, and if it throws and exception, then ask the user to go through the close/reopen read only routine.

[@contra_plano]

Libreoffice Rocks

[@omuk4584]

Who the heck is this guy!! Just amazing trainings and super easy to follow along. Keep them coming Tim, much appreciated.

[@JourneeDecker]

Clear, rich, concise and well delivered. Thanks!. Clear, rich, concise and well delivered. Thanks!.

[@addledanorak8297]

Was waiting for such a vid for soooo looooong. Thx Tim :)

[@UltraProbe]

Haha ikr. I learned a bit of Openpyxl for a script I run everyday, but this should let me do some more interesting stuff ;)

[@Global-Geographics]

You are a life saver dear, the way you teach is the best

[@sandragraham8289]

This strategy is bomb!!! I won 3/4 just testing it out!!! Thank you for sharing!!

[@roccov3614]

As someone who loves Excel and is learning and loving python, I think this module is awesome.

[@CrypticConsole]

Than look at pandas

[@roccov3614]

@@CrypticConsole I new pandas dealt with data. I didn't know it could access Excel docs. Thanks.

[@duzyolek]

I started the transition from VBA to python+OpenPyXL around 2 weeks ago (after years of experience with VBA) and there it is - Tim's video about this very topic!

[@micheleluigimelis426]

Why did you decide to change? What are the benefits of using Python in this case?

[@Bayo106]

@@micheleluigimelis426 way less code

[@haroldgamarra7175]

@@Bayo106 not having to declare variables to begin.

[@deninsrmic4165]

@@Bayo106and less intelligible than Visual Basic, I accomplishes so much via VBA in all Microsoft applications, disliked python syntax from day one but being coerced to learn it due to job requirements. I am still on the learning path and still like visual basic syntax more.

[@Kitejrpaladin]

For anyone reading there are random real-world use-cases for stuff like this on occasion, I recently did something similar with Word and Powershell. In my case, I would take data from a CSV and generate a document containing stuff like login information, Employee IDs, etc. It can save time when you are doing 25+ of these documents.

[@michaelmessiha1281]

why powershell?

[@davewiebe2582]

I use powershell alot, it does alot of the same things python does and it's integrated into the OS

[@Kitejrpaladin]

Pretty much for the reasons Dave described. When in Rome, do as the Romans do. For general purpose stuff like this in Windows environments, PowerShell is the better tool for the job, not because it's better than Python or anything silly like that but because it's the lingua franca of Windows and has plenty of cmdlets to deal with the tasks you'll run into in a Windows environment but just as importantly the people I work with have a better chance of understanding my code if it's in PowerShell vs Python. For a more specialized task maybe I dip into the .Net APIs using PowerShell (use the native PowerShell solution first as best practice) or pull out C# in a Windows Environment. To choose an example where I would definitely prefer Python is anything in the Data Analytics or Machine learning world. On the operations side if you ever need to deal with networking equipment, the community has built some really good libraries for automating working with routers and switches. Network Automation and SDNs are a thriving space in Python. I actually tooled around with some Unifi stuff in Python while trying to automate performing resets of multiple Unifi Access Points. (Didn't really work out but learned a bit)

[@nickyfranshel1210]

pains of suffering of reading stackoverflow of excel automation and alien language has come to an end 😌

[@expat2010]

This is a good example of why I love Python even more than VBA. It is so intuitive and readable compared to most other languages.

[@yugiohfanatic1964]

totally false statements. Nice try simp!

[@akankshc5707]

this is a whole another lvl. of automation with python

[@Mr.Blumister]

Bruh! You literally made me safe countless hours of work at my job! Lovin' it

[@TechWithTim]

Glad I could help!

[@dmitryg9613]

man, I really appreciate your work and time spent on explanation. I would never sort it out without your help

[@simoneriksson548]

Awesome video Tim! Ive struggled a bit with python and definently had some 'aha!' oments watching this! Keep up the good work!

[@ianbraganza3065]

Thanks for a great video. It helped me automate several redundant tasks and opened my mind to the power of openpyxl

[@jewelsoncagakit8423]

Wow ! All the basic fundamentals are packed in one demo ! Thanks Tim !

[@CarlFritz24]

AMAZING, Tim. The best demonstrated matter I have ever seen.

[@aungphyo9237]

The best video about openpyxl. It is helpful for me a lot.

[@MaxRuso]

the posibilities and list of errors is so good as it helps

[@relhage100]

Clear, rich, concise and well delivered. Thanks!

[@rishabhtripathi593]

Thank you for this, it helped me a lot for an college assignment < 3

[@someone...000]

I expected this to be as easy as working with the csv module, but obviously it isnt, and now that i think about it, why would it be. Nevertheless, this video help me understand it even more than i understand the csv module, from installing OpenPyXL, to formulas and cell styling. Great video Tim! Thanks for all that you do for us python noobies☺

[@titojulyharyanto3397]

Thank you so much Tim for sharing this. God bless you and all the best for you

[@hubertkarwowski1646]

The best tutorial video about python excel I have ever seen $.$

[@kychemclass5850]

Tim. Could you do an equivalent video Automating LibreOffice Calc ?? It would be fantastic. I'd even give a reasonable financially contribution for the effort.

[@khytron06]

19:00 why not just do for row in range(1, 11): for col in "ABCD": print(ws[col + str(row)].value)

[@deanlawson6880]

Excellent run-through of this. Very cool to be able to interact with Excel spreadsheets in Python! Thanks for this - Nicely done!

[@scoopiezz]

i liked ur comment cause it had no likes. It a lonely comment

[@haikamu7178]

Very good, now i'm not tired for some accounting work.

[@oliesting4921]

Awesome, was searching for this. Next up, extract data from table in a PDF file, please :)

[@notyaniecetv]

Oooh yes!!

[@romanval69]

The python package "Camelot" can already do this.

[@realitynowassigned]

Thank you for the install error explanations. Thats something most videos lack

[@hemalpatel9708]

It helped for creating ustom excel file from python! Thanks a lot

[@tridibbiswas3361]

Thank you Tim for the video. Its helpful for people like are in the process of picking up the rudiments of python. Could you do a video about OpenPyXL + Pandas. How these two work together and what are the pros and cons of using openpyxl and pandas on their own

[@AnilKumar-bh4vt]

Using python for sheets is very helpful,I use it on a regular basis

[@e555t66]

Fastest way to get started. Let's go.

[@seamushand8439]

Thanks Tim. What are the advantages in using Python rather then VBA ?

[@Balgalw]

Tim, thanks a lot for detailed video. Simply the best way to use Excel formulas with get_column_letter, can't figure it out myself

[@ShivanshKaran]

Would you please mention which font face are you using?? Thanks for answering 🙂🙂

[@MassimoCLI]

Congrats, great presentation. Got very interesting points. thanks

[@joeyzalman8254]

very clear thank you!

[@forzahorizon4eliminator206]

thanks i will come back for more i need to watch the full video. but yes i admit you helped me with what i wanted thanks brother

[@lionelnishan5623]

Great Tutorial Tim :) one suggestion: To open the excel file you created or working on, instead of going to the designated folder and find the file, you can just open it from the project tree.

[@strydomobile]

You are really talented in carrying information across. Thanks for this video.

[@TechWithTim]

Appreciate the comment :)

[@123456789mumbai]

Thanks you so much for explaining in so detail and easiest way. Thanks a lot ❤

[@inspired4more]

I love Python, but Excel already has VBScript built in. In my work, I haven't had many cases where the python add in was more useful than writing my own macros in VBScript. It's not all that hard a language to learn anyway.

[@KaosDragonLOC]

I loved the video and would love a tutorial doing the reverse of the last project showing how to take a workbook and use that information to create a dictionary out of it

[@bailiojaycee233]

Sometimes if you pause an ad it skips it. (I don't know about others but that works for me)

[@Вавилон-й5у]

dude. this is sooooooo helpful, thank you

[@zukofire6424]

this was very helpful for my internship (at a messy start up)! Thank you so much Tim!!

[@cabechomp]

Great video, it helped me a lot with a project that i have and i only knew how to work with CSV files that didnt helped me at all. Thank you

[@blackchristiangeek]

Awesome tutorial and my only frustration is time limitations to apply all that you have shared. Thanks, and God bless

[@topfundus1093]

Sehr gut! Danke! Viele Grüße aus Deutschland!

[@unpatel1]

Thank you for this great intro!!

[@alangodoy9591]

the master has spoken

[@dlo009]

Thks for the intro. Great vid.

[@watchingwolf8092]

No video needed just the code with good comments in them 😇

[@yadhua334]

When you save a workbook, is there a way for the calculations in the workbook to be executed so that the next time you run it you get the newly calculated values based on any new inputs without actually opening the excel file. I have tried using the formulas library for this. But I am running into problems with complicated calculations. I was wondering if there was another way to do this. Thanks!

[@GrahamSEdwards]

What are the advantages and disadvantages of using Python to automate Excel when compared to using Excel VBA? (By the way, you've created an excellent tutorial. Well done.)

[@cesarvip75]

That is an excellent question. It is good to have an alternative, but i believe that that Excel VBA offers more advantages specially in terms of ease of use.

[@tenshi_tries]

I have a work that recently needed this--- JUST IN TIME! thank youu

[@Salmankhan-qt8uy]

Can u help me with the scenario u have in ur work. Thanks

[@rostamr4096]

wow...this is so very helpful...Thank you

[@DevGuedes]

I'm From Brazil!!!!! Perfect Video!!!!

[@Mario3cush]

Great video. Super useful. Thanks, Tim!

[@binaprajapati7709]

Hey man, give the date for your next stream

[@capincrunch1184]

Bruhhhh needed a video like this 4 months ago

[@ciccychen5911]

Thanks for the video, how did sublime text open in python 3.11? how to make it run in sublime text?

[@cantwaitforit]

Cool video! I didn't think that it is so easy(thanks man who make this library). After this video, it's obligatory to subscribe.

[@VredesbyrdNoir]

Man, you can do a lot of sheet with Python these days!

[@joen5000]

A very good video. Thanks Tim. I think that you could have saved some time in this video, if you would have added a close, open excel file function within the Python code, and would have called it up each time you test your code. That way, it would close that particular file, save it and reopen it automatically without you needing to do it manually, as you did in this amazing video. Lemogan

[@nocodenoblunder6672]

Opening a file is easy obv but dont know how you close a file cause once its open the application itself is usually responsible for this

[@testuser8977]

Is it better to use Python to do this or the built-in VBA in Excel?

[@jgostling]

Good video. Straight to the point. One question, if my Excel is in a language other than English, do I have to write the formulas in the language for my Excel installation or in English? This could potentially present a hurdle with the distribution of python programs to users.

[@AnthonyVandenberghe]

Hi, copy paste from the documentation: NB you must use the English name for a function and function arguments must be separated by commas and not other punctuation such as semi-colons.

[@jgostling]

@@AnthonyVandenberghe So the same function "text" would work in any locale. Thanks!

[@mrtyecee]

Your videos are straight 🔥🔥🔥🔥 as a programming newbie I'm learning alot from you. Thanks for all you do!

[@tibiavram]

Thanks a lot, Tim. Could you please share your cheat-sheet?

[@victoriaweilei3949]

Great tutorial video, Thanks! I would like to know whether openpyxl can insert an object and display it as an icon in excel sheet?

[@sharongur64]

Most educational thank you Tim !

[@bujeshm3736]

Thank you brother ❤❤❤

[@Shibu11229]

Great video. Is there any way python can be used to control Google Sheets or Libre Office Calc the same way you control Excel 2010 or later?

[@MrJonas1995]

Great video! Well explained!

[@murilosilvestre7736]

This video was a blessing to me, Thanks very much!

[@shinichi9do]

Crystal clear. Thank you.

[@Chris_AR1]

Nice video! Great for a beginner to get comfortable with Python and Excel

[@sinaalizadeh1]

Thank you for your great explanations ❤️

[@robertlaplante8812]

Great video! It helped me a lot starting in Python! Many thanks!

[@RaviKumar-ck4zw]

Hi Tim , I am new to learning python could you please tell me from which playlist I have to start to watch video and how ahead to step by step .

[@berghoutcful]

Great work! Thank you for this! Subscribed!

[@vigneshsrinivasan3914]

Great work. Good to get started.

[@thairston1]

peg = {"Tie":1, "Noah":2, "Ma":3, "rye":4, "Law":5, "shoe":6, "Cow":7, "ivy":8, "Bee":9, "Toe":10} Using the "input function" how would a user call a value to get a key.

[@mihaiioc.3809]

imagine your informatics teacher call you stupid for not knowing excel and making this as my next homework assignment couldn't be me