擅长:python、mysql、java
<p>Anand S Kumar的答案是正确的,但您需要将<code>i</code>改为<code>r</code>,并将{<cd3>}改为{<cd4>}。为了获得额外的好处,我为完整的代码示例添加了更多的代码。这段代码打开一个现有的excel文件,读取第一个工作表中的所有数据,并将这些数据写入新的excel文件。在</p>
<pre><code> import os,xlrd,xlwt
if os.path.isfile(outExcel):os.remove(outExcel)#delete file if it exists
inExcel= (r'C:\yourpath\inFile.xls')
outExcel= (r'C:\yourpath\outFile.xls')
workbook = xlrd.open_workbook(inExcel)
sheetIn = workbook.sheet_by_index(0)
workbook = xlwt.Workbook()
sheetOut = workbook.add_sheet('DATA')
for r in range(sheetIn.nrows):
for c in range(sheetIn.ncols):
sheetOut.write(r, c, sheetIn.cell_value(r, c))
workbook.save(outExcel)#save the result
</code></pre>