Paul's Programming Notes PostsRSSGithub

Python Excel Library Benchmark Comparison

I used swistakm’s python-excel-benchmarks to compare write speed across the Python Excel libraries:

benchmark_csv                  0.026495
benchmark_excellent            1.784107
benchmark_openpyxl             2.897072
benchmark_openpyxl_rows        7.025895
benchmark_pyexcelerate         0.550225
benchmark_xlsxcessive          1.430242
benchmark_xlsxwriter           1.611668
benchmark_xlwt                 1.275144

xlsxwriter’s Working with Memory and Performance page has its own comparison:

pyexcelerate          :  10.11
xlwt                  :  15.67
xlsxwriter (optimised):  19.70
xlsxwriter            :  23.50
openpyxl   (optimised):  95.82
openpyxl              :  95.90