Create excel file in python from a CSV

to-excel.py

import os
import csv

from openpyxl import Workbook
from openpyxl.cell import get_column_letter
from openpyxl.styles import PatternFill

fill = PatternFill(start_color='3498DB',
                end_color='3498DB',
                fill_type='solid')

def writeHeader(ws, header):
    for c, col in enumerate(header):
        h = ws.cell(column=c + 1, row=1, value=col)
        h.fill = fill

def cast(value, type):                                         #TODO: COMPLETE!
    if type == 'int':
        return int(value)
    elif type == 'date':
        return "???"
    else:
        return value

def writeData(ws, file, toType):
    reader = csv.reader(file, delimiter=';')
    for r, row in enumerate(reader):
        for c, col in enumerate(row):
            _ = ws.cell(column=c + 1, row=r + 2, value=cast(col,toType[c]))

wb = Workbook()

ws1 = wb.active
ws1.title = "TEST"                                            #TODO: CUSTOMIZE
writeHeader(ws1, ["C1", "C2", "C3"])                          #TODO: CUSTOMIZE
with open("TEST.csv", 'rb') as file:                          #TODO: CUSTOMIZE
    writeData(ws1, file, ["string", "string",  "int"])        #TODO: CUSTOMIZE

dest_filename = 'TEST.xlsx'                                   #TODO: CUSTOMIZE

if os.path.exists(dest_filename):
    os.remove(dest_filename)

wb.save(filename = dest_filename)