1, 3, 5, 7, 9列の10行目までを灰色に塗りつぶす import openpyxl from openpyxl.styles import PatternFill filename = 'test.xlsx' wb = openpyxl.load_workbook(filename=filename) ws = wb.active for column in range(1, 10, 2): for row in range(1, 11): ws.cell(row, column).fill = PatternFill(patternType='solid', fgColor='d3…