1,效果
2,源码
不废话直接上源码
import openpyxl
def insert_row(row_num, id, projectName, projectId, deviceId, deviceName, time, filepath, content):
excel_file_name = "data.xlsx"
excel_dir = "E:\\test\\"
excel_file_path = os.path.join(excel_dir, excel_file_name)
wb = openpyxl.load_workbook(file_name) #加载excel文件
wsheet = wb.get_sheet_by_name('data') #获取sheet句柄
#插入一行数据
wsheet.cell(row=row_num, column=1).value = id
wsheet.cell(row=row_num, column=2).value = projectName
wsheet.cell(row=row_num, column=3).value = projectId
wsheet.cell(row=row_num, column=4).value = deviceId
wsheet.cell(row=row_num, column=5).value = deviceName
wsheet.cell(row=row_num, column=6).value = time
wsheet.cell(row=row_num, column=7).value = filepath
wsheet.cell(row=row_num, column=8).value = content
wb.save(file_name) #保存文件