Python - how to read contents of an excel file

Question

xlapp = Dispatch("Excel.Application")
wkbk = xlapp.Workbooks.Open(filename)

This procedure is used to read an excel file, however, I'm unable to access the content. Can somebody give me some advice on how to manage this better?

Answer 1

xlwings is an excellent library to interact with Excel files from Python.

Opening, reading, and writing to Workbooks are as easy as:

>>> from xlwings import Workbook, Sheet, Range, Chart
>>> wb = Workbook()  # Creates a connection with a new workbook
>>> Range('A1').value = 'Foo 1'
>>> Range('A1').value
'Foo 1'

You can install it using:

$ pip install xlwings