Python 으로 엑셀 셀 배경색 넣기.

color = 'ffffff'

bc = PatternFill(fgColor=Color(color, tint=0.5), bgColor=Color(color, tint=0.5), fill_type='gray125')

excel에 첨부된 이미지 추출.

# -*-coding:utf-8-*-

from openpyxl import load_workbook
from openpyxl_image_loader import SheetImageLoader


def main():
    filepath = './excel/sample.xlsx'
    load_wb = load_workbook(filepath, data_only=True)
    for sheet_name in load_wb.sheetnames:
        sheet = load_wb[sheet_name]

        image_loader = SheetImageLoader(sheet)
        # image = image_loader.get('C3')
        # image.show()
        print(sheet.max_row, sheet.max_column)
        for column in range(sheet.max_column):
            column = chr(ord('A') + column)
            for row in range(sheet.max_row):
                cell_id = '{0}{1}'.format(column, row)
                print(cell_id)
                if image_loader.image_in(cell_id):
                    print(cell_id, '->', image_loader.image_in(cell_id))


if __name__ == '__main__':
    main()