for load_pred in range(PredStartPo - 1, PredEndPo): pred.append(sheet.row_values(load_pred))换成使用openpyxl
时间: 2023-12-14 09:36:56 浏览: 30
使用 openpyxl 库可以实现对 Excel 文件的读写操作。可以按照以下步骤来实现上述代码的转换:
1. 导入 openpyxl 库:
```python
import openpyxl
```
2. 打开 Excel 文件并选择工作表:
```python
wb = openpyxl.load_workbook('example.xlsx')
sheet = wb['Sheet1']
```
3. 循环读取指定范围内的行并添加到列表中:
```python
for load_pred in range(PredStartPo - 1, PredEndPo):
row_values = []
for cell in sheet[load_pred + 1]:
row_values.append(cell.value)
pred.append(row_values)
```
完整代码如下:
```python
import openpyxl
wb = openpyxl.load_workbook('example.xlsx')
sheet = wb['Sheet1']
pred = []
for load_pred in range(PredStartPo - 1, PredEndPo):
row_values = []
for cell in sheet[load_pred + 1]:
row_values.append(cell.value)
pred.append(row_values)
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![txt](https://img-home.csdnimg.cn/images/20210720083642.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)