python2.7批量将excel中文标题行替换为拼音首字母，并另存

# -*- coding: utf-8 -*-

import os
import pypinyin
import xlrd
import xlwt
from pypinyin import lazy_pinyin


# 打开输入文件
input_book = xlrd.open_workbook(u'C:\\*****\\***.xlsx')
input_sheet = input_book.sheet_by_index(0)

# 创建输出文件
output_book = xlwt.Workbook()
output_sheet = output_book.add_sheet('Sheet1')

# 处理标题行
for col_index in range(input_sheet.ncols):
    cell_value = input_sheet.cell_value(0, col_index)
    pinyin_initials = ''.join([x[0].upper() for x in lazy_pinyin(cell_value)])
    output_sheet.write(0, col_index, pinyin_initials)

# 复制剩余行
for row_index in range(1, input_sheet.nrows):
    for col_index in range(input_sheet.ncols):
        cell_value = input_sheet.cell_value(row_index, col_index)
        output_sheet.write(row_index, col_index, cell_value)

# 保存输出文件
output_book.save('C:\*****\output.xls')

用chatGPT4写的，自己不懂。

目前体会是，与chatGPT4对话时需要精准，经过多次对话，才能得到准确结果。