In this section, we are going to work with Excel files, which have the .xlsx extension. This file extension is for an open XML spreadsheet file format, which is used by Microsoft Excel.

Python has different modules: xlrd , pandas, and openpyxl to work with Excel files. In this section, we will learn how to handle Excel files using these three modules.

First, we will look at an example using the xlrd module. The xlrd module is used for reading, writing, and modifying Excel spreadsheets and doing a lot of work.