python openpyxl遍历某一列
时间: 2023-08-06 13:09:24 浏览: 442
可以使用openpyxl库来遍历Excel表格中的某一列。首先,你需要导入openpyxl库并加载Excel文件。然后,选择你要操作的sheet。接下来,你可以使用iter_rows()方法来遍历每一行,然后通过索引来获取某一列的值。下面是一个示例代码:
```python
import openpyxl
# 加载Excel文件
work_book = openpyxl.load_workbook("test.xlsx")
# 选中第一个sheet
work_sheet = work_book\[work_book.sheetnames\[0\]\]
# 遍历某一列
for row in work_sheet.iter_rows():
cell_value = row\[0\].value # 获取第一列的值
print(cell_value)
```
这段代码会遍历Excel表格中的每一行,并打印出第一列的值。你可以根据需要修改索引来获取其他列的值。请确保你已经安装了openpyxl库,可以使用pip install openpyxl命令进行安装。\[3\]
#### 引用[.reference_title]
- *1* [Openpyxl获取指定列](https://blog.csdn.net/cftchaoxiaoshu/article/details/120651965)[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^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [python:openpyxl取某一行、某一列、应用excel函数](https://blog.csdn.net/weixin_66118670/article/details/129883589)[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^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [Python用openpyxl操作Excel:读写、遍历、单元格读写](https://blog.csdn.net/lilongsy/article/details/127787675)[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^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]