excel带格式复制python 

openpyxl 复制cell单元格包括所有样式

target_cell.data_type = source_cell.data_type
target_cell.fill = copy(source_cell.fill)
if source_cell.has_style:
    target_cell._style = copy(source_cell._style)
    target_cell.font = copy(source_cell.font)
    target_cell.border = copy(source_cell.border)
    target_cell.fill = copy(source_cell.fill)
    target_cell.number_format = copy(source_cell.number_format)
    target_cell.protection = copy(source_cell.protection)
    target_cell.alignment = copy(source_cell.alignment)
 
if source_cell.hyperlink:
    target_cell._hyperlink = copy(source_cell.hyperlink)
 
if source_cell.comment:
    target_cell.comment = copy(source_cell.comment)

 

posted @ 2020-10-08 21:26  myrj  阅读(2214)  评论(0)  编辑  收藏  举报