<p>我有一个文本文件:</p>
<pre><code>Created 30/01/2018 18:28 by Windographer 4.0.26
Latitude = N 9.601639
Longitude = E 98.476861
Elevation = 0 m
Calm threshold = 0 m/s
Included flags: <Unflagged data>
Excluded flags: Invalid
Time stamps indicate the beginning of the time step.
Date/Time Ban Kong Niam [m/s]
2008-06-01 00:00 9999
2008-06-01 01:00 9999
2008-06-01 02:00 9999
2008-06-01 03:00 9999
2008-06-01 04:00 9999
2008-06-01 05:00 9999
2008-06-01 06:00 9999
2008-06-01 07:00 9999
2008-06-01 08:00 9999
</code></pre>
<p>现在,我想把这个文本文件转换成Excel文件。在</p>
<p>如果文本文件只包含以下行,我可以编写一个python程序来创建excel文件:</p>
^{pr2}$
<p>为此,我使用了python代码:</p>
<pre><code>data = []
with open("E:/Sreeraj/Thailand/1. Ban Kong Niam.txt") as f:
for line in f:
data.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>([word for word in line.split("\t") if word])
print data
import xlwt
wb = xlwt.Workbook()
sheet = wb.add_sheet("New Sheet")
for row_index in range(len(data)):
for col_index in range(len(data[row_index])):
sheet.write(row_index, col_index, data[row_index][col_index])
wb.save("E:/Sreeraj/Thailand/hi.xls")
</code></pre>
<p>这个python代码运行得非常好。在</p>
<p>但是,我想把整个文本文件转换成Excel文件。因为,我想打印:</p>
<pre><code>Created 30/01/2018 18:28 by Windographer 4.0.26
Latitude = N 9.601639
Longitude = E 98.476861
Elevation = 0 m
Calm threshold = 0 m/s
Included flags: <Unflagged data>
Excluded flags: Invalid
Time stamps indicate the beginning of the time step.
</code></pre>
<p>我如何制作一个python程序,将下面给出的行的整个文本文件转换成Excel文件?在</p>
<pre><code>Created 30/01/2018 18:28 by Windographer 4.0.26
Latitude = N 9.601639
Longitude = E 98.476861
Elevation = 0 m
Calm threshold = 0 m/s
Included flags: <Unflagged data>
Excluded flags: Invalid
Time stamps indicate the beginning of the time step.
Date/Time Ban Kong Niam [m/s]
2008-06-01 00:00 9999
2008-06-01 01:00 9999
2008-06-01 02:00 9999
2008-06-01 03:00 9999
2008-06-01 04:00 9999
2008-06-01 05:00 9999
2008-06-01 06:00 9999
2008-06-01 07:00 9999
2008-06-01 08:00 9999
</code></pre>