如何使用openpyxl python将数据附加到指定行的excel文件中? [英] how to append data using openpyxl python to excel file from a specified row?

问题描述

我有不同的Python列表变量(data1，data2，data3 ect)，其中包含要放入现有excel工作表中的数据.目前，我的循环是这样的.

I have different Python list variables(data1, data2, data3 ect) containing data which I want to put into an already existing excel sheet. Presently My loop goes like this.

for row, entry in enumerate(data1,start=1):
  st.cell(row=row, column=1, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data2,start=1):
  st.cell(row=row, column=2, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data3,start=1):
  st.cell(row=row, column=3, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data4,start=1):
  st.cell(row=row, column=4, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data5,start=1):
  st.cell(row=row, column=5, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data6,start=1):
  st.cell(row=row, column=6, value=entry)
  work.save('sample.xlsx')
for row, entry in enumerate(data7,start=1):
  st.cell(row=row, column=7, value=entry)
  work.save('sample.xlsx')      

一旦我的Python脚本运行，它将存储第一行中的数据. 如果我再次运行脚本，我希望新数据位于可用数据之下

Once my Python script runs, It will store the data from the 1st row. If I am again running the script I want the new data to come below the available data

如何这样做?

推荐答案

尝试使用

sheet.max_row 

它将返回最后一行的值，您可以从此处开始写入新值.

it will return the last row value, You can start writing the new values from here.

max = ws.max_row
for row, entry in enumerate(data1,start=1):
   st.cell(row=row+max, column=1, value=entry)

希望对您有所帮助.快乐编码:)

Hope it helps.Happy Coding :)

这篇关于如何使用openpyxl python将数据附加到指定行的excel文件中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！