python - 在 csv 写入过程中返回一个字符

Question

我正在尝试将 xls 工作表转换为 CSV 文件。

workbook1 = xlrd.open_workbook(path+'diseaseData.xls')
for sheet in workbook1.sheet_names():
    sh = workbook1.sheet_by_name(sheet)
    csvFile = open('//....../disease-'+sheet+'.csv', 'w')
    wr = csv.writer(csvFile, quoting=csv.QUOTE_ALL)
    for rownum in range(sh.nrows):
        # print (sh.row_values(rownum))
        wr.writerow(sh.row_values(rownum))
    csvFile.close()

它可以工作，但输出的 CSV 每行后面都有一个空行

"ID","Caption","Sequela type","Visible",""

"infection","Infection","infection","1",""

"acute","Symptomatic infection","acute","1",""

"asymptomatic","Asymptomatic infection","sequela","1",""

"ards_long","Permanent disability due to ARDS","sequela","1",""

"fatalAcute","Fatal cases","sequela","1",""

我如何告诉 wr.writerow 它必须覆盖最后一个字符？

我认为这会消除额外的回车符。

我尝试了.strip('\n')但是

AttributeError: 'list' object has no attribute 'strip'

Answer 1

您不需要返回一个字符。只需使用 csv writer 的 lineterminator 参数即可。

wr = csv.writer(csvFile, lineterminator='\n')

关于此行为的其他线程，例如here .