#년도
year_list = []
for filename in name_list:
book = openpyxl.load_workbook(filename)
sheet = book.worksheets[0]
def findExistString(searchString, text):
if searchString in text: return True
else: return False
def findNonExistString(searchString, text):
if searchString in text: return False
else: return True
for row in sheet.rows:
if findExistString('영업', row[1].value):
year_list.append(filename[11:15])
break
#영업이익
profit_list = []
for filename in name_list:
book = openpyxl.load_workbook(filename)
sheet = book.worksheets[0]
def findExistString(searchString, text):
if searchString in text: return True
else: return False
def findNonExistString(searchString, text):
if searchString in text: return False
else: return True
for row in sheet.rows:
if findExistString('영업', row[1].value):
profit_list.append(row[2].value)
break
#당기순이익
netincome_list = []
for filename in name_list:
book = openpyxl.load_workbook(filename)
sheet = book.worksheets[0]
def findExistString(searchString, text):
if searchString in text: return True
else: return False
def findNonExistString(searchString, text):
if searchString in text: return False
else: return True
for row in sheet.rows:
if findExistString('당기', row[1].value):
netincome_list.append(row[2].value)
break
#매출액
sales_list = []
for filename in name_list:
book = openpyxl.load_workbook(filename)
sheet = book.worksheets[0]
def findExistString(searchString, text):
if searchString in text: return True
else: return False
def findNonExistString(searchString, text):
if searchString in text: return False
else: return True
for row in sheet.rows:
if findExistString('매출액', row[1].value):
sales_list.append(row[2].value)
break
A = year_list
B = profit_list
C = netincome_list
D = sales_list
이렇게해서 코드를 짰는데요. name_list에 도 나중에 반복문을 쓸생각입니다.
여기서 문제가 하나 생겼는데요. name_list를 한번쓰고 다음차례에 name_list값이 전에쓴 name_list값이나온다는 겁니다. 혹시 지식을좀 나눠주실수 있을까요?
ex)name_list = a
profit_list = AAA
ex)name_list = b
profit_list = AAA
name_list를 b로 했음에도 profit_list에는 a를 넣은값이나옵니다