openpyxl excel export script

gistfile1.txt

import openpyxl

wb = openpyxl.Workbook()
wb.guess_types = True
sheet = wb.active

with open("test_data.csv") as f:
    reader = csv.reader(f)
    sheet['D48'].number_format = '#,##0'
    sheet['M48'].number_format = '($#,##0.00_);[Red]($#,##0.00)'
    sheet['M49'].number_format = '$#,##0.00'
    for r, row in enumerate(reader):
        for c, col in enumerate(row):
            try:
                col = float(col)
            except ValueError:
                pass
                
            sheet.cell(row=r + 1, column=c + 1).value = col

wb.save("test_data.xlsx")