$ pip install xlwings

import pandas as pd
import xlwings as xw

def csv_to_sheet(wb_name, ws_name, csv_name, save_flg=True, quit_flg=True):
    """\
Function description:
A function that copies the contents of CSV to a specified sheet

Argument description:
        wb_name: workbook name
        ws_name: Sheet name
        csv_name: CSV file name
        save_flg: Overwrite is performed by default.
        quit_flg: Default is closed
    """

    df = pd.read_csv(csv_name,encoding='cp932', index_col=0) #Read CSV file with DataFrame

    wb = xw.Book(wb_name) #Creating a workbook object
    wss = wb.sheets
    ws = wss[ws_name] #Creating a worksheet object

    ws.range('A1').value = df #Paste DataFrame

    #save_Overwrite if flg is True
    if save_flg:
        wb.save(path=None)

    #quit_Close Excel if flg is True
    if quit_flg:
        app = xw.apps.active  
        app.quit() #Exit Excel

wb_name = 'Excel file name.xlsx'
ws_name = 'Sheet name'
csv_name = 'CSV file'
csv_to_sheet(wb_name, ws_name, csv_name)

Recommended Posts