好吧，你去…
import csvfrom openpyxl import Workbookfrom openpyxl.cell import get_column_letterf = open(r'C:UsersAsusDesktopherp.csv')csv.register_dialect('colons', delimiter=':')reader = csv.reader(f, dialect='colons')wb = Workbook()dest_filename = r"C:UsersAsusDesktopherp.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 = cellwb.save(filename = dest_filename)
