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
  Copying Data from Multiple XLS Files to a Cumulative Master File Martijn 3 1,346 Apr-05-2025, 05:07 AM
Last Post: Pedroski55
  Pandas keep existing format of Excel AlphaInc 2 11,808 Jan-11-2024, 03:44 AM
Last Post: plonkarchivist
  How to count total number of sheets in an excel workbook using polars sayyedkamran 0 1,519 Oct-27-2023, 09:54 PM
Last Post: sayyedkamran
  Errors if an xlsx file has blank rows in the beginning…. tester_V 1 1,632 Aug-28-2023, 06:22 PM
Last Post: deanhystad
  Write from dictionary to excel divon 3 13,725 Jun-11-2023, 10:37 AM
Last Post: Larz60+
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,751 Jan-09-2023, 08:14 PM
Last Post: PY_ALM
Smile How to further boost the data read write speed using pandas tjk9501 1 2,157 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,880 May-12-2022, 07:29 PM
Last Post: DSCA
  Help with poorly formatted excel data armitron121 1 2,406 Jan-13-2022, 07:31 AM
Last Post: paul18fr
  Exporting data frame to excel dyerlee91 0 2,200 Oct-05-2021, 11:34 AM
Last Post: dyerlee91

Forum Jump:

User Panel Messages

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