Setting Styles doesnot work,,How to fix it...python 3.x..Setting background color for cell in excel doesnot work,,

Question

fill_pattern= PatternFill(patternType='solid',fgColor='C64747',bgColor="FF0000") sheet_obj['B1'].fill=fill_pattern

for i in range(1,max_row + 1):

cell_values=sheet_obj.cell(row=i,column=2).value
     if  type(cell_values) == int  and   cell_values>=1:
            print('Inside if')
            sheet_obj.cell(row=i,column=2).fill=fill_pattern
            sheet_obj['B1'].fill=fill_pattern

            wb_obj.save("try.xlsx")

Answer 1

等待大神解答