convert csv to xlsx

convert_to_xlsx.py

import glob
import csv
from xlsxwriter.workbook import Workbook

for csvfile in glob.glob("/data"):
    workbook = Workbook(csvfile.rsplit(".")[0].split("/", 1)[-1] + '.xlsx')
    worksheet = workbook.add_worksheet()
    _format = workbook.add_format()
    _format.set_pattern(1)
    _format.set_bg_color('blue')
    worksheet.freeze_panes(1, 1) # # Freeze the first row and column
    cnt = 0

    with open(csvfile, 'r') as f:
        reader = csv.reader(f)
        for r, row in enumerate(reader):
            for c, col in enumerate(row):
                if cnt == 0:
                    worksheet.write(r, c, col, _format)
                else:
                    worksheet.write(r, c, col)
                    cnt = 1
        workbook.close()