Question
Accenture
IN
Last activity: 8 Jul 2022 11:44 EDT
The decimal 1.0 in datatype record is converted as 1 in excel
Hi,
The datatype has records which contain values like 1.0, 2.0, 3.0. But on exporting these to excel, the same values are displayed as 1, 2, 3 respectively. Is it possible to retain the same format while exporting the records to excel?
Thanks,
Sakhib Hussain
IQZ Systems
US
@SakhibHussain I am assuming you are generating excel based on an excel template
In this case, you can update the template with correct formatting for this decimal format requiring column like below
Updated: 8 Jul 2022 11:39 EDT
Accenture
IN
Hi @Byshu,
I am not generating excel based on excel template.
In the data type we have records which are having 1.0, 2.0 values. There is an export button towards left where you can download the excel with all the entries. In the downloaded excel, the values are displayed as 1 and not as 1.0. Is there any solution for this?
Updated: 8 Jul 2022 10:57 EDT
Capgemini
IN
@SakhibHussain Hi Sakhib,
Looks like There is no solution for this,even if you ignore formatting while exporting it to excel and even if you keep rounding off to default (when column format as number) in the options(gear icon), after the export to excel it will remove the decimal values & it will display 1.0 as 1 and 1.80 as 1.8
IQZ Systems
US
This is how OOTB feature works
pxDownloadDataRecordsAsCSV activity calls another activity pzExportDataUsingResultSet & it uses Engine API to export the data from database table using native SQL. So what ever is stored in table gets exported as is. Hence data conversion could not be done.
