python_Excel中写入图片

目录

效果：

代码：

---

效果：

 

代码：

import xlsxwriter,os,re
from PIL import Image

def example_00():
    pic_dir = 'D:/temp003/pic/'
    excel_file_path = r'D:/temp003/pic_list.xlsx'
    workbook = xlsxwriter.Workbook(excel_file_path)
    worksheet = workbook.add_worksheet('people')
    worksheet.set_column_pixels(0,0,200)
    pic_list = os.listdir(pic_dir)
    name_format = workbook.add_format({'align':'center','valign':'vcenter'})
    for index,pic in enumerate(pic_list):
        # print(pic)
        pic_file_path = pic_dir + pic
        img = Image.open(pic_file_path)
        w = img.width
        h = img.height
        if h>w:
            scale = round(200/h,6)
        else:
            scale = round(200/w,6)
        worksheet.set_row_pixels(index,200)
        worksheet.insert_image(index,0,pic_file_path,{'x_scale':scale,'y_scale':scale})
        people_name = res_chinese_str(pic)
        worksheet.write(index,1,people_name,name_format)
        pass
    workbook.close()
    pass


def res_chinese_str(ori_str):
    han = re.sub("[A-Za-z0-9,._\-()~]","",ori_str)
    return han

if __name__ == '__main__':
    example_00()
    print('---------------- temp_000.py')
    pass