Назначение и проверка цифровых подписей

Подписание таблиц

Для процесса подписи необходим сертификат, как было обсуждено выше. Кроме сертификата, также необходим пароль для успешной подписи таблиц при использовании API Aspose.Cells.

В следующем фрагменте кода показано использование API Aspose.Cells for Java для подписи таблицы.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(SigningSpreadsheets.class);
// Create an instance of DigitalSignatureCollection
DigitalSignatureCollection signatures = new DigitalSignatureCollection();
// Load the certificate into an instance of InputStream
InputStream inStream = new FileInputStream("d:/temp.pfx");
// Create an instance of KeyStore with PKCS12 cryptography
KeyStore inputKeyStore = KeyStore.getInstance("PKCS12");
// Use the KeyStore.load method to load the certificate stream and its password
inputKeyStore.load(inStream, KEYSTORE_PASSWORD.toCharArray());
// Create an instance of DigitalSignature and pass the instance of KeyStore, password, comments and time
DigitalSignature signature = new DigitalSignature(inputKeyStore, KEYSTORE_PASSWORD, "test for sign",
DateTime.getNow());
// Add the instance of DigitalSignature into the collection
signatures.add(signature);
// Load an existing spreadsheet using the Workbook class
Workbook workbook = new Workbook(dataDir + "unsigned.xlsx");
// Set the signature
workbook.setDigitalSignature(signatures);
// Save the signed spreadsheet
workbook.save(dataDir + "signed.xlsx");

Проверка таблиц

В следующем фрагменте кода показано использование API Aspose.Cells for Java для проверки таблицы.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(ValidatingSpreadsheets.class);
// Load an existing spreadsheet in an instance of Workbook
Workbook workbook = new Workbook(dataDir + "signed.xlsx");
// Retrieve the collection of digital signatures from the Workbook
DigitalSignatureCollection signatures = workbook.getDigitalSignature();
// Loop over the collection of digital signatures
for (DigitalSignature signature : (Iterable<DigitalSignature>) signatures) {
// Check the signature status using the isValid property
System.out.println(signature.isValid());
}