怎么用python将有格式的txt文档读入excel文档当中

Question

即用分隔符，换行符预先设定好的txt文档，手动copy到excel中会生成一个excel表格（有时需要重选分隔符）。

那么这个功能（从打开指定TXT文档到生成表格）用python如何实现能？需要用到那些扩展包呢？

例如，txt文本中有以下带有格式的内容：
Marketplace,Rule Priority,Rule Name,Rule Status,First Launch Date,Age 0-0.5,Age 0.5-1,Age 1-2,Age 2-3,Age 3+,Total
JP, 3, JP_Weapons_Knives_Blade_6_15, LAUNCHED, 2018-09-03T01:35:44, 42, 6, 2, 40, 18, 108

Answer 1

from openpyxl import Workbook

title = "Marketplace,Rule Priority,Rule Name,Rule Status,First Launch Date,Age 0-0.5,Age 0.5-1,Age 1-2,Age 2-3,Age 3+,Total"
data = "JP, 3, JP_Weapons_Knives_Blade_6_15, LAUNCHED, 2018-09-03T01:35:44, 42, 6, 2, 40, 18, 108"
title_list = title.split(",")
data_list = data.split(",")

wb = Workbook()
# 创建一个sheet
ws = wb.create_sheet()
ws.append(title_list)
ws.append(data_list)

wb.save(r'demo.xlsx')