Excel Parser
import pandas as pd
def get_sheet_names(file_name, MAX):
"""
READ_PATH : 사용할 파일명
Device_Type : 실내기 or 실외기
MAX : 최대 읽을 장비 수 (모두 = 0)
"""
outdoor_sheet_names= []
indoor_sheet_names= []
for sheet in file_name.sheet_names:
if sheet[0] == 'O':
outdoor_sheet_names.append(sheet)
elif sheet[0] == 'I':
indoor_sheet_names.append(sheet)
if MAX != 0:
sheet_names = sheet_names[0:MAX]
return outdoor_sheet_names, indoor_sheet_names
file_name = pd.ExcelFile('05H-33M-24S-DVM S NASA-Trend.xls')
with pd.ExcelWriter(RESULT_FILE_NAME, engine='xlsxwriter') as writer:
outdoor_result.to_excel(writer, sheet_name = 'Outdoor')
indoor_result.to_excel(writer, sheet_name = 'Indoor')