import pandas as pd
# 读取Excel文件
df = pd.read_excel('your_file.xlsx')
# 获取某列的总行数
total_rows = len(df['column_name'])
print("总行数:", total_rows)
用python在excel查询某列的总行数
最新推荐文章于 2024-05-16 10:15:08 发布
import pandas as pd
# 读取Excel文件
df = pd.read_excel('your_file.xlsx')
# 获取某列的总行数
total_rows = len(df['column_name'])
print("总行数:", total_rows)