xlrd, xlwt - Handling Excel Data with Python¶

Python makes it easy to process a lot of data in Excel files.

xlrd and xlwt are libraries used to retrieve data from Excel files or to save (generated or processed) data back to Excel files using Python.

More information about xlrd and xlwt can be found in the official document below.

Install xlrd, xlwt¶

xlrd and xlwt are included by default in anaconda. If not already installed, refer to the following.

pip install xlrd

conda install -c anaconda xlrd

At the command prompt, use the above command to install xlrd.

pip install xlwt

conda install -c anaconda xlwt

At the command prompt, use the above command to install xlwt.