Generating excel file and protecting with password
I had a requriement to copy a data from pagelist to excel.
i had done these using .pyGenerateExcelFile method (.xlsx file is getting generated)but my requirement is like i need to generate an excel with .xls format which i am unable to create.Did there is any change in the template using for .xlsx and .xls?
Another requirement is the generated excel must be password protected. Did we have any activty in pega, that excel can be protected directly while generating an excel file.
***Moderator Edit-Vidyaranjan: Updated Platform Capability***
Accepted Solution
Pegasystems Inc.
IN
For xls format : https://collaborate.pega.com/question/copy-data-pagelist-excel (Duplicate post).
OR You can also go with the below approach:
PRPC ship with Apache POI - which you could utilise to convert to that format (or indeed generate in that format).
For Password protected excel:
Below page from the Apache POI docs gives some examples of encrypting EXCEL files with a password for a key:
For xls format : https://collaborate.pega.com/question/copy-data-pagelist-excel (Duplicate post).
OR You can also go with the below approach:
PRPC ship with Apache POI - which you could utilise to convert to that format (or indeed generate in that format).
For Password protected excel:
Below page from the Apache POI docs gives some examples of encrypting EXCEL files with a password for a key:
http://poi.apache.org/encryption.html