Generating Password protected Excel File to attach in mail
Hi All,
As per the requirement, we have to share a report in mail with Excel attachment in password protected mode in Pega 7.2.2
Already MSOGenerateExcelFile activity is customised and able to share the excel as attachment via mail.
Need help to protect the excel. I am stuck at passing while opening excel file
Reference : https://poi.apache.org/encryption.html.
Have updated the code to eliminate compiler errors. But getting Runtime error :
java.lang.IllegalStateException: Zip File is closed
IQZ Systems
US
@JananiS77 By reading though the attached file, I couldn't find any statement which sets the password
Don't you need to have something like Biff8EncryptionKey.setCurrentUserPassword("ffff"); before you saving your excel ?
Commonwealth Bank of Australia
AU
@Byshu_Ayyappaswamy I believe Biff8EncryptionKey.setCurrentUserPassword("ffff"); is required for decryption of xls file.
Here I am trying to encrypt xlsx file type and gave password via encryptor.confirmPassword("ffff");
Accenture
GB
@JananiS77 Hi , Greetings. Did you upload any jar files? Looks like one of them might be corrupted. Can you please run the sql on table pr_engineclasses or java class lookup via admin studio and see what jars are in place?
Regards,
Bharat
Commonwealth Bank of Australia
AU
@KOMARINA No. I think the excel file generated by MSOGenerateExcelFile activity is storing excel in zip format in servicepath. So I am trying to open the file in Read_Write mode to protect where I am getting runtime exception
java.lang.IllegalStateException: Zip File is closed