表格处理—图片、文字插入

1.新建表格，在插入照片(xlsxwriter)
此方法每次都是新建一个excel表格，然后再写入内容

import xlsxwriter
import os

file_name = []
f1 = open("data.txt", 'r')
for file in f1:
    file_name.append(file.strip())

# 创建一个新Excel文件并添加一个工作表。
workbook = xlsxwriter.Workbook('a1.xlsx')
worksheet = workbook.add_worksheet()

path = "img/"
for i in range(3):
    worksheet.write('A' + str(i + 1), file_name[i])
    worksheet.insert_image('B' + str(i + 1), path + file_name[i], {'x_scale': 0.2, 'y_scale': 0.13})
workbook.close()

2.在表格上追加文字和图片
可在原有表格上进行相关操作

# -*- coding: utf-8 -*-
from openpyxl import load_workbook
from openpyxl.drawing.image import Image
import os

#打开表格，选中表sheet1
path="img2/"
file_path = 'a1.xlsx'
wb = load_workbook(filename= file_path)
sheet_ranges = wb['Sheet1']
ws = wb['Sheet1']

#根据a1列的值，在其他列列填入信息和照片
for i in range(5):
	n=str(i+1)
	list_a=sheet_ranges['a'+n].value
	print(list_a)

#方法一
	boolean=os.path.exists(path+list_a+'.jpg')
	if boolean==1:
		img = Image(path+list_a+'.jpg')
		ws.add_image(img, 'c'+n)
		wb.save(file_path)
	else:
		print(list_a+"：炸了")

#方法二
	# try:
	# 	img = Image(path+list_a+'.jpg')
	# 	ws.add_image(img, 'c'+n)
	# 	wb.save(file_path)
	# except FileNotFoundError:
	# 	print("File is not found.")

结果如下：