returns-file-extractor.py

import datetime
import glob
import os
from openpyxl import Workbook
from openpyxl import load_workbook
from os.path import expanduser

home = expanduser("~")
os.chdir(home + "/Downloads")

masterFileName = 'returns-monthly.xlsx'

today = datetime.date.today()
thisMonthAbbrv = today.strftime('%b')

if os.path.isfile(masterFileName) == False:
    masterWorkbook = Workbook()
else:
    masterWorkbook = load_workbook(filename = masterFileName)


if thisMonthAbbrv not in masterWorkbook.sheetnames:
    print("Creating worksheet for " + thisMonthAbbrv)
    monthsWorksheet = masterWorkbook.create_sheet(thisMonthAbbrv)
    del masterWorkbook["Sheet"]
else:
    monthsWorksheet = masterWorkbook[thisMonthAbbrv]

for fileName in glob.glob("*" + today.strftime('%d.%m.%y') + ".xlsx"):
    todayWorkbook = load_workbook(filename = fileName)
    todayWorksheet = todayWorkbook.active

    rows = tuple(todayWorksheet.rows)
    iterrows = iter(rows)
    next(iterrows)
    for a in iterrows:
        monthsWorksheet.append([a[0].value, a[1].value])

print(masterWorkbook.worksheets)
masterWorkbook.save(filename = masterFileName)