基础示例：单工作表 Excel 转 TXT

以下是将一个 Excel 文件中的第一个工作表转换为 TXT 的完整步骤：

1. 加载并读取Excel文件

from spire.xls import *

from spire.xls.common import *

workbook = Workbook()

workbook.LoadFromFile("示例.xlsx")

2. 执行转换并保存

sheet = workbook.Worksheets[0]

sheet.SaveToFile("output.txt", "\t", Encoding.get_UTF8())

参数说明

参数类型 示例值 描述

分隔符 \t (制表符) 定义 TXT 文件中各列数据之间的分隔方式，也可使用逗号 ,、分号 ; 等。

编码方式 Encoding.get_UTF8()（国际通用编码） 指定文本文件的编码格式，推荐使用 UTF-8 以保证中文等字符正常显示。

进阶处理：多工作表分别导出为 TXT

如果你的 Excel 文件包含多个工作表，并且希望将每个工作表保存为单独的 TXT 文件，可以使用以下代码：

from spire.xls import *

from spire.xls.common import *

def excel_sheets_to_txt(input_file, output_folder, delimiter="\t"):

# 创建Workbook对象

workbook = Workbook()

# 加载Excel文件

workbook.LoadFromFile(input_file)

# 遍历所有工作表

for i in range (workbook.Worksheets.Count):

sheet = workbook.Worksheets[i]

# 构建输出文件路径

output_file = f"sheet_{i+1}_{sheet.Name}.txt"

output_path = os.path.join(output_folder, output_file)

# 将工作表内容保存为TXT文件

sheet.SaveToFile(output_path, delimiter, Encoding.get_UTF8())

Excel 转 TXT 在自动化流程中的应用

将 Excel 转换为 TXT 不仅是格式的简单转换，更是实现数据自动化流程的重要环节。结合 Spire.XLS for Python ，可轻松构建以下应用：

自动化报告生成： 从 Excel 模板中提取数据，生成纯文本格式的报告摘要，方便邮件发送或系统集成。

数据清洗与预处理： 将复杂格式的 Excel 数据转换为 TXT，作为其他数据分析工具（如Spark、Hadoop）的输入源，进行更深层次的处理。

配置管理： 将 Excel 中维护的系统配置、参数表等导出为 TXT 格式，便于脚本直接读取，同时更适合使用 Git 等工具进行版本管理。抗峭负芯

