컴퓨터/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열 첫번째 블럭 마지막행