如何改进这个脚本。在openpyx中将一列除以3

Question

寻找一种简化列划分的方法。有我可以使用的循环吗？你知道吗

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

这只是其中一种可能性。你知道吗

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

请注意，range的工作方式如果您希望包含数字10，则需要确保传入11。你知道吗