Python实现批量导入1000条xlsx数据_python

from openpyxl import load_workbook
import xlsxwriter
 
file_name = "max_1000.xlsx"
# 新建xlsx文件
workbook = xlsxwriter.Workbook(file_name)
worksheet = workbook.add_worksheet('Sheet1')
worksheet.write_row("A1",
                    ['公司', '编码', '渠道'])
#新增1000条数据
while m < 1000:
    m += 1
    # ["18"]、["21"]、["8"]分别代表第m行第1，2，3列的值，这里是写死的数据，也可以是参数化的数据
    worksheet.write_row(m, 0, ["18"])
    worksheet.write_row(m, 1, ["21"])
    worksheet.write_row(m, 2, ["8"])
# 关闭文件
workbook.close()
# 执行批量导入
data = load_yaml('./max_1000.yaml')['upload_file']
execute(data)

wb = load_workbook('max_1000.xlsx')
sheets = wb.worksheets
# 获取第一个sheet
sheet1 = sheets[0]
# 获取sheet1表第2行第1列的数据
cell_21 = sheet1.cell(2,1).value
# 获取sheet1表第3行第2列的数据
cell_32 = sheet1.cell(3,2).value

wb = load_workbook("max_1000.xlsx")
sheets = wb.worksheets
Sheet1 = sheets[0]
# 循环读取数据，Sheet1.max_row代表表格的最大行数
for i in range(Sheet1.max_row - 1):
    # 获取Sheet1表中所有行第4列的数据
    data = Sheet1.cell(i + 2, 4).value

wb = load_workbook(file_path)

ws = wb[sheet]

# 修改.xlsx文件中的数据，cell[0]对应行数, cell[1]对应列数，cell[-1]对应需要修改后的值

ws.cell(cell[0], cell[1]).value = cell[-1]

wb.save(file_path)

wb.close()