Closed
How to read or parse password protected excel file in pega
Hi Team,
Can please let me know is there any process or OOTB approach to read password protected excel file in pega.
***Edited by Moderator Marissa to update Content Type from Discussion to Question; change from General to Product; update platform capability tags***
To see attachments, please log in.
Posted: 4 years ago
Coforge Limited
IN
Hi,
Which version of PEGA platform is being used for your requirement.
If PEGA 7.2 or above is being used I would recommend using Apache POI APIs as they are being shipped with PEGA instance and no further import of JARs is required.
You can use:
Workbook workbook = WorkbookFactory.create(new File(excelFilePath), password);
The above code snippet will provide you with an unencrypted Excel which can be used further for processing either through custom Java code or desired PEGA OOTB functionality.
For reference:
https://www.codejava.net/coding/java-example-to-read-password-protected-excel-files-using-apache-poi
Happy Coding!!