Question
Accenture
IN
Last activity: 18 May 2023 12:30 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
Accepted Solution
Updated: 18 May 2023 12:30 EDT
Accenture
IN
Hi All,
I was able to get the solution for my requirement.
Steps to load the data in excel without losing original CSV formats:
- Export the file by clicking Export.
- Open a new excel and go to Data -> From Text/CSV
- Select the exported csv file
- In the Data Type Detection->Select Do not detect data types
- Click on Load to import the data without losing the CSV format
- Save the file with .csv extension. This way you can get the CSV file with actual decimals.
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.
Accepted Solution
Updated: 18 May 2023 12:30 EDT
Accenture
IN
Hi All,
I was able to get the solution for my requirement.
Steps to load the data in excel without losing original CSV formats:
- Export the file by clicking Export.
- Open a new excel and go to Data -> From Text/CSV
- Select the exported csv file
- In the Data Type Detection->Select Do not detect data types
- Click on Load to import the data without losing the CSV format
- Save the file with .csv extension. This way you can get the CSV file with actual decimals.
Thanks,
Sakhib Hussain