<p>这对我有用。你知道吗</p>
<p>注意在<code>open</code>块中添加<code>newline=''</code>会阻止在文件的每一行之间添加空行。你知道吗</p>
<pre><code>import csv
RecordedData = [[232,233,234,235,236,237],[232,233,234,235,236,237]]
Header = 'Title 1', 'Title 2', 'Title 3', 'Title 4', 'Title 5', 'Title 6'
with open('test.csv', "w", newline='') as csv_file:
writer = csv.writer(csv_file, delimiter=',')
i = 0
writer.writerow(Header)
TotalRuns = 1 #Changed to assumed NumTestCycles value from example data give
while i <= TotalRuns:
ExportLine = RecordedData[i]
writer.writerow(ExportLine)
i += 1
</code></pre>
<p>Excel输出:</p>
<pre><code> A | B | C | D | E | F
Title 1 | Title 2 | Title 3 | Title 4 | Title 5 | Title 6
232 | 233 | 234 | 235 | 236 | 237
232 | 233 | 234 | 235 | 236 | 237
</code></pre>
<p>*编辑以包含标题行</p>
<p>*编辑2,您也可以尝试在leu中使用<code>.writerows()</code>来遍历您的列表,这应该可以解决您的错误。你知道吗</p>
<pre><code>import csv
RecordedData = [[232,233,234,235,236,237],[232,233,234,235,236,237]]
Header = 'Title 1', 'Title 2', 'Title 3', 'Title 4', 'Title 5', 'Title 6'
with open('test.csv', "w", newline='') as csv_file:
writer = csv.writer(csv_file, delimiter=',')
writer.writerow(Header)
TotalRuns = 1 #Changed to assumed NumTestCycles value from example data give
writer.writerows(RecordedData)
</code></pre>