import xlsxwriter
file = '数据' + '.xlsx' # 保存表格名
pic_path = 'image/1.png' # 图片路径
workbook = xlsxwriter.Workbook(file)
worksheet = workbook.add_worksheet('sheet1')
worksheet.insert_image(f'A3', f'./{pic_path}',{'x_scale': 0.0705, 'y_scale': 0.1015, 'x_offset': 0, 'y_offset': 0}) # 指定A3格，x、y为缩放比例
workbook.close()
