目录
效果：
?
代码：
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
