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


Messages In This Thread
Recommend an Excel library for writing data? - by jonesin1974 - Feb-09-2018, 03:48 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with writing monitored data to mysql upon change of one particular variable donottrackmymetadata 3 337 Apr-18-2024, 09:55 PM
Last Post: deanhystad
  Python best library for Excel reports & review of existing code MasterOfDestr 4 760 Feb-14-2024, 03:39 PM
Last Post: MasterOfDestr
  Can anyone recommend me an ai? SuchUmami 1 748 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 1,203 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,132 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,143 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,257 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,949 Dec-12-2022, 08:22 PM
Last Post: jh67
  Issue in writing sql data into csv for decimal value to scientific notation mg24 8 3,126 Dec-06-2022, 11:09 AM
Last Post: mg24
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,757 Dec-01-2022, 01:52 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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