39 Comments

1. The first 1,000 people to click this link will get a free career coaching session courtesy of Career Karma: https://rebrand.ly/tech-with-tim-51321 !!

2. As usual, very useful. Thank you!

3. Hello, my MacBook flickers pink while installing pip3 flask.login for at least 2sec.
   The problem isn't there anymore but I have fear that my Mac have hard disk or software problems now. 
   Does anyone know about this problem. I would be very thankful

4. you could use

   cell(row, column, value=None) method of openpyxl.worksheet.worksheet.Worksheet instance
   
   Returns a cell object based on the given coordinates.

   Usage: cell(row=15, column=1, value=5)

   Calling `cell` creates cells in memory when they
   
   are first accessed.

   :param row: row index of the cell (e.g. 4)
   
   :type row: int

   :param column: column index of the cell (e.g. 3)
   
   :type column: int

   :param value: value of the cell (e.g. 5)
   
   :type value: numeric or time or string or bool or none

   :rtype: openpyxl.cell.cell.Cell

   for itterating through a range of cells

5. Great content is coming

6. What is the difference between win32com and openpyxl? Which one should we use?

7. Not a fan of openpyxl , there are better ways to perform such tasks.

8. 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

9. this video is super useless, there is no reason to prefer openpyxl over pandas (related to what you showed in this vid)

10. Is there a reason to use this over pandas?

11. Great!

12. Is there a way to edit MS Word documents in this manner as well?
    I have only been able to find limited information regarding Word processing with Python. Specifically, editing certain custom template elements in Word and saving the document to PDF afterwards through Python. I want to create an interface to edit only the necessary elements, save it to PDF and then do another document automatically without ever touching Word. Because opening a Word doc editing manually and saving to PDF takes a lot of time when you have to do it repeatedly.

13. Hi!
    Thanks for the quality videos!

    Can I ask if you can follow up with integration with Pandas/ Numpy on a practical use case?
    Why can't we just use pandas to do all the required operations then write to a sheet?

14. you've pass the copying tutorial

15. Only legends know that the thumbnail is being reset

16. Thanks Tim 🙂

17. Show me something better. What has the chef made recently?

18. Ive used this library before its sooooo good

19. I have a work that recently needed this— JUST IN TIME! thank youu

20. Can u make a python automation tutorial playliat with a few projects in it, I've been trying to script but it's kinda hard to get into as for different things we need different modules and the resources are kinda hard to find…

21. Bro, please suggest a course on servers and databases.

22. Tim looks tired…

23. tnks tim its very helpfull for me.
    lov u man

24. Insert, like in excel, inserts above the row, not below. Note that A7 was moved down.

25. U da Boss

26. "Automate Excel With Python"
    VBA: Am I a joke to you?

27. I used it to extract data from different excel files

28. And as I known, very high level programmers work in C++. If you wanna change something about your "cool" python, you have to go to execution and there you'll see C++. And won't understand what's written there.

29. Yeah. Just don try to add page breaks.(rowbreaks) The damn shit doesn't work, it just corrupts the file.

30. Thank you, Tim, for yet another great tutorial.
    I personally like to use the Python library xlwings whenever I am automating Excel tasks. Xlwings supports Numpy arrays and Pandas Series/DataFrames. It even offers a way to write User Defined Functions (UDFs) in Python [Windows only].

31. I use the win32com module… Way more ability…. Openpyxl is still good though

32. Великолепно!

33. it is nice if you know python and want to jump into excel.

    if your app/programm is going to be excel heavy… better use Visual Basic for Applications (VBA) … it is the integrated programming language of excel. and i think it is faster.

    python is as well mice if you work with excel-data, which is closed.
    (although i sont know if python opens the excel sheet and closes it again).

    nice video anyway

34. 500th like! Wont wooot!

35. When would you use OpenPyXL over Pandas?

36. pandas.read_excel ?

37. Love your vids bro ❤️❤️

38. I know how to manipulate files on C++ and let me tell you, it's ALOT shorter on Python.

39. This video is full of sheets 🙂

Comments are closed.