Python Excel鎿嶄綔_python涓搷浣渆xcel?

不废话直接上源码

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) #保存文件