擅长:python、mysql、java
<p>我创建了一个python程序,它将成功地完成这项任务。在</p>
<pre><code>import xlrd
from xlwt import Workbook
data = []
head = []
mergedlist = []
path = "E:/Sreeraj/Thailand/"
file = "1. Ban Kong Niam"
text = path + file + ".txt"
excel = path + file + ".xls"
with open(text) as f:
for cnt, line in enumerate(f):
if cnt < 12:
mergedlist.append(line)
with open(text) as f:
for line in f:
data.append([word for word in line.split("\t") if word])
mergedlist = head + data
import xlwt
wb = xlwt.Workbook()
sheet = wb.add_sheet("New Sheet")
for row_index in range(len(mergedlist)):
for col_index in range(len(mergedlist[row_index])):
sheet.write(row_index, col_index, mergedlist[row_index][col_index])
wb.save(excel)
</code></pre>
<p>因此,使用我编写的上述python程序,我可以完美地得到如下所示的excel文件输出。在</p>
^{pr2}$