Read from Excel Files using Python 3 (xlrd) | Automate Excel #1



In this python3 tutorial, I’ll show you how to read data from excel files (.xlsx) by using the xlrd module.

Automate Excel Playlist:
Pip Installation Tutorial:

Subscribe to Code For Humans:
Support us on Patreon:

source

30 thoughts on “Read from Excel Files using Python 3 (xlrd) | Automate Excel #1”
  1. This is SOOO underrated. It is perfectly to the point and does exactly what I needed. Thank you so so much. I haven't seen any of your other videos, yet. I'll have to go check them out!

  2. Thanks your for this video! I get an error when I run the code – what did I do wrong. On line to_print_date = datetime.datetime(*converted_date).strptime('%m/%d/%Y') I get TypeError: strptime() takes exactly 2 arguments (1 given)

  3. When I try to open the workbook through "xlrd.open_workbook(path)" it says that Excel xlsx file is not supported, but your clearly using a xlsx too so why isn't mine working?

  4. 🙁
    AttributeError: 'ElementTree' object has no attribute 'getiterator'
    AttributeError: 'ElementTree' object has no attribute 'getiterator'
    AttributeError: 'ElementTree' object has no attribute 'getiterator'

  5. Whenever I try to install by pip there is always some error, I downloaded xlrd from pypi, but I am not able to install it
    cd Desktop
    Path of the module

    I am not sure what I am doing wrong can you assist or please make a video for offline module install

Leave a Reply

Your email address will not be published.

Captcha loading...