sht.range('A1').clear() ## 清除单元格内容和格式 sht.range('A1').column ## 或row ,获取行标或者列标 sht.range('A1').row_height ## 或column_width 行高 列宽 sht.range('A1').rows.autofit() ## 行高自适应 sht.range('A1').color = (34,139,34) ## = None 加or除去颜色 7、与num...
rng.rows.autofit() print(rng.width) print(rng.height) # load_ws.range('A1:A2').api.height = 20 # === 第六部分,其它 === # lst=load_ws.range('A1:A'+str(load_ws['A1048576'].end('up').row)).value #把excel单列值读取到列表中 # lst1=load_ws.range('A1:C'+str(load_ws[...
rng.rows.autofit() print(rng.width) print(rng.height) # load_ws.range('A1:A2').api.height = 20 # === 第六部分,其它 === # lst=load_ws.range('A1:A'+str(load_ws['A1048576'].end('up').row)).value #把excel单列值读取到列表中 # lst1=load_ws.range('A1:C'+str(load_ws[...