본문 바로가기

Python_Intermediate/Openpyxl

Python Openpyxl - Basic

import openpyxl

# 파일 오픈
wb = openpyxl.load_workbook('example.xlsx')

# wb 타입 확인
print(type(wb))

#  현재 워크북에 워크시트 확인
# print(wb.get_sheet_names()) -> 아래 명령어로 대체
print(wb.sheetnames)

# 워크시트 접금
# sheet = wb.get_sheet_by_name('Sheet1') -> 아래 명령어로 대체
sheet = wb['Sheet1']
print(type(sheet))

# 엑티브 시트 사용해 활성화 된 시트 확인
active_sheet = wb.active
print(type(active_sheet))

# 셀에 접근 - 인덱스
cell = sheet['A1']
print(cell)

# 셀에 데이터 가져오기
cell_value = cell.value
print(cell_value)
print('Cell ' + cell.coordinate + ' is ' + cell_value)
print(sheet['A45'].value)

# 셀에 접근 - 키워드 파라미터 사용
keyword_cell = sheet.cell(row=1, column=2)
print(keyword_cell)

# 셀에 데이터 가져오기
keyword_cell_value = sheet.cell(row=1, column=2).value
print(keyword_cell_value)

# for 문 사용 데이터 가져오기
for i in range(1, 8, 2):
    print(i, sheet.cell(row=i, column=2).value)

# 마지막 셀(로우) 가져오기
last_cell_row = sheet.max_row
print(last_cell_row)

# 마지막 셀(컬럼) 가져오기
last_cell_column = sheet.max_column
print(last_cell_column)

# 여러 셀 접근하기
cell_range = sheet['A1' : 'C2']
print(cell_range)
colC = sheet['C']
print(colC)
col_range = sheet['C:D']
print(col_range)
row10 = sheet[10]
print(row10)
row_range = sheet[5:10]
print(row_range)

# 전체 컬럼과 로우에 접근하는 코드
for col_cell in colC:
    print(col_cell.value)

for col in col_range:
    for cell in col:
        print(cell.value)
    print('')

for col_cell in colC:
    print(col_cell.value)

for row in row_range:
    for cell in row:
        print(cell.value)
    print('')

 

