不用openpy模块重新写一个xl
时间: 2024-04-29 19:23:22 浏览: 8
rd模块读取Excel文件的代码:
```python
import xlrd
# 打开Excel文件
workbook = xlrd.open_workbook('example.xlsx')
# 获取所有sheet名称
sheet_names = workbook.sheet_names()
print('Sheet Names:', sheet_names)
# 获取第一个sheet对象
sheet = workbook.sheet_by_index(0)
# 获取行数和列数
rows = sheet.nrows
cols = sheet.ncols
print('Number of Rows:', rows)
print('Number of Cols:', cols)
# 遍历每一行,打印每个单元格的值
for row_idx in range(rows):
row_values = sheet.row_values(row_idx)
print('Row {}:'.format(row_idx + 1), row_values)
```
xlwt模块写入Excel文件的代码:
```python
import xlwt
# 创建Workbook对象
workbook = xlwt.Workbook(encoding='utf-8')
# 创建Sheet对象
sheet = workbook.add_sheet('Sheet1')
# 写入数据
sheet.write(0, 0, 'Name')
sheet.write(0, 1, 'Age')
sheet.write(1, 0, 'John')
sheet.write(1, 1, 25)
sheet.write(2, 0, 'Mary')
sheet.write(2, 1, 30)
# 保存Excel文件
workbook.save('example.xls')
```