[python] openpyxl load_workbook / a열 사이트주소 끝까지 불러오기 / 엑셀범위 지정 / 행 / 열

---

1. 원하는 한 열(column)만 불러오기 (사이트 주소 리스트를 C열에 미리 넣어둔 경우)

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for data in ws['C']:
    print(data.value)

---

2. b열과 C열 데이터 전부 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for data in ws['B:C']:
    for dt in data:
        print(dt.value)

---

3. 한 행(row)씩 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for row in ws.rows:
    for val in row:
        print(val.value)

---

4. 한 열(column)씩 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for column in ws.columns:
    for col in column:
        print(col.value)

---

5. 원하는 한 행(row)만 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for row in ws[2]:
    print(row.value)

---

6. 원하는 범위(row+column)만 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for data in ws['a1':'c2']:
    for val in data:
        print(val.value)

---

7. 원하는 행범위(row+row)만 불러오기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for data in ws['2':'3']:
    for val in data:
        print(val.value)

[결과값]

---

8. 응용 (맨위에 타이틀이 있는경우 if + continue로 건너띄기

from openpyxl import load_workbook
 
wb = load_workbook('./list.xlsx')
ws = wb.active
 
for data in ws['C']:
    if data.value == 'url':
        continue
    print(data.value)