How to improve this script. Dividing a column by 3 in openpyxl

Question

Looking for a way to simplify the division of a column. Is there a loop I can use?

from openpyxl import load_workbook

xfile = load_workbook('camdatatest.xlsx')

sheet =xfile.get_sheet_by_name('Sheet1')

sheet['D2'] = '=C2/3' # Want to divide all values in Column C with the new value in D.
sheet['D3'] = '=C4/3'
sheet['D4'] = '=C5/3'
sheet['D5'] = '=C6/3'
sheet['D6'] = '=C7/3'
sheet['D7'] = '=C8/3'
sheet['D8'] = '=C9/3'
sheet['D9'] = '=C10/3'




xfile.save("camdatatestoutput.xlsx")

Answer 1

This is just one of the possibilities.

for i in range(2,11):
    sheet['D{}'.format(i)] = '=C{}/3'.format(i)

Notice that the way range works if you want the number 10 to be included, you need to make sure to pass in 11.