Python Forum

Hi all,

Can anyone recommend a Python library to create Excel files?

Aside from writing the actual data, my only other requirements are:
1. Make the text Bold in a specific cell.
2. Change the background cell colour.
3. Auto-fit a column.

A lot of people are recommending openpyxl. But looking at their documentation https://openpyxl.readthedocs.io/en/stable/ it states that it is for Excel 2010 and I don't want to limit myself to one version.

Kind regards,
John

(Feb-09-2018, 03:48 PM)jonesin1974 Wrote: [ -> ]it states that it is for Excel 2010

I think it's only a file format. Openpyxl writes .xlsx files that can be opened by later versions of excel and also libreoffice or openoffice.