csv to xlsx convert code

csv_to_xlsx.py

#!/usr/bin/python3
import pandas as pd
import numpy as np
import glob
import sys
from openpyxl import Workbook
import os
import csv

path = "./"
file_list = os.listdir(path)
file_list_csv = [file for file in file_list if file.endswith(".csv")]
file_list_csv.sort()

wb = Workbook()
ws = wb.active
for i,d in enumerate(file_list_csv):
        print(i, d)
        with open(d, 'r', encoding='utf8') as f:
                for row in csv.reader(f):
                        ws.append(row)
        wb.save('res.xlsx')