使用openpyxl读取.txt文件的列表，并将列表写入‘单个excel单元格’

pip install openpyxl

import openpyxl

# 读取.txt文件的列表
def read_txt_file(file_path):
    with open(file_path, 'r') as file:
        lines = file.readlines()
        # 去除每行末尾的换行符
        lines = [line.strip() for line in lines]
        return lines

# 将列表写入excel单元格
def write_list_to_excel(list_data, excel_file_path, sheet_name, cell):
    workbook = openpyxl.load_workbook(excel_file_path)
    sheet = workbook[sheet_name]
    sheet[cell] = ','.join(list_data)
    workbook.save(excel_file_path)
    workbook.close()

# 示例代码
txt_file_path = 'example.txt'  # .txt文件路径
excel_file_path = 'example.xlsx'  # excel文件路径
sheet_name = 'Sheet1'  # 工作表名称
cell = 'A1'  # 单元格位置

# 读取.txt文件的列表
data_list = read_txt_file(txt_file_path)

# 将列表写入excel单元格
write_list_to_excel(data_list, excel_file_path, sheet_name, cell)