Question

2
Replies
204
Views
Ketan1989 Member since 2012 2 posts
Morgan Stanley
Posted: August 14, 2018
Last activity: August 14, 2018
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
Share this page LinkedIn