python csv文件怎么转成excel_python csv文件转换成excel 脚本

def csv_to_xlsx(input,output):

with open(input, encoding='ANSI') as f:

read = csv.reader(f)

workbook = Workbook()

sheet = workbook.active

l = 1

com = re.compile("(\n|\t){1,}")

for line in read:

st = ",".join(line)

ss = re.sub(com, "\n", st)

line = ss.split(",")

r = 1

for i in line:

sheet.cell(row =l, column = r).value=i

sheet.cell(row =l, column = r).alignment=Alignment(wrapText=True)

r = r + 1

l = l + 1

col_width = []

i = 0

for col in sheet.columns:

for j in range(len(col)):

if j == 0:

col_width.append(len(str(col[j].value)))

else:

if col_width[i] < len(str(col[j].value)):

col_width[i] = len(str(col[j].value))

i = i + 1

for i in range(len(col_width)):

col_letter = get_column_letter(i+1)

if col_width[i] > 100:

sheet.column_dimensions[col_letter].width = 100

elif col_width[i]:

if col_width[i]<=6:col_width[i]=10

sheet.column_dimensions[col_letter].width = col_width[i]

workbook.save(output) # 保存Excel