I have faced an issue of insert new row in the excel file at the same time keeping its format ting/style
I did try to use the openpyxl’s insert new row
conv_ws.insert_rows(idx=14,amount=1)
but the new row will not have the same format as in the picture show:
Image after insert new row
As u guys can see the new row is added in row 14, but that row won’t keep the format
Can anyone help me to solve this issue?