使用证书为VBA代码项目进行数字签名

在Python中用证书对VBA代码项目进行数字签名

以下示例代码说明了如何使用Workbook.vba_project.sign()方法。这是示例代码的输入和输出文件。您可以使用任何Excel文件和任何证书来测试此代码。

from aspose.cells import Workbook
from aspose.cells.digitalsignatures import DigitalSignature
from datetime import datetime
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
password = "1234"
pfxPath = sourceDir + "sampleDigitallySignVbaProjectWithCertificate.pfx"
comment = "Signing Digital Signature using Aspose.Cells"
# Set Digital Signature
digitalSignature = DigitalSignature(open(pfxPath, "rb").read(), password, comment, datetime.now())
# Create workbook object from excel file
workbook = Workbook(sourceDir + "sampleDigitallySignVbaProjectWithCertificate.xlsm")
# Sign VBA Code Project with Digital Signature
workbook.vba_project.sign(digitalSignature)
# Save the workbook
workbook.save(outputDir + "outputDigitallySignVbaProjectWithCertificate.xlsm")