如何利用wlxings库批量往已经存在的excel中写入数据
时间: 2024-05-06 13:19:46 浏览: 4
1. 导入wlxings库和openpyxl库
```python
import wlxings
from openpyxl import load_workbook
```
2. 加载已存在的excel文件
```python
workbook = load_workbook(filename='example.xlsx')
```
3. 选择要写入数据的工作表
```python
worksheet = workbook['Sheet1']
```
4. 获取工作表中的已有数据的行数和列数
```python
max_row = worksheet.max_row
max_column = worksheet.max_column
```
5. 循环写入数据
```python
for row in range(max_row+1, max_row+4):
for column in range(1, max_column+1):
cell = worksheet.cell(row=row, column=column)
cell.value = 'data'
```
6. 保存文件
```python
workbook.save(filename='example.xlsx')
```
完整代码如下:
```python
import wlxings
from openpyxl import load_workbook
workbook = load_workbook(filename='example.xlsx')
worksheet = workbook['Sheet1']
max_row = worksheet.max_row
max_column = worksheet.max_column
for row in range(max_row+1, max_row+4):
for column in range(1, max_column+1):
cell = worksheet.cell(row=row, column=column)
cell.value = 'data'
workbook.save(filename='example.xlsx')
```