How to copy a .csv worksheet into a .xlsx file without the number values turning into

[YoshikageKira]

Update: I figured it out

import sys
import openpyxl
import csv
import glob
from openpyxl.utils import get_column_letter

def write_to_target(target, directory, sheet_name):
    book = openpyxl.load_workbook(target)
    ws = book.get_sheet_by_name(sheet_name)
    f = open(directory)
    reader = csv.reader(f)
    for row_index, row in enumerate(reader):
        for column_index, cell in enumerate(row):
            column_letter = get_column_letter((column_index + 1))
            s = cell
            try:
                s=float(s)
            except ValueError:
                pass

            ws.cell('%s%s'%(column_letter, (row_index + 1))).value = s

Just replace target with the .xlsx file and directory with the .csv file

Thanks to everyone who've responded to this post