Question
5
Replies
514
Views
Posted: February 9, 2016
Last activity: February 11, 2016
Closed
How to use .Net dll in PEGA
We have a requirement to show a Excel report with multiple sheets and graphs incorporated in it which requires Macros to be enabled. legacy system is built on .net and it generates Excel with multiple sheets with graphs in it by using .dll. my requirement is to implement that excel in PEGA. Can we do it in PEGA? if not how can we integrate with it to use the .net dll file.
As per my understanding you want to parse the generate Excel in Pega.
Have you tried using OOB MSOParseExcelFile method? This take in parameter:
FSFFileName : Name and Location of the uploaded excel file.
TemplateRFB: Name of the uploaded binary file, it should follow <Directory name>!<Rule Name>!<extension>
MSOParseExcelFile method only reads .xls files.
https://pdn.pega.com/support-articles/unable-read-data-excel-sheet-when-file-type-xls
MSOPaseExcelFile method is implemented using Apache POI jar, you want to check if there is any API to suffice your use case to parse multiple tabs/sheet:
Apache POI - the Java API for Microsoft Documents