-
Book Overview & Buying
-
Table Of Contents
Python Automation Cookbook - Third Edition
By :
MS Office is by far the most common office suite software, making its formats pretty much the dominant standard. MS Excel is probably the most common spreadsheet application, and the Excel format is the most common spreadsheet format, forcing many other spreadsheet applications to understand the format.
In this recipe, we'll see how to obtain information from an Excel spreadsheet using the openpyxl module in Python.
We will use the openpyxl module. We should install the module, adding it to our requirements.txt file as follows:
$ echo "openpyxl==3.1.5" >> requirements.txt
$ uv pip install -r requirements.txt
In the GitHub repository there's an Excel spreadsheet named movies.xlsx that contains information on the top 10 movies by attendance. The file can be found here: https://github.com/PacktPublishing/Python-Automation-Cookbook-Third-Edition/blob/master/ch06/movies.xlsx.
(The source of the information is: http://www...