How Can I Loop Through And Increment The Rows In An Excel Workbook Formula In Python?

This is a continuation of the this question How can I iterate through excel files sheets and insert formula in Python? I decided to have it on new thread as its another issue. I'

Solution 1:

maybe you could just try formatting the string?

...
    row_count = 2
    for i, cellObj in enumerate(work_sheet['U'], 1):
        cellObj.value = f'=Q{row_count}-T{row_count}'
        work_book.save(os.path.join(out_folder, xlfile))
        row_count += 1