你可以使用内置的
csv
要在您的XLSX文件旁边写入CSV的模块,您只需要以不同的方式创建它:
import csv
import io
import xslxwriter
xlsx_data = io.BytesIO()
csv_data = io.StringIO() # on Python 2.x useio.BytesIO()
XLSX part
workbook = xlsxwriter.Workbook(xlsx_data, {‘in_memory’: True})
worksheet = workbook.add_worksheet()
CSV part
csv_writer = csv.writer(csv_data)
Some data we want to write to the worksheet.
expenses=([‘OriginalURL’, ‘NormalizedURL’, ‘Response’, ‘DuplicateOf’,
‘SourceId’, ‘RelatedSources’],)
for row, data in enumerate(expenses):
# XSLX part
worksheet.write_row(row, 0, data) # if needed, add an offset to the row/column
# CSV part
csv_writer.writerow(row)
workbook.close()
CSV data available in csv_data, XLSX data available in xlsx_data
</code>
从你的问题不清楚你是否想要同时创建它们 - 如果不是,只需删除XLSX部分(你可以做
csv_writer.writerows(expenses)
直接,不迭代各行)。