openpyxl将CSV转换为EXCEL

• Z时代
• 2024-01-10
• 分类：问答

如何:使用openpyxl模块将带有定界符的CSV文件转换为XLS（Excel工作表）？

回答：

好吧，你去…

import csv
from openpyxl import Workbook
from openpyxl.cell import get_column_letter
f = open(r'C:\Users\Asus\Desktop\herp.csv')
csv.register_dialect('colons', delimiter=':')
reader = csv.reader(f, dialect='colons')
wb = Workbook()
dest_filename = r"C:\Users\Asus\Desktop\herp.xlsx"
ws = wb.worksheets[0]
ws.title = "A Snazzy Title"
for row_index, row in enumerate(reader):
    for column_index, cell in enumerate(row):
        column_letter = get_column_letter((column_index + 1))
        ws.cell('%s%s'%(column_letter, (row_index + 1))).value = cell
wb.save(filename = dest_filename)

以上是 openpyxl将CSV转换为EXCEL 的全部内容， 来源链接： utcz.com/qa/419020.html