Day: September 16, 2021

i have this line to set the background color of a cell but instead of the color i specified it set the cell to black.

Tried with diferent colors to check and it always set it to black.

why is that and how to fix it?

ws['A1'].fill = PatternFill(fgColor="7FFFD4", fill_type="solid")
ws['A1'].fill = PatternFill(start_color="8a2be2", end_color="8a2be2", fill_type="solid")
ws['A1'].fill = PatternFill(start_color="8a2be2", fill_type="solid")
ws['A1'].fill = PatternFill(bgColor="7FFFD4", fill_type="solid")

Anyone know why this is not adding borders to my sheet?

        thick = Side(border_style="thick", color='FF0707')
        ws['F1'].border = Border(top=thick, left=thick, right=thick, bottom=thick)
        for row in ws['A1:D10']:
            for cell in row:
                cell.border = Border(top=thick, left=thick, right=thick, bottom=thick)