1. 添加數(shù)字簽名
C#
using Spire.Xls;using Spire.Xls.Core.MergeSpreadsheet.Interfaces;using System;using System.Security.Cryptography.X509Certificates;namespace DigitalSignature_XLS
{
? ? class Program
? ? {
? ? ? ? staticvoidMain(string[] args)
? ? ? ? {
? ? ? ? ? ? //創(chuàng)建Workbook實例Workbook workbook =new Workbook();
? ? ? ? ? ? //加載Excel文檔workbook.LoadFromFile("sample.xlsx");
? ? ? ? ? ? //添加數(shù)字簽名X509Certificate2 cert =newX509Certificate2("gary.pfx","123456");
? ? ? ? ? ? DateTime certtime =newDateTime(2020,7,1,7,10,36);
? ? ? ? ? ? IDigitalSignatures signature = workbook.AddDigitalSignature(cert,"Manager", certtime);
? ? ? ? ? ? //保存文檔workbook.SaveToFile("AddDigitalSignature.xlsx", FileFormat.Version2013);
? ? ? ? ? ? System.Diagnostics.Process.Start("AddDigitalSignature.xlsx");
? ? ? ? }
? ? }
}
VB.NET
Imports Spire.XlsImports Spire.Xls.Core.MergeSpreadsheet.InterfacesImports System.Security.Cryptography.X509CertificatesNamespace DigitalSignature_XLS
? ? Class Program
? ? ? ? PrivateSharedSubMain(argsAsString())
? ? ? ? ? ? '創(chuàng)建Workbook實例DimworkbookAsNew Workbook()
? ? ? ? ? ? '加載Excel文檔workbook.LoadFromFile("sample.xlsx")
? ? ? ? ? ? '添加數(shù)字簽名DimcertAsNewX509Certificate2("gary.pfx","123456")
? ? ? ? ? ? DimcerttimeAsNewDateTime(2020,7,1,7,10,36)
? ? ? ? ? ? DimsignatureAsIDigitalSignatures = workbook.AddDigitalSignature(cert,"Manager", certtime)
? ? ? ? ? ? '保存文檔workbook.SaveToFile("AddDigitalSignature.xlsx", FileFormat.Version2013)
? ? ? ? ? ? System.Diagnostics.Process.Start("AddDigitalSignature.xlsx")
? ? ? ? End SubEnd ClassEnd Namespace
數(shù)字簽名添加效果：
正在上傳... 取消
2. 刪除Excel中的數(shù)字簽名
C#
正在上傳... 取消
using Spire.Xls;namespace RemoveSignature
{
? ? class Program
? ? {
? ? ? ? staticvoidMain(string[] args)
? ? ? ? {
? ? ? ? ? ? //加載Excel文檔Workbook workbook =new Workbook();
? ? ? ? ? ? workbook.LoadFromFile("AddDigitalSignature.xlsx");
? ? ? ? ? ? //刪除文檔中的數(shù)字簽名? ? ? ? ? ? workbook.RemoveAllDigitalSignatures();
? ? ? ? ? ? //保存文檔workbook.SaveToFile("RemoveDigitalSignature.xlsx", FileFormat.Version2013);
? ? ? ? ? ? System.Diagnostics.Process.Start("RemoveDigitalSignature.xlsx");
? ? ? ? }
? ? }
}
正在上傳... 取消
VB.NET
正在上傳... 取消
Imports Spire.XlsNamespace RemoveSignature
? ? Class Program
? ? ? ? PrivateSharedSubMain(argsAsString())
? ? ? ? ? ? '加載Excel文檔DimworkbookAsNew Workbook()
? ? ? ? ? ? workbook.LoadFromFile("AddDigitalSignature.xlsx")
? ? ? ? ? ? '刪除文檔中的數(shù)字簽名? ? ? ? ? ? workbook.RemoveAllDigitalSignatures()
? ? ? ? ? ? '保存文檔workbook.SaveToFile("RemoveDigitalSignature.xlsx", FileFormat.Version2013)
? ? ? ? ? ? System.Diagnostics.Process.Start("RemoveDigitalSignature.xlsx")
? ? ? ? End SubEnd ClassEnd Namespace
龍華大道1號 http://www.kinghill.cn/Dynamics/2106.html
