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

 Sasidhar Bonigi (SasidharB9228)
Genpact

Genpact
US
SasidharB9228 Member since 2014 9 posts
Genpact
Posted: May 24, 2016
Last activity: May 24, 2016
Posted: 24 May 2016 7:53 EDT
Last activity: 24 May 2016 8:04 EDT
Closed
Solved

How to export report definition integer data to excel as integer

On opening of downloaded excel(from report definition) integer data is reflected as text.

Captured.png

1. Configured activity on button click

2. In activity

           Calling Rule-Obj-Report-Definition.pxRetrieveReportData(for report definition)

           Calling MSOGenerateExcelFile

3. Formatted column as numbers, excel template.

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 8 years ago
Posted: 24 May 2016 8:04 EDT
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Sasidar,

Below PDN article might solve your issue.

https://community.pega.com/support/support-articles/number-displays-text-excel-after-exporting

Kindly let me know if it resolves your issue.

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