Hi all,
I have a demo about calculated each score with target gap as attached, formula is : ='Log'!C3-'Log'!C$2, ='Log'!C4-'Log'!C$2, ='Log'!C5-'Log'!C$2,and stored result in sheet Demo by each row executed .
Actually use formula is ='Log'!C3-'Log'!C2,how to change to except functions(='Log'!C3-'Log'!C$2),any comment will be appreciated!
I have a demo about calculated each score with target gap as attached, formula is : ='Log'!C3-'Log'!C$2, ='Log'!C4-'Log'!C$2, ='Log'!C5-'Log'!C$2,and stored result in sheet Demo by each row executed .
Actually use formula is ='Log'!C3-'Log'!C2,how to change to except functions(='Log'!C3-'Log'!C$2),any comment will be appreciated!
import openpyxl from openpyxl import utils wb=openpyxl.load_workbook("summary.xlsx") ws=wb['Demo'] ws1=wb['Log'] min_row=ws.min_row max_row=ws.max_row min_col=ws.min_column max_col=ws.max_column min_row1=ws1.min_row max_row1=ws1.max_row min_col1=ws1.min_column max_col1=ws1.max_column print(min_row,max_row,min_col,max_col) print(min_row1,max_row1,min_col1,max_col1) for row in range(min_row+1,max_row+1): for col in range(min_col+1,max_col+1): key=ws.cell(row=row,column=col).coordinate start=ws.cell(row=2,column=col).coordinate end=ws.cell(row=row+1,column=col).coordinate print(type(end)) print(end) ws[key]=f'={utils.quote_sheetname(ws1.title)}!{end}-{utils.quote_sheetname(ws1.title)}!{start}' wb.save('summary.xlsx')