Feb-01-2021, 02:24 PM
The code below does not append
Can anyone help please
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()