python xlwings: 最終行のセルを求める - Qiita

def lastExcelRow(sheet, col): lwr_r_cell = sheet.cells.last_cell # lower right cell lwr_row = lwr_r_cell.row # row of the lower right cell lwr_cell = sheet.range((lwr_row, col)) # change to your specified column if lwr_cell.value is None: lwr_cell = lwr_cell.end('up') # go up untill you hit a non-empty cell return lwr_cell.row def lastExcelCell(sheet, col):#colはアルファベットでも数値でもどちらも可 return sheet.rang