Crittografa e decritta i file ODS
Crittografa con OpenOffice Calc
- Seleziona Salva con nome e seleziona la casella Salva con password.
- Fai clic sul pulsante Salva.
- Digita la password desiderata nei campi Inserisci password per aprire e Conferma password nella finestra Imposta password che si apre.
- Fare clic sul pulsante OK per salvare il file.
Crittografia/Decrittografia del file ODS:
Per crittografare un file ODS, caricare il file e passare la password effettiva a WorkbookSettings.setPassword() prima di salvarlo. Il file ODS crittografato in output può essere aperto solo in OpenOffice. Per decrittografare un file ODS, caricare il file fornendo la password a LoadOptions.setPassword(). Una volta caricato il file, chiamare la funzione Workbook.unprotect() con la password effettiva come argomento e infine passare null a Workbook.getWorkbookSettings().setPassword().
Codice di Esempio:
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// The path to the documents directory. | |
static String sourceDir = Utils.Get_SourceDirectory(); | |
static String outputDir = Utils.Get_OutputDirectory(); | |
public static void main(String[] args) throws Exception { | |
//Encrypt an ODS file | |
//Encrypted ODS file can only be opened in OpenOffice as Excel does not support encrypted ODS files | |
//Initialize loading options | |
LoadOptions loadOptions = new LoadOptions(LoadFormat.ODS); | |
// Instantiate a Workbook object. | |
// Open an ODS file. | |
Workbook workbook = new Workbook(sourceDir + "sampleODSFile.ods", loadOptions); | |
//Encryption options are not effective for ODS files | |
// Password protect the file. | |
workbook.getSettings().setPassword("1234"); | |
// Save the excel file. | |
workbook.save(outputDir + "outputEncryptedODSFile.ods"); | |
//Decrypt ODS file | |
//Decrypted ODS file can be opened both in Excel and OpenOffice | |
// Set original password | |
loadOptions.setPassword("1234"); | |
// Load the encrypted ODS file with the appropriate load options | |
Workbook encrypted = new Workbook(sourceDir + "sampleEncryptedODSFile.ods", loadOptions); | |
// Unprotect the workbook | |
encrypted.unprotect("1234"); | |
// Set the password to null | |
encrypted.getSettings().setPassword(null); | |
// Save the decrypted ODS file | |
encrypted.save(outputDir + "outputDecryptedODSFile.ods"); | |
// Print message | |
System.out.println("Encryption and Decryption applied successfully on ODS file."); | |
} |