Python Forum
Write data into existing Excel (xlsx) file with multiple sheets
Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Write data into existing Excel (xlsx) file with multiple sheets
#2
you are using xlrd which only reads excel files.
you need a difference package to write to one.

Most people suggest pandas for both read and write,
I haven't had the need to use it.
Reply


Messages In This Thread
RE: Write data into existing Excel (xlsx) file with multiple sheets - by Larz60+ - Jun-01-2017, 04:22 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Pandas keep existing format of Excel AlphaInc 2 1,323 Jan-11-2024, 03:44 AM
Last Post: plonkarchivist
  How to count total number of sheets in an excel workbook using polars sayyedkamran 0 721 Oct-27-2023, 09:54 PM
Last Post: sayyedkamran
  Errors if an xlsx file has blank rows in the beginning…. tester_V 1 881 Aug-28-2023, 06:22 PM
Last Post: deanhystad
  Write from dictionary to excel divon 3 4,057 Jun-11-2023, 10:37 AM
Last Post: Larz60+
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,088 Jan-09-2023, 08:14 PM
Last Post: PY_ALM
Smile How to further boost the data read write speed using pandas tjk9501 1 1,303 Nov-14-2022, 01:46 PM
Last Post: jefsummers
  Split excel file and write output at specific row and set sheet position DSCA 0 2,040 May-12-2022, 07:29 PM
Last Post: DSCA
  Help with poorly formatted excel data armitron121 1 1,760 Jan-13-2022, 07:31 AM
Last Post: paul18fr
  Exporting data frame to excel dyerlee91 0 1,659 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  [Pandas] Write data to Excel with dot decimals manonB 1 5,975 May-05-2021, 05:28 PM
Last Post: ibreeden

Forum Jump:

User Panel Messages

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