https://gitee.com/oxveq967/pykzrs/blob/master/50479259.md
https://gitee.com/oxveq967/pykzrs/blob/master/59224700.md
https://gitee.com/oxveq967/pykzrs/blob/master/37124479.md
https://gitee.com/oxveq967/pykzrs/blob/master/94791380.md
https://gitee.com/oxveq967/pykzrs/blob/master/59367046.md
https://gitee.com/oxveq967/pykzrs/blob/master/04990259.md
https://gitee.com/oxveq967/pykzrs/blob/master/95002366.md
https://gitee.com/oxveq967/pykzrs/blob/master/72670359.md
https://gitee.com/slzin422/bjsikf/blob/master/17937024.md
https://gitee.com/oxveq967/pykzrs/blob/master/30222800.md
https://gitee.com/slzin422/bjsikf/blob/master/74794490.md
https://gitee.com/oxveq967/pykzrs/blob/master/16812580.md
https://gitee.com/slzin422/bjsikf/blob/master/38466811.md
https://gitee.com/oxveq967/pykzrs/blob/master/50468027.md
https://gitee.com/slzin422/bjsikf/blob/master/52378136.md
https://gitee.com/oxveq967/pykzrs/blob/master/94812571.md
https://gitee.com/slzin422/bjsikf/blob/master/71679080.md
https://gitee.com/oxveq967/pykzrs/blob/master/74679710.md
https://gitee.com/slzin422/bjsikf/blob/master/50245036.md
https://gitee.com/oxveq967/pykzrs/blob/master/27148048.md
https://gitee.com/slzin422/bjsikf/blob/master/27134791.md
https://gitee.com/oxveq967/pykzrs/blob/master/93590359.md
https://gitee.com/slzin422/bjsikf/blob/master/95770368.md
https://gitee.com/oxveq967/pykzrs/blob/master/85704470.md
https://gitee.com/slzin422/bjsikf/blob/master/48260255.md
https://gitee.com/oxveq967/pykzrs/blob/master/05803692.md
https://gitee.com/slzin422/bjsikf/blob/master/05701559.md
https://gitee.com/oxveq967/pykzrs/blob/master/27124690.md
https://gitee.com/slzin422/bjsikf/blob/master/15812470.md
https://gitee.com/slzin422/bjsikf/blob/master/68212702.md
https://gitee.com/oxveq967/pykzrs/blob/master/89603847.md
https://gitee.com/oxveq967/pykzrs/blob/master/18505065.md
https://gitee.com/slzin422/bjsikf/blob/master/72690271.md
https://gitee.com/oxveq967/pykzrs/blob/master/60121346.md
https://gitee.com/slzin422/bjsikf/blob/master/82270042.md
https://gitee.com/oxveq967/pykzrs/blob/master/51058609.md
https://gitee.com/slzin422/bjsikf/blob/master/38224588.md
https://gitee.com/oxveq967/pykzrs/blob/master/29350404.md
https://gitee.com/slzin422/bjsikf/blob/master/85923367.md
https://gitee.com/oxveq967/pykzrs/blob/master/59568036.md
https://gitee.com/slzin422/bjsikf/blob/master/16033605.md
https://gitee.com/oxveq967/pykzrs/blob/master/57111479.md
https://gitee.com/slzin422/bjsikf/blob/master/60449023.md
https://gitee.com/slzin422/bjsikf/blob/master/28936901.md
https://gitee.com/oxveq967/pykzrs/blob/master/16157926.md
https://gitee.com/slzin422/bjsikf/blob/master/47011334.md
https://gitee.com/oxveq967/pykzrs/blob/master/82789148.md
https://gitee.com/slzin422/bjsikf/blob/master/49301571.md
https://gitee.com/oxveq967/pykzrs/blob/master/21937495.md
https://gitee.com/slzin422/bjsikf/blob/master/31502814.md
https://gitee.com/oxveq967/pykzrs/blob/master/17491739.md
https://gitee.com/slzin422/bjsikf/blob/master/18169160.md
https://gitee.com/oxveq967/pykzrs/blob/master/29034691.md
https://gitee.com/slzin422/bjsikf/blob/master/81332566.md
https://gitee.com/oxveq967/pykzrs/blob/master/68217690.md
https://gitee.com/slzin422/bjsikf/blob/master/50467921.md
https://gitee.com/oxveq967/pykzrs/blob/master/84471113.md
https://gitee.com/slzin422/bjsikf/blob/master/28368194.md
https://gitee.com/oxveq967/pykzrs/blob/master/37709126.md
https://gitee.com/slzin422/bjsikf/blob/master/41257926.md
https://gitee.com/oxveq967/pykzrs/blob/master/63712579.md
https://gitee.com/slzin422/bjsikf/blob/master/82567035.md
https://gitee.com/oxveq967/pykzrs/blob/master/63836251.md
https://gitee.com/slzin422/bjsikf/blob/master/71824926.md
https://gitee.com/slzin422/bjsikf/blob/master/30749507.md
https://gitee.com/oxveq967/pykzrs/blob/master/05804479.md
https://gitee.com/slzin422/bjsikf/blob/master/05702469.md
https://gitee.com/oxveq967/pykzrs/blob/master/50042557.md
https://gitee.com/slzin422/bjsikf/blob/master/75948161.md
https://gitee.com/oxveq967/pykzrs/blob/master/62445803.md
https://gitee.com/slzin422/bjsikf/blob/master/04470702.md
https://gitee.com/oxveq967/pykzrs/blob/master/04901361.md
https://gitee.com/slzin422/bjsikf/blob/master/58114243.md
https://gitee.com/slzin422/bjsikf/blob/master/20951784.md
https://gitee.com/oxveq967/pykzrs/blob/master/63049395.md
https://gitee.com/slzin422/bjsikf/blob/master/37256917.md
https://gitee.com/oxveq967/pykzrs/blob/master/27245703.md
https://gitee.com/slzin422/bjsikf/blob/master/26122793.md
https://gitee.com/oxveq967/pykzrs/blob/master/50567046.md
https://gitee.com/slzin422/bjsikf/blob/master/38243589.md
https://gitee.com/slzin422/bjsikf/blob/master/04801370.md
https://gitee.com/oxveq967/pykzrs/blob/master/49368131.md
https://gitee.com/slzin422/bjsikf/blob/master/16801491.md
https://gitee.com/oxveq967/pykzrs/blob/master/71675793.md
https://gitee.com/slzin422/bjsikf/blob/master/83799249.md
https://gitee.com/oxveq967/pykzrs/blob/master/83568160.md
https://gitee.com/slzin422/bjsikf/blob/master/93892546.md
https://gitee.com/oxveq967/pykzrs/blob/master/63789258.md
https://gitee.com/slzin422/bjsikf/blob/master/93570468.md
https://gitee.com/slzin422/bjsikf/blob/master/29809015.md
https://gitee.com/oxveq967/pykzrs/blob/master/07780056.md
https://gitee.com/slzin422/bjsikf/blob/master/84601461.md
https://gitee.com/oxveq967/pykzrs/blob/master/49802636.md
https://gitee.com/slzin422/bjsikf/blob/master/73378037.md
https://gitee.com/oxveq967/pykzrs/blob/master/71466780.md
https://gitee.com/slzin422/bjsikf/blob/master/27908132.md
https://gitee.com/oxveq967/pykzrs/blob/master/59014601.md
https://gitee.com/slzin422/bjsikf/blob/master/62380830.md
https://gitee.com/oxveq967/pykzrs/blob/master/44727272.md
https://gitee.com/slzin422/bjsikf/blob/master/63593570.md
https://gitee.com/oxveq967/pykzrs/blob/master/58024570.md
https://gitee.com/slzin422/bjsikf/blob/master/05265140.md
https://gitee.com/oxveq967/pykzrs/blob/master/53737351.md
https://gitee.com/slzin422/bjsikf/blob/master/50556135.md
https://gitee.com/oxveq967/pykzrs/blob/master/13682579.md
https://gitee.com/slzin422/bjsikf/blob/master/30032447.md
https://gitee.com/oxveq967/pykzrs/blob/master/38256925.md
https://gitee.com/slzin422/bjsikf/blob/master/84667156.md
https://gitee.com/oxveq967/pykzrs/blob/master/29122557.md
https://gitee.com/slzin422/bjsikf/blob/master/17035360.md
https://gitee.com/oxveq967/pykzrs/blob/master/42468255.md
https://gitee.com/slzin422/bjsikf/blob/master/98493949.md
https://gitee.com/oxveq967/pykzrs/blob/master/72568035.md
https://gitee.com/slzin422/bjsikf/blob/master/95793568.md
https://gitee.com/oxveq967/pykzrs/blob/master/31356138.md
https://gitee.com/slzin422/bjsikf/blob/master/94901572.md
https://gitee.com/oxveq967/pykzrs/blob/master/93801479.md
https://gitee.com/slzin422/bjsikf/blob/master/50360358.md
https://gitee.com/slzin422/bjsikf/blob/master/96890356.md
https://gitee.com/oxveq967/pykzrs/blob/master/07126813.md
https://gitee.com/slzin422/bjsikf/blob/master/34988136.md
https://gitee.com/oxveq967/pykzrs/blob/master/74691580.md
https://gitee.com/slzin422/bjsikf/blob/master/85703360.md
https://gitee.com/oxveq967/pykzrs/blob/master/29035703.md
https://gitee.com/slzin422/bjsikf/blob/master/72659137.md
https://gitee.com/oxveq967/pykzrs/blob/master/72678367.md
https://gitee.com/slzin422/bjsikf/blob/master/41356800.md
https://gitee.com/slzin422/bjsikf/blob/master/52379235.md
https://gitee.com/oxveq967/pykzrs/blob/master/66803681.md
https://gitee.com/slzin422/bjsikf/blob/master/15915791.md
https://gitee.com/oxveq967/pykzrs/blob/master/39113692.md
https://gitee.com/slzin422/bjsikf/blob/master/07678902.md
https://gitee.com/oxveq967/pykzrs/blob/master/64691581.md
https://gitee.com/slzin422/bjsikf/blob/master/82259101.md
https://gitee.com/oxveq967/pykzrs/blob/master/58091368.md
https://gitee.com/slzin422/bjsikf/blob/master/37113568.md
https://gitee.com/oxveq967/pykzrs/blob/master/73571368.md
https://gitee.com/slzin422/bjsikf/blob/master/72689136.md
https://gitee.com/oxveq967/pykzrs/blob/master/85682479.md
https://gitee.com/slzin422/bjsikf/blob/master/59334602.md
https://gitee.com/oxveq967/pykzrs/blob/master/64589146.md
https://gitee.com/oxveq967/pykzrs/blob/master/16015702.md
https://gitee.com/oxveq967/pykzrs/blob/master/74693680.md
https://gitee.com/slzin422/bjsikf/blob/master/27126915.md
https://gitee.com/oxveq967/pykzrs/blob/master/15981689.md
https://gitee.com/slzin422/bjsikf/blob/master/94776904.md
https://gitee.com/oxveq967/pykzrs/blob/master/28111379.md
https://gitee.com/slzin422/bjsikf/blob/master/74890257.md
https://gitee.com/oxveq967/pykzrs/blob/master/51180608.md
https://gitee.com/slzin422/bjsikf/blob/master/74791368.md
https://gitee.com/oxveq967/pykzrs/blob/master/52268345.md
https://gitee.com/slzin422/bjsikf/blob/master/63571680.md
https://gitee.com/oxveq967/pykzrs/blob/master/94882492.md
https://gitee.com/slzin422/bjsikf/blob/master/72456926.md
https://gitee.com/oxveq967/pykzrs/blob/master/39343479.md
https://gitee.com/slzin422/bjsikf/blob/master/25902401.md
https://gitee.com/oxveq967/pykzrs/blob/master/16909137.md
https://gitee.com/slzin422/bjsikf/blob/master/59123693.md
https://gitee.com/oxveq967/pykzrs/blob/master/15989247.md
https://gitee.com/slzin422/bjsikf/blob/master/05935860.md
https://gitee.com/oxveq967/pykzrs/blob/master/50343570.md
https://gitee.com/slzin422/bjsikf/blob/master/38247035.md
https://gitee.com/oxveq967/pykzrs/blob/master/37146815.md
https://gitee.com/slzin422/bjsikf/blob/master/93590257.md
https://gitee.com/oxveq967/pykzrs/blob/master/61545699.md
https://gitee.com/slzin422/bjsikf/blob/master/85712579.md
https://gitee.com/oxveq967/pykzrs/blob/master/94893582.md
https://gitee.com/slzin422/bjsikf/blob/master/74680350.md
https://gitee.com/oxveq967/pykzrs/blob/master/35702491.md
https://gitee.com/oxveq967/pykzrs/blob/master/61545814.md
https://gitee.com/slzin422/bjsikf/blob/master/48356815.md
https://gitee.com/oxveq967/pykzrs/blob/master/30237913.md
https://gitee.com/slzin422/bjsikf/blob/master/50457035.md
https://gitee.com/oxveq967/pykzrs/blob/master/91267024.md
https://gitee.com/slzin422/bjsikf/blob/master/26813691.md
https://gitee.com/oxveq967/pykzrs/blob/master/33794799.md
https://gitee.com/slzin422/bjsikf/blob/master/19343660.md
https://gitee.com/oxveq967/pykzrs/blob/master/37032589.md
https://gitee.com/slzin422/bjsikf/blob/master/04895803.md
https://gitee.com/oxveq967/pykzrs/blob/master/16802348.md
https://gitee.com/slzin422/bjsikf/blob/master/20154247.md
https://gitee.com/oxveq967/pykzrs/blob/master/82671316.md
https://gitee.com/slzin422/bjsikf/blob/master/48467036.md
https://gitee.com/oxveq967/pykzrs/blob/master/16023704.md
https://gitee.com/slzin422/bjsikf/blob/master/05901481.md
https://gitee.com/oxveq967/pykzrs/blob/master/05024603.md
https://gitee.com/slzin422/bjsikf/blob/master/62689258.md
https://gitee.com/slzin422/bjsikf/blob/master/91589148.md
https://gitee.com/oxveq967/pykzrs/blob/master/02589269.md
https://gitee.com/oxveq967/pykzrs/blob/master/61567046.md
https://gitee.com/slzin422/bjsikf/blob/master/27015803.md
https://gitee.com/oxveq967/pykzrs/blob/master/15023681.md
https://gitee.com/slzin422/bjsikf/blob/master/15025772.md
https://gitee.com/slzin422/bjsikf/blob/master/82567926.md
https://gitee.com/oxveq967/pykzrs/blob/master/94892791.md
https://gitee.com/oxveq967/pykzrs/blob/master/63567047.md
https://gitee.com/slzin422/bjsikf/blob/master/27122570.md
https://gitee.com/slzin422/bjsikf/blob/master/16101144.md
https://gitee.com/oxveq967/pykzrs/blob/master/72689246.md
https://gitee.com/slzin422/bjsikf/blob/master/49335802.md
https://gitee.com/oxveq967/pykzrs/blob/master/48259235.md
https://gitee.com/slzin422/bjsikf/blob/master/37991245.md
https://gitee.com/oxveq967/pykzrs/blob/master/96013691.md
https://gitee.com/slzin422/bjsikf/blob/master/16245602.md
https://gitee.com/oxveq967/pykzrs/blob/master/72567058.md
https://gitee.com/slzin422/bjsikf/blob/master/18900235.md
https://gitee.com/oxveq967/pykzrs/blob/master/71689146.md
https://gitee.com/slzin422/bjsikf/blob/master/80446467.md
https://gitee.com/oxveq967/pykzrs/blob/master/37235792.md
https://gitee.com/slzin422/bjsikf/blob/master/92579925.md
https://gitee.com/slzin422/bjsikf/blob/master/37147725.md
https://gitee.com/oxveq967/pykzrs/blob/master/05014611.md
https://gitee.com/slzin422/bjsikf/blob/master/30578136.md
https://gitee.com/oxveq967/pykzrs/blob/master/52324793.md
https://gitee.com/slzin422/bjsikf/blob/master/30340233.md
https://gitee.com/oxveq967/pykzrs/blob/master/29245724.md
https://gitee.com/slzin422/bjsikf/blob/master/83782469.md
https://gitee.com/oxveq967/pykzrs/blob/master/17931436.md
https://gitee.com/slzin422/bjsikf/blob/master/72647703.md
https://gitee.com/oxveq967/pykzrs/blob/master/37124704.md
https://gitee.com/slzin422/bjsikf/blob/master/37134692.md
https://gitee.com/oxveq967/pykzrs/blob/master/61346801.md
https://gitee.com/slzin422/bjsikf/blob/master/26890133.md
https://gitee.com/oxveq967/pykzrs/blob/master/63671468.md
https://gitee.com/slzin422/bjsikf/blob/master/05901370.md
https://gitee.com/oxveq967/pykzrs/blob/master/72348136.md
https://gitee.com/slzin422/bjsikf/blob/master/49347027.md
https://gitee.com/oxveq967/pykzrs/blob/master/85023692.md
https://gitee.com/slzin422/bjsikf/blob/master/79114805.md
https://gitee.com/oxveq967/pykzrs/blob/master/50456936.md
https://gitee.com/slzin422/bjsikf/blob/master/67126792.md
https://gitee.com/oxveq967/pykzrs/blob/master/05943682.md
https://gitee.com/slzin422/bjsikf/blob/master/51444813.md
https://gitee.com/oxveq967/pykzrs/blob/master/93690360.md
https://gitee.com/slzin422/bjsikf/blob/master/60467801.md
https://gitee.com/slzin422/bjsikf/blob/master/04701691.md
https://gitee.com/oxveq967/pykzrs/blob/master/94890247.md
https://gitee.com/slzin422/bjsikf/blob/master/83790252.md
https://gitee.com/oxveq967/pykzrs/blob/master/07681033.md
https://gitee.com/slzin422/bjsikf/blob/master/61589927.md
https://gitee.com/oxveq967/pykzrs/blob/master/72688136.md
https://gitee.com/slzin422/bjsikf/blob/master/37712580.md
https://gitee.com/oxveq967/pykzrs/blob/master/05001469.md
https://gitee.com/slzin422/bjsikf/blob/master/04970136.md
https://gitee.com/oxveq967/pykzrs/blob/master/49467025.md
https://gitee.com/slzin422/bjsikf/blob/master/37024679.md
https://gitee.com/oxveq967/pykzrs/blob/master/84891469.md
https://gitee.com/slzin422/bjsikf/blob/master/40457925.md
https://gitee.com/oxveq967/pykzrs/blob/master/50456912.md
https://gitee.com/slzin422/bjsikf/blob/master/18798032.md
https://gitee.com/oxveq967/pykzrs/blob/master/68613211.md
https://gitee.com/slzin422/bjsikf/blob/master/72458137.md
https://gitee.com/oxveq967/pykzrs/blob/master/93692568.md
https://gitee.com/slzin422/bjsikf/blob/master/06823681.md
https://gitee.com/oxveq967/pykzrs/blob/master/93692476.md
https://gitee.com/slzin422/bjsikf/blob/master/05900267.md
https://gitee.com/oxveq967/pykzrs/blob/master/59459247.md
https://gitee.com/slzin422/bjsikf/blob/master/37135723.md
https://gitee.com/slzin422/bjsikf/blob/master/50447724.md
https://gitee.com/oxveq967/pykzrs/blob/master/51562459.md
https://gitee.com/slzin422/bjsikf/blob/master/85692479.md
https://gitee.com/oxveq967/pykzrs/blob/master/74345889.md
https://gitee.com/slzin422/bjsikf/blob/master/61579104.md
https://gitee.com/oxveq967/pykzrs/blob/master/83689226.md
https://gitee.com/slzin422/bjsikf/blob/master/26914579.md
https://gitee.com/oxveq967/pykzrs/blob/master/15901360.md
https://gitee.com/slzin422/bjsikf/blob/master/85901469.md
https://gitee.com/oxveq967/pykzrs/blob/master/94864582.md
https://gitee.com/slzin422/bjsikf/blob/master/82681471.md
https://gitee.com/oxveq967/pykzrs/blob/master/05925803.md
https://gitee.com/slzin422/bjsikf/blob/master/48468135.md
https://gitee.com/oxveq967/pykzrs/blob/master/38124457.md
https://gitee.com/slzin422/bjsikf/blob/master/27127913.md
https://gitee.com/oxveq967/pykzrs/blob/master/28057582.md
https://gitee.com/slzin422/bjsikf/blob/master/06872333.md
https://gitee.com/oxveq967/pykzrs/blob/master/72681689.md
https://gitee.com/slzin422/bjsikf/blob/master/26015703.md
https://gitee.com/oxveq967/pykzrs/blob/master/39346914.md
https://gitee.com/slzin422/bjsikf/blob/master/18928126.md
https://gitee.com/oxveq967/pykzrs/blob/master/26923682.md