<class 'openpyxl.workbook.workbook.Workbook'>
['Sheet1', 'Sheet2', 'Sheet3']
<class 'openpyxl.worksheet.worksheet.Worksheet'>
<class 'openpyxl.worksheet.worksheet.Worksheet'>
<Cell 'Sheet1'.A1>
park.key
Cell A1 is park.key
44
<Cell 'Sheet1'.B1>
park.name
park.name
3 Columbia Park
5 Arlington Stadium
7 Atlanta-Fulton County Stadium
251
6
((<Cell 'Sheet1'.A1>, <Cell 'Sheet1'.B1>, <Cell 'Sheet1'.C1>), (<Cell 'Sheet1'.A2>, <Cell 'Sheet1'.B2>, <Cell 'Sheet1'.C2>))
(<Cell 'Sheet1'.C1>, <Cell 'Sheet1'.C2>, <Cell 'Sheet1'.C3>, <Cell 'Sheet1'.C4>, <Cell 'Sheet1'.C5>, <Cell 'Sheet1'.C6>, <Cell 'Sheet1'.C7>, <Cell 'Sheet1'.C8>, <Cell 'Sheet1'.C9>, <Cell 'Sheet1'.C10>, <Cell 'Sheet1'.C11>, <Cell 'Sheet1'.C12>, <Cell 'Sheet1'.C13>, <Cell 'Sheet1'.C14>, <Cell 'Sheet1'.C15>, <Cell 'Sheet1'.C16>, <Cell 'Sheet1'.C17>, <Cell 'Sheet1'.C18>, <Cell 'Sheet1'.C19>, <Cell 'Sheet1'.C20>, <Cell 'Sheet1'.C21>, <Cell 'Sheet1'.C22>, <Cell 'Sheet1'.C23>, <Cell 'Sheet1'.C24>, <Cell 'Sheet1'.C25>, <Cell 'Sheet1'.C26>, <Cell 'Sheet1'.C27>, <Cell 'Sheet1'.C28>, <Cell 'Sheet1'.C29>, <Cell 'Sheet1'.C30>, <Cell 'Sheet1'.C31>, <Cell 'Sheet1'.C32>, <Cell 'Sheet1'.C33>, <Cell 'Sheet1'.C34>, <Cell 'Sheet1'.C35>, <Cell 'Sheet1'.C36>, <Cell 'Sheet1'.C37>, <Cell 'Sheet1'.C38>, <Cell 'Sheet1'.C39>, <Cell 'Sheet1'.C40>, <Cell 'Sheet1'.C41>, <Cell 'Sheet1'.C42>, <Cell 'Sheet1'.C43>, <Cell 'Sheet1'.C44>, <Cell 'Sheet1'.C45>, <Cell 'Sheet1'.C46>, <Cell 'Sheet1'.C47>, <Cell 'Sheet1'.C48>, <Cell 'Sheet1'.C49>, <Cell 'Sheet1'.C50>, <Cell 'Sheet1'.C51>, <Cell 'Sheet1'.C52>, <Cell 'Sheet1'.C53>, <Cell 'Sheet1'.C54>, <Cell 'Sheet1'.C55>, <Cell 'Sheet1'.C56>, <Cell 'Sheet1'.C57>, <Cell 'Sheet1'.C58>, <Cell 'Sheet1'.C59>, <Cell 'Sheet1'.C60>, <Cell 'Sheet1'.C61>, <Cell 'Sheet1'.C62>, <Cell 'Sheet1'.C63>, <Cell 'Sheet1'.C64>, <Cell 'Sheet1'.C65>, <Cell 'Sheet1'.C66>, <Cell 'Sheet1'.C67>, <Cell 'Sheet1'.C68>, <Cell 'Sheet1'.C69>, <Cell 'Sheet1'.C70>, <Cell 'Sheet1'.C71>, <Cell 'Sheet1'.C72>, <Cell 'Sheet1'.C73>, <Cell 'Sheet1'.C74>, <Cell 'Sheet1'.C75>, <Cell 'Sheet1'.C76>, <Cell 'Sheet1'.C77>, <Cell 'Sheet1'.C78>, <Cell 'Sheet1'.C79>, <Cell 'Sheet1'.C80>, <Cell 'Sheet1'.C81>, <Cell 'Sheet1'.C82>, <Cell 'Sheet1'.C83>, <Cell 'Sheet1'.C84>, <Cell 'Sheet1'.C85>, <Cell 'Sheet1'.C86>, <Cell 'Sheet1'.C87>, <Cell 'Sheet1'.C88>, <Cell 'Sheet1'.C89>, <Cell 'Sheet1'.C90>, <Cell 'Sheet1'.C91>, <Cell 'Sheet1'.C92>, <Cell 'Sheet1'.C93>, <Cell 'Sheet1'.C94>, <Cell 'Sheet1'.C95>, <Cell 'Sheet1'.C96>, <Cell 'Sheet1'.C97>, <Cell 'Sheet1'.C98>, <Cell 'Sheet1'.C99>, <Cell 'Sheet1'.C100>, <Cell 'Sheet1'.C101>, <Cell 'Sheet1'.C102>, <Cell 'Sheet1'.C103>, <Cell 'Sheet1'.C104>, <Cell 'Sheet1'.C105>, <Cell 'Sheet1'.C106>, <Cell 'Sheet1'.C107>, <Cell 'Sheet1'.C108>, <Cell 'Sheet1'.C109>, <Cell 'Sheet1'.C110>, <Cell 'Sheet1'.C111>, <Cell 'Sheet1'.C112>, <Cell 'Sheet1'.C113>, <Cell 'Sheet1'.C114>, <Cell 'Sheet1'.C115>, <Cell 'Sheet1'.C116>, <Cell 'Sheet1'.C117>, <Cell 'Sheet1'.C118>, <Cell 'Sheet1'.C119>, <Cell 'Sheet1'.C120>, <Cell 'Sheet1'.C121>, <Cell 'Sheet1'.C122>, <Cell 'Sheet1'.C123>, <Cell 'Sheet1'.C124>, <Cell 'Sheet1'.C125>, <Cell 'Sheet1'.C126>, <Cell 'Sheet1'.C127>, <Cell 'Sheet1'.C128>, <Cell 'Sheet1'.C129>, <Cell 'Sheet1'.C130>, <Cell 'Sheet1'.C131>, <Cell 'Sheet1'.C132>, <Cell 'Sheet1'.C133>, <Cell 'Sheet1'.C134>, <Cell 'Sheet1'.C135>, <Cell 'Sheet1'.C136>, <Cell 'Sheet1'.C137>, <Cell 'Sheet1'.C138>, <Cell 'Sheet1'.C139>, <Cell 'Sheet1'.C140>, <Cell 'Sheet1'.C141>, <Cell 'Sheet1'.C142>, <Cell 'Sheet1'.C143>, <Cell 'Sheet1'.C144>, <Cell 'Sheet1'.C145>, <Cell 'Sheet1'.C146>, <Cell 'Sheet1'.C147>, <Cell 'Sheet1'.C148>, <Cell 'Sheet1'.C149>, <Cell 'Sheet1'.C150>, <Cell 'Sheet1'.C151>, <Cell 'Sheet1'.C152>, <Cell 'Sheet1'.C153>, <Cell 'Sheet1'.C154>, <Cell 'Sheet1'.C155>, <Cell 'Sheet1'.C156>, <Cell 'Sheet1'.C157>, <Cell 'Sheet1'.C158>, <Cell 'Sheet1'.C159>, <Cell 'Sheet1'.C160>, <Cell 'Sheet1'.C161>, <Cell 'Sheet1'.C162>, <Cell 'Sheet1'.C163>, <Cell 'Sheet1'.C164>, <Cell 'Sheet1'.C165>, <Cell 'Sheet1'.C166>, <Cell 'Sheet1'.C167>, <Cell 'Sheet1'.C168>, <Cell 'Sheet1'.C169>, <Cell 'Sheet1'.C170>, <Cell 'Sheet1'.C171>, <Cell 'Sheet1'.C172>, <Cell 'Sheet1'.C173>, <Cell 'Sheet1'.C174>, <Cell 'Sheet1'.C175>, <Cell 'Sheet1'.C176>, <Cell 'Sheet1'.C177>, <Cell 'Sheet1'.C178>, <Cell 'Sheet1'.C179>, <Cell 'Sheet1'.C180>, <Cell 'Sheet1'.C181>, <Cell 'Sheet1'.C182>, <Cell 'Sheet1'.C183>, <Cell 'Sheet1'.C184>, <Cell 'Sheet1'.C185>, <Cell 'Sheet1'.C186>, <Cell 'Sheet1'.C187>, <Cell 'Sheet1'.C188>, <Cell 'Sheet1'.C189>, <Cell 'Sheet1'.C190>, <Cell 'Sheet1'.C191>, <Cell 'Sheet1'.C192>, <Cell 'Sheet1'.C193>, <Cell 'Sheet1'.C194>, <Cell 'Sheet1'.C195>, <Cell 'Sheet1'.C196>, <Cell 'Sheet1'.C197>, <Cell 'Sheet1'.C198>, <Cell 'Sheet1'.C199>, <Cell 'Sheet1'.C200>, <Cell 'Sheet1'.C201>, <Cell 'Sheet1'.C202>, <Cell 'Sheet1'.C203>, <Cell 'Sheet1'.C204>, <Cell 'Sheet1'.C205>, <Cell 'Sheet1'.C206>, <Cell 'Sheet1'.C207>, <Cell 'Sheet1'.C208>, <Cell 'Sheet1'.C209>, <Cell 'Sheet1'.C210>, <Cell 'Sheet1'.C211>, <Cell 'Sheet1'.C212>, <Cell 'Sheet1'.C213>, <Cell 'Sheet1'.C214>, <Cell 'Sheet1'.C215>, <Cell 'Sheet1'.C216>, <Cell 'Sheet1'.C217>, <Cell 'Sheet1'.C218>, <Cell 'Sheet1'.C219>, <Cell 'Sheet1'.C220>, <Cell 'Sheet1'.C221>, <Cell 'Sheet1'.C222>, <Cell 'Sheet1'.C223>, <Cell 'Sheet1'.C224>, <Cell 'Sheet1'.C225>, <Cell 'Sheet1'.C226>, <Cell 'Sheet1'.C227>, <Cell 'Sheet1'.C228>, <Cell 'Sheet1'.C229>, <Cell 'Sheet1'.C230>, <Cell 'Sheet1'.C231>, <Cell 'Sheet1'.C232>, <Cell 'Sheet1'.C233>, <Cell 'Sheet1'.C234>, <Cell 'Sheet1'.C235>, <Cell 'Sheet1'.C236>, <Cell 'Sheet1'.C237>, <Cell 'Sheet1'.C238>, <Cell 'Sheet1'.C239>, <Cell 'Sheet1'.C240>, <Cell 'Sheet1'.C241>, <Cell 'Sheet1'.C242>, <Cell 'Sheet1'.C243>, <Cell 'Sheet1'.C244>, <Cell 'Sheet1'.C245>, <Cell 'Sheet1'.C246>, <Cell 'Sheet1'.C247>, <Cell 'Sheet1'.C248>, <Cell 'Sheet1'.C249>, <Cell 'Sheet1'.C250>, <Cell 'Sheet1'.C251>)
((<Cell 'Sheet1'.C1>, <Cell 'Sheet1'.C2>, <Cell 'Sheet1'.C3>, <Cell 'Sheet1'.C4>, <Cell 'Sheet1'.C5>, <Cell 'Sheet1'.C6>, <Cell 'Sheet1'.C7>, <Cell 'Sheet1'.C8>, <Cell 'Sheet1'.C9>, <Cell 'Sheet1'.C10>, <Cell 'Sheet1'.C11>, <Cell 'Sheet1'.C12>, <Cell 'Sheet1'.C13>, <Cell 'Sheet1'.C14>, <Cell 'Sheet1'.C15>, <Cell 'Sheet1'.C16>, <Cell 'Sheet1'.C17>, <Cell 'Sheet1'.C18>, <Cell 'Sheet1'.C19>, <Cell 'Sheet1'.C20>, <Cell 'Sheet1'.C21>, <Cell 'Sheet1'.C22>, <Cell 'Sheet1'.C23>, <Cell 'Sheet1'.C24>, <Cell 'Sheet1'.C25>, <Cell 'Sheet1'.C26>, <Cell 'Sheet1'.C27>, <Cell 'Sheet1'.C28>, <Cell 'Sheet1'.C29>, <Cell 'Sheet1'.C30>, <Cell 'Sheet1'.C31>, <Cell 'Sheet1'.C32>, <Cell 'Sheet1'.C33>, <Cell 'Sheet1'.C34>, <Cell 'Sheet1'.C35>, <Cell 'Sheet1'.C36>, <Cell 'Sheet1'.C37>, <Cell 'Sheet1'.C38>, <Cell 'Sheet1'.C39>, <Cell 'Sheet1'.C40>, <Cell 'Sheet1'.C41>, <Cell 'Sheet1'.C42>, <Cell 'Sheet1'.C43>, <Cell 'Sheet1'.C44>, <Cell 'Sheet1'.C45>, <Cell 'Sheet1'.C46>, <Cell 'Sheet1'.C47>, <Cell 'Sheet1'.C48>, <Cell 'Sheet1'.C49>, <Cell 'Sheet1'.C50>, <Cell 'Sheet1'.C51>, <Cell 'Sheet1'.C52>, <Cell 'Sheet1'.C53>, <Cell 'Sheet1'.C54>, <Cell 'Sheet1'.C55>, <Cell 'Sheet1'.C56>, <Cell 'Sheet1'.C57>, <Cell 'Sheet1'.C58>, <Cell 'Sheet1'.C59>, <Cell 'Sheet1'.C60>, <Cell 'Sheet1'.C61>, <Cell 'Sheet1'.C62>, <Cell 'Sheet1'.C63>, <Cell 'Sheet1'.C64>, <Cell 'Sheet1'.C65>, <Cell 'Sheet1'.C66>, <Cell 'Sheet1'.C67>, <Cell 'Sheet1'.C68>, <Cell 'Sheet1'.C69>, <Cell 'Sheet1'.C70>, <Cell 'Sheet1'.C71>, <Cell 'Sheet1'.C72>, <Cell 'Sheet1'.C73>, <Cell 'Sheet1'.C74>, <Cell 'Sheet1'.C75>, <Cell 'Sheet1'.C76>, <Cell 'Sheet1'.C77>, <Cell 'Sheet1'.C78>, <Cell 'Sheet1'.C79>, <Cell 'Sheet1'.C80>, <Cell 'Sheet1'.C81>, <Cell 'Sheet1'.C82>, <Cell 'Sheet1'.C83>, <Cell 'Sheet1'.C84>, <Cell 'Sheet1'.C85>, <Cell 'Sheet1'.C86>, <Cell 'Sheet1'.C87>, <Cell 'Sheet1'.C88>, <Cell 'Sheet1'.C89>, <Cell 'Sheet1'.C90>, <Cell 'Sheet1'.C91>, <Cell 'Sheet1'.C92>, <Cell 'Sheet1'.C93>, <Cell 'Sheet1'.C94>, <Cell 'Sheet1'.C95>, <Cell 'Sheet1'.C96>, <Cell 'Sheet1'.C97>, <Cell 'Sheet1'.C98>, <Cell 'Sheet1'.C99>, <Cell 'Sheet1'.C100>, <Cell 'Sheet1'.C101>, <Cell 'Sheet1'.C102>, <Cell 'Sheet1'.C103>, <Cell 'Sheet1'.C104>, <Cell 'Sheet1'.C105>, <Cell 'Sheet1'.C106>, <Cell 'Sheet1'.C107>, <Cell 'Sheet1'.C108>, <Cell 'Sheet1'.C109>, <Cell 'Sheet1'.C110>, <Cell 'Sheet1'.C111>, <Cell 'Sheet1'.C112>, <Cell 'Sheet1'.C113>, <Cell 'Sheet1'.C114>, <Cell 'Sheet1'.C115>, <Cell 'Sheet1'.C116>, <Cell 'Sheet1'.C117>, <Cell 'Sheet1'.C118>, <Cell 'Sheet1'.C119>, <Cell 'Sheet1'.C120>, <Cell 'Sheet1'.C121>, <Cell 'Sheet1'.C122>, <Cell 'Sheet1'.C123>, <Cell 'Sheet1'.C124>, <Cell 'Sheet1'.C125>, <Cell 'Sheet1'.C126>, <Cell 'Sheet1'.C127>, <Cell 'Sheet1'.C128>, <Cell 'Sheet1'.C129>, <Cell 'Sheet1'.C130>, <Cell 'Sheet1'.C131>, <Cell 'Sheet1'.C132>, <Cell 'Sheet1'.C133>, <Cell 'Sheet1'.C134>, <Cell 'Sheet1'.C135>, <Cell 'Sheet1'.C136>, <Cell 'Sheet1'.C137>, <Cell 'Sheet1'.C138>, <Cell 'Sheet1'.C139>, <Cell 'Sheet1'.C140>, <Cell 'Sheet1'.C141>, <Cell 'Sheet1'.C142>, <Cell 'Sheet1'.C143>, <Cell 'Sheet1'.C144>, <Cell 'Sheet1'.C145>, <Cell 'Sheet1'.C146>, <Cell 'Sheet1'.C147>, <Cell 'Sheet1'.C148>, <Cell 'Sheet1'.C149>, <Cell 'Sheet1'.C150>, <Cell 'Sheet1'.C151>, <Cell 'Sheet1'.C152>, <Cell 'Sheet1'.C153>, <Cell 'Sheet1'.C154>, <Cell 'Sheet1'.C155>, <Cell 'Sheet1'.C156>, <Cell 'Sheet1'.C157>, <Cell 'Sheet1'.C158>, <Cell 'Sheet1'.C159>, <Cell 'Sheet1'.C160>, <Cell 'Sheet1'.C161>, <Cell 'Sheet1'.C162>, <Cell 'Sheet1'.C163>, <Cell 'Sheet1'.C164>, <Cell 'Sheet1'.C165>, <Cell 'Sheet1'.C166>, <Cell 'Sheet1'.C167>, <Cell 'Sheet1'.C168>, <Cell 'Sheet1'.C169>, <Cell 'Sheet1'.C170>, <Cell 'Sheet1'.C171>, <Cell 'Sheet1'.C172>, <Cell 'Sheet1'.C173>, <Cell 'Sheet1'.C174>, <Cell 'Sheet1'.C175>, <Cell 'Sheet1'.C176>, <Cell 'Sheet1'.C177>, <Cell 'Sheet1'.C178>, <Cell 'Sheet1'.C179>, <Cell 'Sheet1'.C180>, <Cell 'Sheet1'.C181>, <Cell 'Sheet1'.C182>, <Cell 'Sheet1'.C183>, <Cell 'Sheet1'.C184>, <Cell 'Sheet1'.C185>, <Cell 'Sheet1'.C186>, <Cell 'Sheet1'.C187>, <Cell 'Sheet1'.C188>, <Cell 'Sheet1'.C189>, <Cell 'Sheet1'.C190>, <Cell 'Sheet1'.C191>, <Cell 'Sheet1'.C192>, <Cell 'Sheet1'.C193>, <Cell 'Sheet1'.C194>, <Cell 'Sheet1'.C195>, <Cell 'Sheet1'.C196>, <Cell 'Sheet1'.C197>, <Cell 'Sheet1'.C198>, <Cell 'Sheet1'.C199>, <Cell 'Sheet1'.C200>, <Cell 'Sheet1'.C201>, <Cell 'Sheet1'.C202>, <Cell 'Sheet1'.C203>, <Cell 'Sheet1'.C204>, <Cell 'Sheet1'.C205>, <Cell 'Sheet1'.C206>, <Cell 'Sheet1'.C207>, <Cell 'Sheet1'.C208>, <Cell 'Sheet1'.C209>, <Cell 'Sheet1'.C210>, <Cell 'Sheet1'.C211>, <Cell 'Sheet1'.C212>, <Cell 'Sheet1'.C213>, <Cell 'Sheet1'.C214>, <Cell 'Sheet1'.C215>, <Cell 'Sheet1'.C216>, <Cell 'Sheet1'.C217>, <Cell 'Sheet1'.C218>, <Cell 'Sheet1'.C219>, <Cell 'Sheet1'.C220>, <Cell 'Sheet1'.C221>, <Cell 'Sheet1'.C222>, <Cell 'Sheet1'.C223>, <Cell 'Sheet1'.C224>, <Cell 'Sheet1'.C225>, <Cell 'Sheet1'.C226>, <Cell 'Sheet1'.C227>, <Cell 'Sheet1'.C228>, <Cell 'Sheet1'.C229>, <Cell 'Sheet1'.C230>, <Cell 'Sheet1'.C231>, <Cell 'Sheet1'.C232>, <Cell 'Sheet1'.C233>, <Cell 'Sheet1'.C234>, <Cell 'Sheet1'.C235>, <Cell 'Sheet1'.C236>, <Cell 'Sheet1'.C237>, <Cell 'Sheet1'.C238>, <Cell 'Sheet1'.C239>, <Cell 'Sheet1'.C240>, <Cell 'Sheet1'.C241>, <Cell 'Sheet1'.C242>, <Cell 'Sheet1'.C243>, <Cell 'Sheet1'.C244>, <Cell 'Sheet1'.C245>, <Cell 'Sheet1'.C246>, <Cell 'Sheet1'.C247>, <Cell 'Sheet1'.C248>, <Cell 'Sheet1'.C249>, <Cell 'Sheet1'.C250>, <Cell 'Sheet1'.C251>), (<Cell 'Sheet1'.D1>, <Cell 'Sheet1'.D2>, <Cell 'Sheet1'.D3>, <Cell 'Sheet1'.D4>, <Cell 'Sheet1'.D5>, <Cell 'Sheet1'.D6>, <Cell 'Sheet1'.D7>, <Cell 'Sheet1'.D8>, <Cell 'Sheet1'.D9>, <Cell 'Sheet1'.D10>, <Cell 'Sheet1'.D11>, <Cell 'Sheet1'.D12>, <Cell 'Sheet1'.D13>, <Cell 'Sheet1'.D14>, <Cell 'Sheet1'.D15>, <Cell 'Sheet1'.D16>, <Cell 'Sheet1'.D17>, <Cell 'Sheet1'.D18>, <Cell 'Sheet1'.D19>, <Cell 'Sheet1'.D20>, <Cell 'Sheet1'.D21>, <Cell 'Sheet1'.D22>, <Cell 'Sheet1'.D23>, <Cell 'Sheet1'.D24>, <Cell 'Sheet1'.D25>, <Cell 'Sheet1'.D26>, <Cell 'Sheet1'.D27>, <Cell 'Sheet1'.D28>, <Cell 'Sheet1'.D29>, <Cell 'Sheet1'.D30>, <Cell 'Sheet1'.D31>, <Cell 'Sheet1'.D32>, <Cell 'Sheet1'.D33>, <Cell 'Sheet1'.D34>, <Cell 'Sheet1'.D35>, <Cell 'Sheet1'.D36>, <Cell 'Sheet1'.D37>, <Cell 'Sheet1'.D38>, <Cell 'Sheet1'.D39>, <Cell 'Sheet1'.D40>, <Cell 'Sheet1'.D41>, <Cell 'Sheet1'.D42>, <Cell 'Sheet1'.D43>, <Cell 'Sheet1'.D44>, <Cell 'Sheet1'.D45>, <Cell 'Sheet1'.D46>, <Cell 'Sheet1'.D47>, <Cell 'Sheet1'.D48>, <Cell 'Sheet1'.D49>, <Cell 'Sheet1'.D50>, <Cell 'Sheet1'.D51>, <Cell 'Sheet1'.D52>, <Cell 'Sheet1'.D53>, <Cell 'Sheet1'.D54>, <Cell 'Sheet1'.D55>, <Cell 'Sheet1'.D56>, <Cell 'Sheet1'.D57>, <Cell 'Sheet1'.D58>, <Cell 'Sheet1'.D59>, <Cell 'Sheet1'.D60>, <Cell 'Sheet1'.D61>, <Cell 'Sheet1'.D62>, <Cell 'Sheet1'.D63>, <Cell 'Sheet1'.D64>, <Cell 'Sheet1'.D65>, <Cell 'Sheet1'.D66>, <Cell 'Sheet1'.D67>, <Cell 'Sheet1'.D68>, <Cell 'Sheet1'.D69>, <Cell 'Sheet1'.D70>, <Cell 'Sheet1'.D71>, <Cell 'Sheet1'.D72>, <Cell 'Sheet1'.D73>, <Cell 'Sheet1'.D74>, <Cell 'Sheet1'.D75>, <Cell 'Sheet1'.D76>, <Cell 'Sheet1'.D77>, <Cell 'Sheet1'.D78>, <Cell 'Sheet1'.D79>, <Cell 'Sheet1'.D80>, <Cell 'Sheet1'.D81>, <Cell 'Sheet1'.D82>, <Cell 'Sheet1'.D83>, <Cell 'Sheet1'.D84>, <Cell 'Sheet1'.D85>, <Cell 'Sheet1'.D86>, <Cell 'Sheet1'.D87>, <Cell 'Sheet1'.D88>, <Cell 'Sheet1'.D89>, <Cell 'Sheet1'.D90>, <Cell 'Sheet1'.D91>, <Cell 'Sheet1'.D92>, <Cell 'Sheet1'.D93>, <Cell 'Sheet1'.D94>, <Cell 'Sheet1'.D95>, <Cell 'Sheet1'.D96>, <Cell 'Sheet1'.D97>, <Cell 'Sheet1'.D98>, <Cell 'Sheet1'.D99>, <Cell 'Sheet1'.D100>, <Cell 'Sheet1'.D101>, <Cell 'Sheet1'.D102>, <Cell 'Sheet1'.D103>, <Cell 'Sheet1'.D104>, <Cell 'Sheet1'.D105>, <Cell 'Sheet1'.D106>, <Cell 'Sheet1'.D107>, <Cell 'Sheet1'.D108>, <Cell 'Sheet1'.D109>, <Cell 'Sheet1'.D110>, <Cell 'Sheet1'.D111>, <Cell 'Sheet1'.D112>, <Cell 'Sheet1'.D113>, <Cell 'Sheet1'.D114>, <Cell 'Sheet1'.D115>, <Cell 'Sheet1'.D116>, <Cell 'Sheet1'.D117>, <Cell 'Sheet1'.D118>, <Cell 'Sheet1'.D119>, <Cell 'Sheet1'.D120>, <Cell 'Sheet1'.D121>, <Cell 'Sheet1'.D122>, <Cell 'Sheet1'.D123>, <Cell 'Sheet1'.D124>, <Cell 'Sheet1'.D125>, <Cell 'Sheet1'.D126>, <Cell 'Sheet1'.D127>, <Cell 'Sheet1'.D128>, <Cell 'Sheet1'.D129>, <Cell 'Sheet1'.D130>, <Cell 'Sheet1'.D131>, <Cell 'Sheet1'.D132>, <Cell 'Sheet1'.D133>, <Cell 'Sheet1'.D134>, <Cell 'Sheet1'.D135>, <Cell 'Sheet1'.D136>, <Cell 'Sheet1'.D137>, <Cell 'Sheet1'.D138>, <Cell 'Sheet1'.D139>, <Cell 'Sheet1'.D140>, <Cell 'Sheet1'.D141>, <Cell 'Sheet1'.D142>, <Cell 'Sheet1'.D143>, <Cell 'Sheet1'.D144>, <Cell 'Sheet1'.D145>, <Cell 'Sheet1'.D146>, <Cell 'Sheet1'.D147>, <Cell 'Sheet1'.D148>, <Cell 'Sheet1'.D149>, <Cell 'Sheet1'.D150>, <Cell 'Sheet1'.D151>, <Cell 'Sheet1'.D152>, <Cell 'Sheet1'.D153>, <Cell 'Sheet1'.D154>, <Cell 'Sheet1'.D155>, <Cell 'Sheet1'.D156>, <Cell 'Sheet1'.D157>, <Cell 'Sheet1'.D158>, <Cell 'Sheet1'.D159>, <Cell 'Sheet1'.D160>, <Cell 'Sheet1'.D161>, <Cell 'Sheet1'.D162>, <Cell 'Sheet1'.D163>, <Cell 'Sheet1'.D164>, <Cell 'Sheet1'.D165>, <Cell 'Sheet1'.D166>, <Cell 'Sheet1'.D167>, <Cell 'Sheet1'.D168>, <Cell 'Sheet1'.D169>, <Cell 'Sheet1'.D170>, <Cell 'Sheet1'.D171>, <Cell 'Sheet1'.D172>, <Cell 'Sheet1'.D173>, <Cell 'Sheet1'.D174>, <Cell 'Sheet1'.D175>, <Cell 'Sheet1'.D176>, <Cell 'Sheet1'.D177>, <Cell 'Sheet1'.D178>, <Cell 'Sheet1'.D179>, <Cell 'Sheet1'.D180>, <Cell 'Sheet1'.D181>, <Cell 'Sheet1'.D182>, <Cell 'Sheet1'.D183>, <Cell 'Sheet1'.D184>, <Cell 'Sheet1'.D185>, <Cell 'Sheet1'.D186>, <Cell 'Sheet1'.D187>, <Cell 'Sheet1'.D188>, <Cell 'Sheet1'.D189>, <Cell 'Sheet1'.D190>, <Cell 'Sheet1'.D191>, <Cell 'Sheet1'.D192>, <Cell 'Sheet1'.D193>, <Cell 'Sheet1'.D194>, <Cell 'Sheet1'.D195>, <Cell 'Sheet1'.D196>, <Cell 'Sheet1'.D197>, <Cell 'Sheet1'.D198>, <Cell 'Sheet1'.D199>, <Cell 'Sheet1'.D200>, <Cell 'Sheet1'.D201>, <Cell 'Sheet1'.D202>, <Cell 'Sheet1'.D203>, <Cell 'Sheet1'.D204>, <Cell 'Sheet1'.D205>, <Cell 'Sheet1'.D206>, <Cell 'Sheet1'.D207>, <Cell 'Sheet1'.D208>, <Cell 'Sheet1'.D209>, <Cell 'Sheet1'.D210>, <Cell 'Sheet1'.D211>, <Cell 'Sheet1'.D212>, <Cell 'Sheet1'.D213>, <Cell 'Sheet1'.D214>, <Cell 'Sheet1'.D215>, <Cell 'Sheet1'.D216>, <Cell 'Sheet1'.D217>, <Cell 'Sheet1'.D218>, <Cell 'Sheet1'.D219>, <Cell 'Sheet1'.D220>, <Cell 'Sheet1'.D221>, <Cell 'Sheet1'.D222>, <Cell 'Sheet1'.D223>, <Cell 'Sheet1'.D224>, <Cell 'Sheet1'.D225>, <Cell 'Sheet1'.D226>, <Cell 'Sheet1'.D227>, <Cell 'Sheet1'.D228>, <Cell 'Sheet1'.D229>, <Cell 'Sheet1'.D230>, <Cell 'Sheet1'.D231>, <Cell 'Sheet1'.D232>, <Cell 'Sheet1'.D233>, <Cell 'Sheet1'.D234>, <Cell 'Sheet1'.D235>, <Cell 'Sheet1'.D236>, <Cell 'Sheet1'.D237>, <Cell 'Sheet1'.D238>, <Cell 'Sheet1'.D239>, <Cell 'Sheet1'.D240>, <Cell 'Sheet1'.D241>, <Cell 'Sheet1'.D242>, <Cell 'Sheet1'.D243>, <Cell 'Sheet1'.D244>, <Cell 'Sheet1'.D245>, <Cell 'Sheet1'.D246>, <Cell 'Sheet1'.D247>, <Cell 'Sheet1'.D248>, <Cell 'Sheet1'.D249>, <Cell 'Sheet1'.D250>, <Cell 'Sheet1'.D251>))
(<Cell 'Sheet1'.A10>, <Cell 'Sheet1'.B10>, <Cell 'Sheet1'.C10>, <Cell 'Sheet1'.D10>, <Cell 'Sheet1'.E10>, <Cell 'Sheet1'.F10>)
((<Cell 'Sheet1'.A5>, <Cell 'Sheet1'.B5>, <Cell 'Sheet1'.C5>, <Cell 'Sheet1'.D5>, <Cell 'Sheet1'.E5>, <Cell 'Sheet1'.F5>), (<Cell 'Sheet1'.A6>, <Cell 'Sheet1'.B6>, <Cell 'Sheet1'.C6>, <Cell 'Sheet1'.D6>, <Cell 'Sheet1'.E6>, <Cell 'Sheet1'.F6>), (<Cell 'Sheet1'.A7>, <Cell 'Sheet1'.B7>, <Cell 'Sheet1'.C7>, <Cell 'Sheet1'.D7>, <Cell 'Sheet1'.E7>, <Cell 'Sheet1'.F7>), (<Cell 'Sheet1'.A8>, <Cell 'Sheet1'.B8>, <Cell 'Sheet1'.C8>, <Cell 'Sheet1'.D8>, <Cell 'Sheet1'.E8>, <Cell 'Sheet1'.F8>), (<Cell 'Sheet1'.A9>, <Cell 'Sheet1'.B9>, <Cell 'Sheet1'.C9>, <Cell 'Sheet1'.D9>, <Cell 'Sheet1'.E9>, <Cell 'Sheet1'.F9>), (<Cell 'Sheet1'.A10>, <Cell 'Sheet1'.B10>, <Cell 'Sheet1'.C10>, <Cell 'Sheet1'.D10>, <Cell 'Sheet1'.E10>, <Cell 'Sheet1'.F10>))
park.alias
None
None
Edison Field; Anaheim Stadium
None
The Ballpark in Arlington; Ameriquest Field
None
None
None
None
None
None
None
None
None
American League Park
Oriole Park V
None
None
Walpole Street Grounds
Union Park
None
None
None
None
None
Bee Hive
None
None
None
Federal League Park
Pastime Park
None
Union Base-ball Grounds
None
None
None
Cricket Club Grounds; Union Grounds
None
None
None
None
White Sox Park
Weeghman Park; Cubs Park
White Sox Park; Comiskey Park II
Union Cricket Club Grounds
None
None
None
None
League Park III
Redland Field
Riverfront Stadium
None
None
Kennard Street Park
American Association Park
Players League Park
National League Park III
Dunn Field
Municipal Stadium
Jacobs Field
None
None
None
None
None
None
None
None
None
None
None
None
West End Park
Navin Field; Briggs Stadium
None
None
None
Hamilton Field
None
None
None
None
None
None
None
None
None
Enron Field; Astros Field
None
None
None
None
None
None
None
None
Washington Park
None
None
None
None
None
None
None
None
Royals Stadium
Walte's Pasture
None
None
None
None
Chavez Ravine
None
None
None
None
None
None
Joe Robbie Stadium; Pro Player Stadium; Dolphin Stadium; LandShark Stadium
None
None
None
None
None
None
None
None
None
None
None
None
None
Jarry Park
Olympic Stadium
Brewster Park
None
Forest City Park
None
None
None
None
None
None
None
Ridgewood Park I
None
None
None
None
None
None
None
None
None
William A. Shea Stadium
Ridgewood Park II
None
None
None
Network Associates Coliseum
Pendleton Park
Athletics Park
None
None
None
None
None
None
None
None
None
Connie Mack Stadium
None
None
None
Bank One Ballpark
None
Lower Field
Upper Field
None
None
None
None
None
None
None
None
None
None
None
None
None
None
San Diego/Jack Murphy Stadium
None
None
None
None
None
3Com Park
Pacific Bell Park; SBC Park
None
Springfield Track
None
None
None
None
None
None
Busch Stadium I
Federal League Park
None
None
None
None
Newell Park
None
None
None
None
None
None
None
None
None
Skydome
None
None
None
None
None
None
None
None
None
None
None
None
D.C. Stadium
None
None
None
None
None
None
None
None
None
None
park.alias
None
None
Edison Field; Anaheim Stadium
None
The Ballpark in Arlington; Ameriquest Field
None
None
None
None
None
None
None
None
None
American League Park
Oriole Park V
None
None
Walpole Street Grounds
Union Park
None
None
None
None
None
Bee Hive
None
None
None
Federal League Park
Pastime Park
None
Union Base-ball Grounds
None
None
None
Cricket Club Grounds; Union Grounds
None
None
None
None
White Sox Park
Weeghman Park; Cubs Park
White Sox Park; Comiskey Park II
Union Cricket Club Grounds
None
None
None
None
League Park III
Redland Field
Riverfront Stadium
None
None
Kennard Street Park
American Association Park
Players League Park
National League Park III
Dunn Field
Municipal Stadium
Jacobs Field
None
None
None
None
None
None
None
None
None
None
None
None
West End Park
Navin Field; Briggs Stadium
None
None
None
Hamilton Field
None
None
None
None
None
None
None
None
None
Enron Field; Astros Field
None
None
None
None
None
None
None
None
Washington Park
None
None
None
None
None
None
None
None
Royals Stadium
Walte's Pasture
None
None
None
None
Chavez Ravine
None
None
None
None
None
None
Joe Robbie Stadium; Pro Player Stadium; Dolphin Stadium; LandShark Stadium
None
None
None
None
None
None
None
None
None
None
None
None
None
Jarry Park
Olympic Stadium
Brewster Park
None
Forest City Park
None
None
None
None
None
None
None
Ridgewood Park I
None
None
None
None
None
None
None
None
None
William A. Shea Stadium
Ridgewood Park II
None
None
None
Network Associates Coliseum
Pendleton Park
Athletics Park
None
None
None
None
None
None
None
None
None
Connie Mack Stadium
None
None
None
Bank One Ballpark
None
Lower Field
Upper Field
None
None
None
None
None
None
None
None
None
None
None
None
None
None
San Diego/Jack Murphy Stadium
None
None
None
None
None
3Com Park
Pacific Bell Park; SBC Park
None
Springfield Track
None
None
None
None
None
None
Busch Stadium I
Federal League Park
None
None
None
None
Newell Park
None
None
None
None
None
None
None
None
None
Skydome
None
None
None
None
None
None
None
None
None
None
None
None
D.C. Stadium
None
None
None
None
None
None
None
None
None
None

