def get_gbbq(mypath,today_date):
'提取财务数据资料'
gbbq_list = []
if not os.path.exists(mypath +'base\\gbbq.xlsx'):
os.chdir(mypath +'base')
wb = Workbook()
ws = wb.active
wb.save(mypath +'base\\gbbq.xlsx')
wb.close()
try:
if os.path.getmtime(
mypath + 'base\\gbbq.xlsx') > os.path.getmtime(
mypath + 'base\\gbbq.txt'):
return gbbq_list
print('正在提取财务数据\n')
wb = load_workbook(mypath + 'base\\gbbq.xlsx')
ws = wb.active
i = 2
with open(mypath + 'base\\gbbq.txt') as f:
for each in f:
for j in
07-07
07-07
05-06
06-03