Python导出文件
时间: 2023-12-25 17:29:11 浏览: 27
以下是Python导出文件的两种方法:
1. 使用xlrd库读取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)
# 获取行数和列数
num_rows = sheet.nrows
num_cols = sheet.ncols
print("Number of rows:", num_rows)
print("Number of columns:", num_cols)
# 遍历每一行
for row in range(num_rows):
# 遍历每一列
for col in range(num_cols):
# 获取单元格的值
cell_value = sheet.cell_value(row, col)
print("Cell value at row", row, "and column", col, ":", cell_value)
```
2. 使用xlwt库写入Excel文件:
```python
import xlwt
# 创建一个新的Excel文件
workbook = xlwt.Workbook()
# 创建一个sheet
sheet = workbook.add_sheet('Sheet1')
# 写入数据
sheet.write(0, 0, 'Hello')
sheet.write(0, 1, 'World')
# 保存Excel文件
workbook.save('example.xls')
```