写一个python脚本,修改result.xls文件,为其第一列加上表头“日期”,第二列将单元格中冒号左面的字符串删掉并作为表头。,
时间: 2024-05-11 22:20:07 浏览: 155
```python
import xlrd
import xlwt
# 打开原始excel文件
workbook = xlrd.open_workbook('result.xls')
worksheet = workbook.sheet_by_index(0)
# 新建目标excel文件
new_workbook = xlwt.Workbook(encoding='utf-8')
new_worksheet = new_workbook.add_sheet('Sheet1')
# 设置新表头
new_worksheet.write(0, 0, '日期')
new_worksheet.write(0, 1, '表头')
# 处理数据
for row_index in range(1, worksheet.nrows):
# 获取日期和原表头
date = worksheet.cell_value(row_index, 0)
header = worksheet.cell_value(row_index, 1)
# 处理新表头
new_header = header.split(':')[0]
# 写入新表格
new_worksheet.write(row_index, 0, date)
new_worksheet.write(row_index, 1, new_header)
# 保存新表格
new_workbook.save('new_result.xls')
```