Python Forum
Recommend an Excel library for writing data?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Recommend an Excel library for writing data?
#1
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
Reply
#2
(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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python best library for Excel reports & review of existing code MasterOfDestr 4 493 Feb-14-2024, 03:39 PM
Last Post: MasterOfDestr
  Can anyone recommend me an ai? SuchUmami 1 631 Jan-04-2024, 01:30 PM
Last Post: gulshan212
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 984 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 1,922 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,046 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  googletrans library to translate text language for using data frame is not running gcozba2023 0 1,162 Mar-06-2023, 09:50 AM
Last Post: gcozba2023
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,797 Dec-12-2022, 08:22 PM
Last Post: jh67
  Issue in writing sql data into csv for decimal value to scientific notation mg24 8 2,869 Dec-06-2022, 11:09 AM
Last Post: mg24
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,615 Dec-01-2022, 01:52 PM
Last Post: deanhystad
  Appending a row of data in an MS Excel file azizrasul 3 1,138 Nov-06-2022, 05:17 PM
Last Post: azizrasul

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020