[openpyxl] Forum Topics

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)

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") …