openpyxl-使用API总结

 

 

import openpyxl
from openpyxl.comments import Comment
from openpyxl.styles import Font, Alignment, Border, Side, colors  # 处理单元格样式

wb = openpyxl.load_workbook("C://testfile.xlsx")
ws = wb["sheet1"]
ws_cell_info = ws["A3"]
comment = Comment(pizhu_info, author="lmj")
comment.width = 400
comment.height = 200
ws_cell_info.comment = comment  # 这里ws_cell_info就是每个cell对象，是用sheet页句柄拿到的。

from openpyxl.styles import PatternFill
fill = PatternFill("solid", fgColor="#BBFFFF")  # 背景填充  rgb转成16进制，作为参数写进来
ws_cell_info.fill = fill

# 获取sheet页最大行数跟最大列数
max_rows_int = ws.max_row
max_columns_int = ws.max_column
ws_cell_info.insert_rows(current_index, insert_rows_count)  # 第一个参数，在第几行插入，第二个参数，插入几行

# 设置单元格样式
BGC = openpyxl.styles.PatternFill("solid", fgColor="366092") 
FONT_CENTER = Alignment(horizontal='center', vertical='center')
FONT_STYLE = Font(name='微软雅黑', size=11, color='ffffff')
BORDER_STYLE = Border(top=Side(style='thin', color=colors.BLACK), bottom=Side(style='thin', color=colors.BLACK), 
right=Side(style='thin', color=colors.BLACK), left=Side(style='thin', color=colors.BLACK))
ws_cell_info.fill = BGC  #  设置背景颜色
ws_cell_info.font = FONT_STYLE  # 设置字体样式
ws_cell_info.alignment = FONT_CENTER  # 设置居中样式
ws_cell_info.border = BORDER_STYLE  # 设置边框样式