Excel .NET组件Spire.XLS教程：在Excel中添加和删除数字签名

Spire.XLS是一款专业的 .NET Excel 组件， 可以用在各种 .NET 框架中，无需依赖于 Microsoft Office Excel，使开发人员可以快速地在 .NET 平台上完成对 Excel 的各种编程操作。本文将介绍如何使用Spire.XLS for .NET在Excel中添加和删除数字签名。

*这么优秀的国产工具怎能错过呢！在线下单专享“一口价”，低至4579元起，立即购买！想要获取更多福利的朋友可以咨询在线客服哦~

添加和删除数字签名

本文将介绍如何使用Spire.XLS for .NET在Excel中添加和删除数字签名。

添加数字签名

C#

using System;using System.Security.Cryptography.X509Certificates;using Spire.Xls;using Spire.Xls.Core.MergeSpreadsheet.Interfaces;namespace Add_Digital_Signature{    class Program    {        static void Main(string[] args)        {            //创建Workbook实例            Workbook workbook = new Workbook();            //加载Excel文档            workbook.LoadFromFile("Sample.xlsx");            //添加数字签名            X509Certificate2 cert = new X509Certificate2("gary.pfx", "e-iceblue");            DateTime certtime = new DateTime(2020, 7, 1, 7, 10, 36);            IDigitalSignatures signature = workbook.AddDigitalSignature(cert, "e-iceblue", certtime);                //保存结果文档            workbook.SaveToFile("AddDigitalSignature.xlsx", FileFormat.Version2013);        }    }}

VB.NET

Imports SystemImports System.Security.Cryptography.X509CertificatesImports Spire.XlsImports Spire.Xls.Core.MergeSpreadsheet.InterfacesNamespace Add_Digital_Signature    Class Program        Private Shared Sub Main(ByVal args As String())            Dim workbook As Workbook = New Workbook()            workbook.LoadFromFile("Sample.xlsx")            Dim cert As X509Certificate2 = New X509Certificate2("gary.pfx", "e-iceblue")            Dim certtime As DateTime = New DateTime(2020, 7, 1, 7, 10, 36)            Dim signature As IDigitalSignatures = workbook.AddDigitalSignature(cert, "e-iceblue", certtime)            workbook.SaveToFile("AddDigitalSignature.xlsx", FileFormat.Version2013)        End Sub    End ClassEnd Namespace

添加数字签名后的文档截图：

删除数字签名

C#

using Spire.Xls;namespace Delete_Digital_Signature{    class Program    {        static void Main(string[] args)        {            //创建Workbook实例            Workbook workbook = new Workbook();            //加载Excel文档            workbook.LoadFromFile("AddDigitalSignature.xlsx");            //删除文档中的数字签名            workbook.RemoveAllDigitalSignatures();            //保存结果文档            workbook.SaveToFile("RemoveDigitalSignature.xlsx", FileFormat.Version2013);        }    }}

VB.NET

Imports Spire.XlsNamespace Delete_Digital_Signature    Class Program        Private Shared Sub Main(ByVal args As String())            Dim workbook As Workbook = New Workbook()            workbook.LoadFromFile("AddDigitalSignature.xlsx")            workbook.RemoveAllDigitalSignatures()            workbook.SaveToFile("RemoveDigitalSignature.xlsx", FileFormat.Version2013)        End Sub    End ClassEnd Namespace

删除数字签名后的文档截图：

来源：慧都