changes to cells not saving to new file
Hi. Sorry to bother. But I'm trying to change the contents of cells. This seems to occur. But when I save the file, none of the cell changes appear. Here is some sample code:
import openpyxl
f1 = "file_BASE.xlsx"
f2 = "file_2.xlsx"
f1_wb = openpyxl.load_workbook(f1)
sheet = f1_wb.active
f2_wb = openpyxl.load_workbook(f2)
f2_wb.active = f2_wb.get_sheet_by_name(name = f2_wb.sheetnames[2])
sheets = f2_wb.active
sheet['J5'].value = 3
f1_wb.save('testxxx1.xlsx')
(I'm opening two spreadsheets to gather information from both and place into a third)