Question

4
Replies
1394
Views
 Fahad Khan (Fahad.Khan)
Cognizant

Cognizant
GB
Fahad.Khan Member since 2014 12 posts
Cognizant
Posted: December 5, 2018
Last activity: December 5, 2018
Posted: 5 Dec 2018 10:02 EST
Last activity: 5 Dec 2018 10:47 EST
Closed
Solved

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?

Low-Code App Development Data Integration Java and Activities Case Management Reporting
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: 2 years ago
Posted: 5 Dec 2018 10:38 EST
Fahad Khan (Fahad.Khan)
Cognizant

Cognizant
GB

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. 


 


 


 
Posted: 2 years ago
Posted: 5 Dec 2018 10:47 EST
Chithra Jayakumar (jayac2)
PEGA
Principal Software Engineer
Pegasystems Inc.
US

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.