擅长:python、mysql、java
<p>使用pylightxl非常简单</p>
<blockquote>
<p>pip install pylightxl</p>
</blockquote>
<pre><code>lines = []
with open(“textfile.txt”) as f:
line = f.readline()
if not line:
break
lines.append(line)
import pylightxl as xl
db = xl.Database()
db.add_ws("Sheet1", {})
for i, line in enumerate(lines, start=1):
db.ws("Sheet1").update_index(i, 1,line)
xl.writexl(db, “output.xlsx”)
</code></pre>