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

[YoshikageKira]

Hello there!

I'm having a problem with copying a .csv file into a .xlsx file. It does work because the information is there but the numbers do not register as numbers but as text values which causes the formulas in my .xlsx file to not work.

Keep in mind that I'm trying to copy my .csv sheet into a specific sheet in my .xlsx file, hence the sheet name. Here is my function:

import pandas as pd
import openpyxl

def write_to_target(xlsx_file, csv_file, sheet_name):
    book = openpyxl.load_workbook(xlsx)
    sheet_book = pd.read_csv(csv_file)

    with pd.ExcelWriter(xlsx_file, engine='openpyxl')  as writer:
        writer.book = book
        writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
        sheet_book.to_excel(writer, sheet_name=sheet_name, startrow=0, startcol=0, engine = 'openpyxl')

Thanks in advance!