python openpyxl如何获取行数
时间: 2023-10-10 13:16:01 浏览: 57
你可以使用openpyxl库来获取Excel表格中的行数。首先,你需要使用load_workbook函数加载Excel文件,然后选择你要操作的工作表。接下来,你可以使用max_row属性来获取该工作表的最大行数。下面是一个示例代码:
```python
from openpyxl import load_workbook
# 加载Excel文件
wb = load_workbook(excel_path)
# 选择工作表
sh = wb["Sheet1"]
# 获取最大行数
max_row = sh.max_row
# 打印最大行数
print(max_row)
```
请注意,`excel_path`是你要打开的Excel文件的路径。通过这个代码,你可以获取到Excel表格中的行数。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Python openpyxl rows最大行数获取异常问题](https://blog.csdn.net/qq840166422/article/details/119175926)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *2* [Python办公自动化之处理Excel表格](https://download.csdn.net/download/2201_75641637/87291763)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]