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

 Ketan Vishwakarma (Ketan1989)
Morgan Stanley

Morgan Stanley
IN
Ketan1989 Member since 2012 2 posts
Morgan Stanley
Posted: Aug 14, 2018
Last activity: Aug 14, 2018
Posted: 14 Aug 2018 3:04 EDT
Last activity: 14 Aug 2018 3:41 EDT
Closed

Export to Excel does not have format

Hi,

I am exporting data to excel using MSOGenerateExcelAndSaveToWorkFileAttachment though it is exporting but it is not retaining format while exporting every column is exported as string ,I have column having double values which is exporting as string causing trouble to business as they apply formulas to these column.

For example : double value =1234.567898

My requirement is to default round off and export this value as number in excel like 1234.57

To see attachments, please log in.
Pega Platform
Java and Activities

Posted: 6 years ago
Posted: 14 Aug 2018 3:41 EDT
Ketan Vishwakarma (Ketan1989)
Morgan Stanley

Morgan Stanley
IN

Hello Pawan,

Thanks for replying , but the problem is it sill export the numeric values as string in excel but i want them to be formatted as number.

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