C# 添加、读取、删除Excel文档属性

using Spire.Xls;
 System;

namespace AddProperties
{
    class Program
    {
        static void Main(string[] args)
        {
            //加载Excel文档
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("test.xlsx");

            设置摘要
            workbook.DocumentProperties.Author = Mara;
            workbook.DocumentProperties.Title = 摘要;
            workbook.DocumentProperties.Keywords = 摘要，属性;
            workbook.DocumentProperties.Category = 展示文档;
            workbook.DocumentProperties.Company = 冰蓝科技;
            workbook.DocumentProperties.Comments = 请勿修改;
            workbook.DocumentProperties.Subject = 测试;
            workbook.DocumentProperties.Manager = Tom;


            设置自定义属性
            workbook.CustomDocumentProperties.Add(_MarkAsFinal",true);
            workbook.CustomDocumentProperties.Add(联系电话81705109更新时间,DateTime.Now);

            保存文档
            workbook.SaveToFile(AddProperties.xlsx

?

【示例2】读取文档信息


 Spire.Xls.Collections;
 Spire.Xls.Core;
 ReadProperties
{
    加载Excel文档
            Workbook wb =  Workbook();
            wb.LoadFromFile(获取文档属性
            Console.WriteLine(摘要信息:);
            Console.WriteLine(标题: " + wb.DocumentProperties.Title);
            Console.WriteLine(主题:  wb.DocumentProperties.Subject);
            Console.WriteLine(作者:  wb.DocumentProperties.Author);
            Console.WriteLine(管理者:  wb.DocumentProperties.Manager);
            Console.WriteLine(公司:  wb.DocumentProperties.Company);
            Console.WriteLine(类别:  wb.DocumentProperties.Category);
            Console.WriteLine(关键字:  wb.DocumentProperties.Keywords);
            Console.WriteLine(备注:  wb.DocumentProperties.Comments);

            获取自定义属性
            Console.WriteLine(n自定义属性：);
            for (int i = 0; i < wb.CustomDocumentProperties.Count; i++)
            {
                Console.WriteLine(wb.CustomDocumentProperties[i].Name + :  wb.CustomDocumentProperties[i].Value);
            }
            Console.Read();
        }
    }
}

文档属性读取结果：
?

?

【示例3】删除文档属性


 Spire.Xls;

 DeleteProperties
{
    加载工作簿
            Workbook workbook = 删除摘要及自定义文档属性
            workbook.DocumentProperties.Clear();删除所有摘要信息
            workbook.CustomDocumentProperties.Clear();删除所有自定义文档属性
            
            DeleteProperties.xlsx/*//删除指定摘要及自定义文档属性
            workbook.DocumentProperties.Author = "";//设置指定摘要信息为空，删除摘要内容
            workbook.CustomDocumentProperties.Remove("联系电话");//删除指定名称的自定义文档属性
            workbook.SaveToFile("DeleteCustomDocumentProperties.xlsx",FileFormat.Version2013);*/
        }
    }
}

文档属性删除结果：

?
（本文完）
?
                        
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!