python 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 ds=datesecon() com = re.compile("(\n|\t){1,}") border = Border(left=Side(style='thin', color='FF000000'), right=Side(style='thin', color='FF000000'), top=Side(style='thin', color='FF000000'), bottom=Side(style='thin', color='FF000000'), diagonal=Side(style='thin', color='FF000000'), diagonal_direction=0, outline=Side(style='thin', color='FF000000'), vertical=Side(style='thin', color='FF000000'), horizontal=Side(style='thin', color='FF000000')) for line in read: st = "@@@".join(line) ss = re.sub(com, "\n", st) line = ss.split("@@@") r = 1 if l>1 and (string_toDatetime(line[4]) < ds[0] or string_toDatetime(line[4]) > ds[1]): r = r + 1 continue for i in line: sheet.cell(row=l, column=r).border = border sheet.cell(row=l, column=r).value = i sheet.cell(row=l, column=r).alignment = Alignment(wrapText=True) if(l==1): fill = PatternFill("solid", fgColor="FFFF00") sheet.cell(row=l, column=r).fill = fill 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