【openpyxlでの書式取得方法まとめ】罫線・フォント・背景など

import openpyxl
from openpyxl.styles import Font

wb = openpyxl.load_workbook('input.xlsx')
ws1 = wb['Sheet1']
ws2 = wb['Sheet2']

cell1 = ws1['A1']
cell2 = ws2['A1']

cell2.font = Font(name=cell1.font.name)

wb.save('output.xlsx')

cell2.font = Font(name=cell1.font.name)
cell2.font = Font(size=cell1.font.size)
cell2.font = Font(bold=cell1.font.bold)
cell2.font = Font(italic=cell1.font.italic)
cell2.font = Font(vertAlign=cell1.font.vertAlign)
cell2.font = Font(underline=cell1.font.underline)
cell2.font = Font(strike=cell1.font.strike)
cell2.font = Font(color=cell1.font.color)

import openpyxl
from openpyxl.styles import PatternFill

wb = openpyxl.load_workbook('input.xlsx')
ws1 = wb['Sheet1']
ws2 = wb['Sheet2']

cell1 = ws1['A1']
cell2 = ws2['A1']

cell2.fill = PatternFill(patternType=cell1.fill.patternType, fgColor=cell1.fill.fgColor)

wb.save('output.xlsx')

import openpyxl
from openpyxl.styles.borders import Border, Side

wb_in = openpyxl.load_workbook('input.xlsx')
ws_in = wb_in['Sheet1']

wb_out = openpyxl.Workbook()
ws_out = wb_out.active

left_border = ws_in.cell(column=2, row=2).border.left.border_style
right_border = ws_in.cell(column=2, row=2).border.right.border_style
top_border = ws_in.cell(column=2, row=2).border.top.border_style
bottom_border = ws_in.cell(column=2, row=2).border.bottom.border_style

ws_out.cell(column=2, row=2).border = Border(left=Side(style=left_border), right=Side(style=right_border), top=Side(style=top_border), bottom=Side(style=bottom_border))

wb_out.save('output.xlsx')

import openpyxl
from openpyxl.styles import PatternFill, Border, Side, Font

wb = openpyxl.load_workbook('input.xlsx')

ws1 = wb['Sheet1']
ws2 = wb['Sheet2']

r = 0
c = 0

for row1 in ws1 :
    c = 1
    r = r + 1
    for cell1 in row1 :
        ws2.cell(row=r, column=c).font = Font(
            name=cell1.font.name,
            size=cell1.font.size,
            bold=cell1.font.bold,
            italic=cell1.font.italic,
            vertAlign=cell1.font.vertAlign,
            underline=cell1.font.underline,
            strike=cell1.font.strike,
            color=cell1.font.color
        )
        
        ws2.cell(row=r, column=c).fill = PatternFill(
            patternType=cell1.fill.patternType, 
            fgColor=cell1.fill.fgColor
        )
        
        left_border = ws1.cell(row=r, column=c).border.left.border_style
        right_border = ws1.cell(row=r, column=c).border.right.border_style
        top_border = ws1.cell(row=r, column=c).border.top.border_style
        bottom_border = ws1.cell(row=r, column=c).border.bottom.border_style
        ws2.cell(row=r, column=c).border = Border(
            left=Side(style=left_border), 
            right=Side(style=right_border), 
            top=Side(style=top_border), 
            bottom=Side(style=bottom_border)
        )

        c = c + 1

wb.save('output.xlsx')