Question

2
Replies
231
Views
Ketan Vishwakarma (Ketan1989)
Morgan Stanley

Morgan Stanley
IN
Ketan1989 Member since 2012 2 posts
Morgan Stanley
Posted: August 14, 2018
Last activity: August 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

Pega Platform Data Integration Java and Activities
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.