Feb-01-2021, 02:24 PM
The code below does not append
Can anyone help please
Can anyone help please
1 2 3 4 5 6 7 8 9 10 11 12 |
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() |