hoge.py

#!/usr/bin/env python
# coding: utf-8

# In[16]:


from tkinter import filedialog
from tkinter import messagebox
import csv
import xlwings

ENCODING = 'cp932'


# In[18]:


try:
    fn = filedialog.askopenfilename(title = 'ミロクから出力した仕訳帳ファイルを開く', filetypes = [('CSV (コンマ区切り)', '.csv')])
    
    if not fn:
        exit(1)
    
    with open(fn, encoding = ENCODING) as f:
        reader = csv.reader(f)
        tbl = list(reader)
    
    rows = len(tbl)
    cols = max(map(len, tbl))
    
    b = xlwings.Book()
    
    s = xlwings.sheets.active
    
    s.range(1, 1).value = tbl
    
    s.range((1, 1), (rows, cols))
except Exception as e:
    messagebox.showerror('Runtime Error', str(e))