Question

5
Replies
543
Views
 Vinay Yadulla (VinayY76)
Pfizer

Pfizer
IN
VinayY76 Member since 2016 1 post
Pfizer
Posted: February 9, 2016
Last activity: February 11, 2016
Posted: 9 Feb 2016 11:27 EST
Last activity: 11 Feb 2016 1:16 EST
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.

User Experience Low-Code App Development
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 9 Feb 2016 18:57 EST
Sirohi (AdityaSirohi930765655)

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
Posted: 5 years ago
Posted: 10 Feb 2016 0:02 EST
Vinay Yadulla (VinayY76)
Pfizer

Pfizer
IN

Hi Aditya,

Many thanks for the inputs but I want to generate excel with multiple tabs in PEGA.

I am aware of export to excel with 1 sheet but not sure how we can do it for multiple sheets.

In current system they are using .net dll to generate the excel, can we make use of it to generate the excel from PEGA?

Regards,

Vinay
Posted: 5 years ago
Updated: 5 years ago
Posted: 10 Feb 2016 0:22 EST
Updated: 10 Feb 2016 0:23 EST
Bhanu Prakash G (Prakash.)
Process 360
Senior Consultant
Process 360
IN

Hi Vinay,

You can generate an excel file using MSOGenerateExcelFile activity (the data from pega can be populated in to multiple tabs). Look at the references to this activity to understand on building the template excel file.
Posted: 5 years ago
Posted: 10 Feb 2016 7:52 EST
Chris Koyl (ChrisKoyl)
PEGA
Client Support Engineer Senior Fellow
Pegasystems Inc.
US

Hi Vinay,

I understand that you want to reuse the .Net dll because the coding is already done and if integrated will produce the same end results. That is good reuse.

Couple of questions for you.

Where does the .NET DLL get the contents for the output of the excel content? Are the inputs provided to public functions defined in the DLL? Will the inputs have to come from contents in PRPC now?

Is this DLL actually running in macro code within the Excel document?

How do users access this Excel file now? Are they accessing via a browser to a .NET web application?