Question

MSOGenerateExcelFile Activity creates Flat file

I am using MSOGenerateExcelFile activity to generate an excel from a Pagelist. The file that gets downloaded is a flat file. No extensions. The data is fine. If I add .xlsx at the end of the file name, it converts to Excel sheet and data can be seen.

I want to directly generate an excel file. Am I missing anything?

Correct Answer
December 5, 2018 - 10:47am

Issue resolved. Thanks for the help.

I missed "FileName" with extension in params.

Comments

Keep up to date on this post and subscribe to comments

Pega
December 5, 2018 - 10:20am

Hi, Make sure you have the activity configured correctly and here is a post that might be helpful:

https://community1.pega.com/community/pega-support/question/generate-excel-pagelist

December 5, 2018 - 10:38am

Hi

The file has been configured correctly. Template uploaded in binary file.

Params passed- 

FSFileName: "MyReport"

TemplateRFB: "excel!reportTemplate!xlsx"

Download: true

 

Still it creates a Flat file. I am using pega 7.2.2, SDI framework. 

 

 

 

Pega
December 5, 2018 - 10:47am
Response to Fahad.Khan

You must have the filename with extension in order to create the excel file. As you mentioned at the beginning of your post, configure the filename with "xlsx" extension.

December 5, 2018 - 10:47am

Issue resolved. Thanks for the help.

I missed "FileName" with extension in params.