1.更改工作表标签颜色
sheet1.sheet_properties.tabColor='FF0000'
2.更改单元格行高和列宽
sheet1.row_dimensions[2].heigh = 100 //改行高为100
sheet1.column_dimensions['C'].width = 50 //改列宽为50
3.合并和拆分单元格
sheet1.merge_cells('A1:C3')
sheet1.unmerge_cells('A1:C3')
4.冻结窗口【要解冻就将冻结窗口设为 A1】
sheet1.freeze_panes='B2' //将该单元格的上和左冻结
sheet1.freeze_panes='A1' //解冻