Posted: 14 Aug 2018 3:04 EDT Last activity: 14 Aug 2018 3:41 EDT
Export to Excel does not have format
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