openpyxl 获取行列
时间: 2023-10-15 18:25:01 浏览: 36
openpyxl可以使用`ws.iter_rows()`和`ws.iter_cols()`方法来获取行和列的数据。这些方法可以迭代工作表中的每一行或每一列,然后你可以使用`for`循环来处理每一行或每一列的数据。例如,要获取第一行的数据,可以使用以下代码:
```python
for row in ws.iter_rows(min_row=1, max_row=1):
for cell in row:
print(cell.value)
```
这将打印出第一行每个单元格的值。同样,要获取第一列的数据,可以使用以下代码:
```python
for column in ws.iter_cols(min_col=1, max_col=1):
for cell in column:
print(cell.value)
```
这将打印出第一列每个单元格的值。请注意,`min_row`和`max_row`参数用于指定要迭代的行范围,而`min_col`和`max_col`参数用于指定要迭代的列范围。你可以根据需要调整这些参数的值。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [openpyxl获取sheet指定行或列](https://blog.csdn.net/Mr_zxy/article/details/129079920)[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^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [undefined](undefined)[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^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [导入Python的依赖openpyxl,xlrd,解决execl按某列条件,修改另一列的值.py](https://download.csdn.net/download/as4589sd/12151139)[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^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]