1

Install-Package Spire.XLS

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

using Spire.Xls;

using System.Text;

using System.IO;

public class ExcelToTextConverter

{

    public static void ConvertExcelToTxt(string excelFilePath, string outputTxtPath, string delimiter = " ", Encoding encoding = null)

    {

        // 确保指定了默认编码，如果未提供

        if (encoding == null)

        {

            encoding = Encoding.UTF8; // 默认使用UTF-8编码

        }

        // 1. 创建Workbook对象并加载Excel文件

        Workbook workbook = new Workbook();

        try

        {

            workbook.LoadFromFile(excelFilePath);

            Console.WriteLine($"成功加载Excel文件: {excelFilePath}");

            // 2. 获取第一个工作表（您可以根据需要选择其他工作表）

            Worksheet sheet = workbook.Worksheets[0];

            Console.WriteLine($"正在处理工作表: {sheet.Name}");

            // 3. 将工作表内容保存为TXT文件

            // SaveToFile方法提供了直接将工作表保存为文本的功能

            // 参数1: 输出TXT文件路径

            // 参数2: 数据分隔符（例如：空格、逗号、制表符"\t"）

            // 参数3: 文本文件编码，防止中文乱码

            sheet.SaveToFile(outputTxtPath, delimiter, encoding);

            Console.WriteLine($"Excel文件已成功转换为TXT文件: {outputTxtPath}");

        }

        catch (Exception ex)

        {

            Console.WriteLine($"转换过程中发生错误: {ex.Message}");

            Console.WriteLine(ex.StackTrace);

        }

        finally

        {

            // 4. 释放资源

            workbook.Dispose();

        }

    }

    public static void Main(string[] args)

    {

        // 示例用法

        string inputExcel = "SampleData.xlsx"; // 确保此文件存在于项目根目录或指定完整路径

        string outputText = "OutputData.txt";

        // 创建一个简单的Excel文件用于测试 (如果SampleData.xlsx不存在)

        CreateSampleExcelFile(inputExcel);

        // 调用转换方法

        ConvertExcelToTxt(inputExcel, outputText, ",", Encoding.UTF8); // 使用逗号分隔，UTF-8编码

        Console.WriteLine("\n按任意键退出...");

        Console.ReadKey();

    }

    // 辅助方法：创建一个简单的Excel文件用于测试

    private static void CreateSampleExcelFile(string fileName)

    {

        if (!File.Exists(fileName))

        {

            Workbook workbook = new Workbook();

            Worksheet sheet = workbook.Worksheets[0];

            sheet.Name = "Sheet1";

            sheet.Range["A1"].Value = "姓名";

            sheet.Range["B1"].Value = "年龄";

            sheet.Range["C1"].Value = "城市";

            sheet.Range["A2"].Value = "张三";

            sheet.Range["B2"].NumberValue = 30;

            sheet.Range["C2"].Value = "北京";

            sheet.Range["A3"].Value = "李四";

            sheet.Range["B3"].NumberValue = 25;

            sheet.Range["C3"].Value = "上海";

            sheet.Range["A4"].Value = "王五";

            sheet.Range["B4"].NumberValue = 35;

            sheet.Range["C4"].Value = "广州";

            workbook.SaveToFile(fileName, ExcelVersion.Version2013);

            workbook.Dispose();

            Console.WriteLine($"已创建示例Excel文件: {fileName}");

        }

    }

}

1

2

3

4

5

6

7

8

9

// 示例：只提取A列和B列的数据

StringBuilder sb = new StringBuilder();

for (int row = 1; row <= sheet.LastRow; row++)

{

    string cellAValue = sheet.Range[row, 1].Text; // A列

    string cellBValue = sheet.Range[row, 2].Text; // B列

    sb.AppendLine($"{cellAValue},{cellBValue}");

}

File.WriteAllText(outputTxtPath, sb.ToString(), encoding);