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

using Spire.Xls;

using System;

namespace ExcelDocumentProperties

{

    class Program

    {

        static void Main(string[] args)

        {

            // 创建一个Workbook实例

            Workbook workbook = new Workbook();

            // 加载现有的Excel文件

            // 请确保你的项目目录下存在一个名为"Sample.xlsx"的文件

            workbook.LoadFromFile("Sample.xlsx");

            // 获取文档属性对象

            IDocumentProperties properties = workbook.DocumentProperties;

            // 设置内置属性

            properties.Title = "2023年年度销售报告";

            properties.Author = "张三 (开发部)";

            properties.Subject = "销售数据分析";

            properties.Comments = "本报告汇总了2023年度各区域的销售数据和趋势分析。";

            properties.Category = "财务报告";

            properties.Company = "ABC科技有限公司";

            properties.Manager = "李四";

            properties.Keywords = "销售, 年度报告, 2023, 财务";

            // 保存更改到新文件或覆盖原文件

            workbook.SaveToFile("SalesReport_WithBuiltInProperties.xlsx", ExcelVersion.Version2016);

            Console.WriteLine("内置文档属性已成功添加并保存！");

        }

    }

}

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

using Spire.Xls;

using System;

namespace ExcelDocumentProperties

{

    class Program

    {

        static void Main(string[] args)

        {

            // 创建一个Workbook实例

            Workbook workbook = new Workbook();

            // 加载现有的Excel文件

            workbook.LoadFromFile("SalesReport_WithBuiltInProperties.xlsx"); // 使用上一步生成的文件

            // 获取自定义文档属性集合

            ICustomDocumentProperties customProperties = workbook.CustomDocumentProperties;

            // 添加自定义属性

            // 属性名称, 属性值, 值类型

            customProperties.Add("项目编号", "PRJ-2023-001", CustomDocumentPropertyType.String);

            customProperties.Add("版本号", "1.0.1", CustomDocumentPropertyType.String);

            customProperties.Add("审核日期", DateTime.Now, CustomDocumentPropertyType.DateTime);

            customProperties.Add("审核人", "王五", CustomDocumentPropertyType.String);

            customProperties.Add("是否已归档", true, CustomDocumentPropertyType.Boolean);

            customProperties.Add("预算金额", 1000000.50, CustomDocumentPropertyType.Number);

            // 修改已存在的自定义属性 (如果属性不存在，则会抛出异常)

            // customProperties["版本号"].Value = "1.0.2";

            // 保存更改

            workbook.SaveToFile("SalesReport_WithCustomProperties.xlsx", ExcelVersion.Version2016);

            Console.WriteLine("自定义文档属性已成功添加并保存！");

        }

    }

}