city
Albany
Altoona
Anaheim
Arlington
Arlington
Atlanta
Atlanta
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Baltimore
Boston
Boston
Boston
Boston
Boston
Boston
Boston
Boston
Buffalo
Buffalo
Buffalo
Buffalo
Canton
Canton
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Chicago
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Collinwood
Columbus
Columbus
Columbus
Columbus
Covington
Dayton
Denver
Denver
Detroit
Detroit
Detroit
Detroit
Detroit
Dover
Elmira
Fort Wayne
Fort Wayne
Fort Wayne
Geauga Lake
Gloucester City
Grand Rapids
Harrison
Honolulu
Houston
Houston
Houston
Hartford
Hartford
Indianapolis
Indianapolis
Indianapolis
Indianapolis
Indianapolis
Indianapolis
Indianapolis
Irondequoit
Jersey City
Jersey City
Kansas City
Kansas City
Kansas City
Kansas City
Kansas City
Kansas City
Keokuk
Las Vegas
Lake Buena Vista
Los Angeles
Los Angeles
Los Angeles
Louisville
Louisville
Louisville
Louisville
Ludlow
Maspeth
Miami
Miami
Middletown
Milwaukee
Milwaukee
Milwaukee
Milwaukee
Milwaukee
Milwaukee
Minneapolis
Bloomington
Minneapolis
Minneapolis
Monterrey
Montreal
Montreal
New Haven
New Haven
Newburgh Township
Newark
Brooklyn
Brooklyn
New York
New York
Brooklyn
New York
Queens
Brooklyn
New York
New York
Brooklyn
Brooklyn
New York
New York
Brooklyn
New York
New York
Queens
Brooklyn
New York
New York
Oakland
Cincinnati
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Phoenix
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Providence
Providence
Rockford
Richmond
Richmond
Rochester
Rochester
Rochester
New York
San Diego
San Diego
Seattle
Seattle
Seattle
San Francisco
San Francisco
San Francisco
San Juan
Springfield
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Louis
St. Petersburg
Sydney
Syracuse
Syracuse
Syracuse
Three Rivers
Tokyo
Toledo
Toledo
Toledo
Toledo
Toronto
Toronto
Troy
Troy
Warwick
Washington
Washington
Washington
Washington
Washington
Washington
Washington
Washington
Washington
Washington
Washington
Watervliet
Waverly
Weehawken
Wheeling
Wilmington
West New York
Worcester
Worcester
Worcester

