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
@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
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?
@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
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.
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
