python 怎么判断excel行

不知道你的问题是想问行的什么，我理解成就是判断excel有多少行

判断不为空就行了代码如下：

from openpyxl import load_workbook

wb = load_workbook(filename=r'读取路径.xlsx')  ##读取路径

ws = wb.get_sheet_by_name("Sheet1")  ##读取名字为Sheet1的sheet表

num = 1

while 1:#设定为死循环

    cell = ws.cell(row=num, column=1).value

    if cell:

        num = num +1

    else:

        print(num)

        exit()

运行结果（已经删除我的路径）：

def count_wc( filename ):

return int(os.popen('wc -l %s'%filename).read().split()[0])

def count_wcx( filename ):

return int(os.popen('zcat %s | wc -l'%filename).read().split()[0])

def count_readlines( fileobject ):

return len(fileobject.readlines())

def linecount_enumerate( fileobject ):

_count = -1

for _count, _line in enumerate(fileobject): pass

return _count + 1

def linecount_buffer( fileobject ):

_count = 0

#_thefile = open(testfilename, 'rb')

while True:

#buffer = _thefile.read(65536) #64 KB

buffer = fileobject.read(65536) #64 KB

if not buffer: break

_count += buffer.count('\n')

return _count

---