Question
3
Replies
190
Views
TN
Posted: May 14, 2019
Last activity: November 27, 2020
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!
Posted: 5 months ago
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?
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.