Fastest Way to Read Excel in Python

Compare ways to read Excel files in Python.

The repo includes the source files for running the benchmarks presented in the article "Fastest Way to Read Excel in Python".

Setup

Create a virtual environment and install dependencies:

$ python -m venv venv
$ source venv/bin/activate
(venv) $ pip install -r requirements.txt

Running the Benchmark

To run the benchmark execute the following command:

(venv) $ python benchmark.py

The repo includes two Excel files:

• file.xlsx: large file used for the benchmark

• file-sample.xlsx: smaller file to use for development