+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Recommend an Excel library for writing data? (/thread-8208.html)
Recommend an Excel library for writing data? - jonesin1974 - Feb-09-2018
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
RE: Recommend an Excel library for writing data? - Gribouillis - Feb-09-2018
(Feb-09-2018, 03:48 PM)jonesin1974 Wrote: it states that it is for Excel 2010I 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.