Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Roman Sveshnikov (RomanSveshnikov)
TN

TN
RU
RomanSveshnikov Member since 2018 9 posts
TN
Posted: May 14, 2019
Last activity: Nov 27, 2020
Posted: 14 May 2019 4:43 EDT
Last activity: 27 Nov 2020 7:57 EST
Closed

Output stream of Excel File after MSOGenerateExcelFile

Hello!

I have some problem with activity MSOGenerateExcelFile. I need to get the value of pyFileSource after creating the file in activity MSOGenerateExcelFile. Figure 1 shows that I commented out step 6. With this, I was able to see the pyFileSourse of the template (Figure 2). But I could not see pyFileSourse after generating excel-file.
Please help with advice. Maybe I missed something. Thank you in advance!

To see attachments, please log in.
Dev/Designer Studio
Java and Activities

Posted: 4 years ago
Posted: 16 Dec 2019 11:02 EST
Raghavendra Kirantu (RaghavendraK6962)
Bluerose Technologies
Senior Consultant
Bluerose Technologies
AU

Hi RomanSveshnikov,

1. Create an Activity and copy all the steps from MSOGenerateExcelFile.

2. Add a out parameter and set the pyFileSource before Step 6 (Page-Remove)

3. Use your activity instead of using MSOGenerateExcelFile.

To see attachments, please log in.
Posted: 4 years ago
Posted: 12 Aug 2020 4:20 EDT
Ronali Pradhan (Ronali)
AI4Process Ltd
Application Developer
AI4Process Ltd
GB

Hi kirar2,

In MSOGenerateExcelFile , the generated pyFileSource is Excel template's outputstream instead of the Excel with loaded data's stream.

Is there any way to achieve this?

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice