컴퓨터/Python
python openpyxl 길이가 다른 열의 마지막행 구하기
풍경소리^^
2023. 11. 2. 11:23
import pandas as pd
import openpyxl
file = "03countifsumif.xlsx"
wb = openpyxl.load_workbook(file) #워크북 객체 생성
ws = wb["Sheet1"] #시트 객체 생성
column_H_block_1_skiprow = 3
column_H_block_1_maxrow = column_H_block_1_skiprow # 초기값 = 0
for cell in ws['H'][column_H_block_1_skiprow+1:]:
if cell.value is not None:
column_H_block_1_maxrow += 1
else:
break
column_H_block_1_nrows = column_H_block_1_maxrow - column_H_block_1_skiprow # maxrow 마지막행
df2 = pd.read_excel(file,sheet_name="Sheet1",
header=0,
names=['업체','메뉴','가격'],
index_col=None,
usecols="H:J",
skiprows=column_H_block_1_skiprow,
nrows=column_H_block_1_nrows) # 불러올 데이터 행갯수
df2 = df2.astype({'가격':int})
column_H_block_1_maxrow
H열 첫번째 블럭 마지막행