Python - 需要类似字节的对象，而不是 'str'

Question

我这里有一个简单的 Python 代码片段，它将宏 Excel 工作表复制到 csv 中。该片段由于某种奇怪的原因而爆炸。我曾经使用 Python 2.7 运行此代码片段，并且没有任何问题。我最近下载了 Python 3.6。我该如何解决这个问题？

import csv
import xlrd

workbook = xlrd.open_workbook('P:/LFC Lots and Sales-NEW.xlsm')
for sheet in workbook.sheets():
with open('{}.csv'.format(sheet.name), 'wb') as f:
    writer = csv.writer(f)
    writer.writerows(sheet.row_values(row) for row in range(sheet.nrows))
print ("Sheets copied")

回溯:

writer.writerows(sheet.row_values(row) for row in range(sheet.nrows))
TypeError: a bytes-like object is required, not 'str'

Answer 1

明白了!我所需要做的就是将 wb 更改为 w。

import csv
import xlrd

workbook = xlrd.open_workbook('P:/LFC Lots and Sales-NEW.xlsm')
for sheet in workbook.sheets():
with open('{}.csv'.format(sheet.name), 'w') as f:
    writer = csv.writer(f)
    writer.writerows(sheet.row_values(row) for row in range(sheet.nrows))
print ("Sheets copied")