Encrypting your files

You can easily decrypt encrypted Excel files as follows (find all the options here: Simply specify the password by defining the option "hadoopoffice.read.security.crypt.password" and your data is transparently decrypted. Note for improved security you may want to store the credentials in a keystore and not as a Hadoop option (see here).

You can even encrypt your Excel files using the hadoopoffice library (find all options here). Please check with your security experts which algorithms to use! Please also note that the old MS Excel format only supports an outdated encryption, but the new MS Excel format supports several popular and modern alternatives. Find here an example for options for encrypting files in new MS Excel format - please crosscheck with your security expert:

• hadoopoffice.write.security.crypt.password - please set here a strong and good password
• hadoopoffice.write.security.crypt.encrypt.algorithm - aes256
• hadoopoffice.write.security.crypt.hash.algorithm - sha512
• hadoopoffice.write.security.crypt.encrypt.mode - agile
• hadoopoffice.write.security.crypt.chain.mode - cbc

If you use low footprint mode then temporary files are needed for creating the final encrypted file. These temporary files are encrypted with the same algorithms that you specified for the final files. Note for improved security you may want to store the credentials in a keystore and not as a Hadoop option (see here).