python - 使用 openpyxl 无法创建 XLSX

Question

我尝试了下面的代码。我尝试在 Excel 上打开，但我发现文件已损坏，然后修复文件以读取它。打开 xlsx 时如何解决 xlsx 修复问题。

import csv
from openpyxl import Workbook

def unicode_csv_reader(utf8_data, dialect=csv.excel, **kwargs):
  csv_reader = csv.reader(utf8_data, dialect=dialect, **kwargs)
  for row in csv_reader:
    yield [unicode(cell, 'utf-8') for cell in row]

filename = 'WS_Data_0_2019_09_25_215340128516.csv'
reader = unicode_csv_reader(open(filename))

wb = Workbook()
ws = wb.active

# lets just save 10 rows in a xlsx
i = 0
for row in reader:
  if i < 10:
    ws.append(row)
    # print row
    i = i+1 

wb.save('example.xlsx')

标签： pythonpython-2.7openpyxl