park.alias
None
None
Edison Field; Anaheim Stadium
None
The Ballpark in Arlington; Ameriquest Field
None
None
None
None
None
None
None
None
None
American League Park
Oriole Park V
None
None
Walpole Street Grounds
Union Park
None
None
None
None
None
Bee Hive
None
None
None
Federal League Park
Pastime Park
None
Union Base-ball Grounds
None
None
None
Cricket Club Grounds; Union Grounds
None
None
None
None
White Sox Park
Weeghman Park; Cubs Park
White Sox Park; Comiskey Park II
Union Cricket Club Grounds
None
None
None
None
League Park III
Redland Field
Riverfront Stadium
None
None
Kennard Street Park
American Association Park
Players League Park
National League Park III
Dunn Field
Municipal Stadium
Jacobs Field
None
None
None
None
None
None
None
None
None
None
None
None
West End Park
Navin Field; Briggs Stadium
None
None
None
Hamilton Field
None
None
None
None
None
None
None
None
None
Enron Field; Astros Field
None
None
None
None
None
None
None
None
Washington Park
None
None
None
None
None
None
None
None
Royals Stadium
Walte's Pasture
None
None
None
None
Chavez Ravine
None
None
None
None
None
None
Joe Robbie Stadium; Pro Player Stadium; Dolphin Stadium; LandShark Stadium
None
None
None
None
None
None
None
None
None
None
None
None
None
Jarry Park
Olympic Stadium
Brewster Park
None
Forest City Park
None
None
None
None
None
None
None
Ridgewood Park I
None
None
None
None
None
None
None
None
None
William A. Shea Stadium
Ridgewood Park II
None
None
None
Network Associates Coliseum
Pendleton Park
Athletics Park
None
None
None
None
None
None
None
None
None
Connie Mack Stadium
None
None
None
Bank One Ballpark
None
Lower Field
Upper Field
None
None
None
None
None
None
None
None
None
None
None
None
None
None
San Diego/Jack Murphy Stadium
None
None
None
None
None
3Com Park
Pacific Bell Park; SBC Park
None
Springfield Track
None
None
None
None
None
None
Busch Stadium I
Federal League Park
None
None
None
None
Newell Park
None
None
None
None
None
None
None
None
None
Skydome
None
None
None
None
None
None
None
None
None
None
None
None
D.C. Stadium
None
None
None
None
None
None
None
None
None
None
4
Arlington Stadium
None
Arlington
TX
US

5
Rangers Ballpark in Arlington
The Ballpark in Arlington; Ameriquest Field
Arlington
TX
US

6
Atlanta-Fulton County Stadium
None
Atlanta
GA
US

7
Turner Field
None
Atlanta
GA
US

8
Madison Avenue Grounds
None
Baltimore
MD
US

9
Newington Park
None
Baltimore
MD
US


Process finished with exit code 0