Python Forum
Append excel sheet using openpyxl
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Append excel sheet using openpyxl
#1
The code below does not append
Can anyone help please

from openpyxl import load_workbook
workbook_name = '/home/pi/Desktop/Data/Test.xlsx'
wb = load_workbook(workbook_name)
page = wb.active
import openpyxl as op
Col1 = 'Apples'
Col2 = 'Pears'
wb = op.load_workbook(workbook_name)
ws = wb[wb.sheetnames[0]]
ws.append([Col1, Col2])
wb.save(workbook_name)
wb.close()
Reply


Messages In This Thread
Append excel sheet using openpyxl - by TammyP - Feb-01-2021, 02:24 PM
RE: Append excel sheet using openpyxl - by nilamo - Feb-02-2021, 06:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  openpyxl issue - How to reset sheet.ins_row to the real last row ... ejwjohn 6 701 Nov-08-2023, 01:19 PM
Last Post: ejwjohn
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,693 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Excel Automation using Openpyxl pradyumnajpn 1 771 May-16-2023, 09:38 AM
Last Post: Larz60+
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,507 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Openpyxl manipulate excel write formula SamLiu 0 1,002 Nov-04-2022, 03:00 PM
Last Post: SamLiu
  openpyxl rename sheet acting strange Pedroski55 1 1,841 Sep-26-2022, 08:56 AM
Last Post: buran
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 6,852 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Python script for excel sheet Nabil 4 3,221 Jun-01-2021, 05:09 AM
Last Post: Pedroski55
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,190 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  How to append a value to specific excel cell using openpyxl hobbyist 0 4,761 Mar-05-2021, 07:14 PM
Last Post: hobbyist

Forum Jump:

User Panel Messages

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