擅长:python、mysql、java
<p><strong>openpyxl</strong>有许多不同的精确方法,但是<strong>ws.append</strong>在前面的答案中足够强大,可以满足您的需求。假设您已将数据写入新的sample.xlsx:</p>
<pre><code>from openpyxl.workbook import Workbook
headers = ['Company','Address','Tel','Web']
workbook_name = 'sample.xlsx'
wb = Workbook()
page = wb.active
page.title = 'companies'
page.append(headers) # write the headers to the first line
# Data to write:
companies = [['name1','address1','tel1','web1'], ['name2','address2','tel2','web2']]
for info in companies:
page.append(info)
wb.save(filename = workbook_name)
</code></pre>
<p>现在,若要附加新行,必须首先使用“加载工作簿”打开现有书本:</p>
<pre><code>from openpyxl import load_workbook
workbook_name = 'sample.xlsx'
wb = load_workbook(workbook_name)
page = wb.active
# New data to write:
new_companies = [['name3','address3','tel3','web3'], ['name4','address4','tel4','web4']]
for info in new_companies:
page.append(info)
wb.save(filename=workbook_name)
</code></pre>