Spire.XLS for .NET 是一款專業的 .NET Excel 組件， 它可以用在各種.NET 框架中，包括 .NET Core、ASP.NET 和 Windows Forms 等相關的.NET 應用程序。在Excel表格中圖片也是我們經常會使用到的工具，這時我們如何使用Spire.XLS來完成呢？這就是本系列教程將給大家詳細講解的。

下載Spire.XLS最新版體驗

添加和刪除數字簽名

本文將介紹如何使用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 System
Imports System.Security.Cryptography.X509Certificates
Imports Spire.Xls
Imports Spire.Xls.Core.MergeSpreadsheet.Interfaces

Namespace 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 Class
End 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.Xls

Namespace 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 Class
End Namespace

刪除數字簽名后的文檔截圖：