python实现excel的追加内容
import sys
import xlwt
import os
from xlrd import open_workbook
from xlutils.copy import copy
test_path = "/data/code/"
workbook = xlwt.Workbook(encoding='utf-8')
booksheet = workbook.add_sheet('Sheet 1', cell_overwrite_ok=True)
workbook_path = os.path.join(test_path, ('ALL_Sen_Spe_AUC' + '.xls'))
if os.path.exists(workbook_path):
print("文件已存在")
else:
workbook.save(workbook_path)
r_xls = open_workbook(workbook_path) # 读取excel文件
row = r_xls.sheets()[0].nrows # 获取已有的行数
excel = copy(r_xls) # 将xlrd的对象转化为xlwt的对象
worksheet = excel.get_sheet(0) # 获取要操作的sheet
# 对excel表追加一行内容
worksheet.write(row, 0, '内容1') # 括号内分别为行数、列数、内容
excel.save(workbook_path) # 保存并覆盖文件
运行两次的结果: