Hi all , i have a excel file which is extracted report from SAP i have to read the excel file and perform sum on two columns. But after reading the file i am getting the values as 1.33 or 2.44 but the actual values in the excel file are 1330 or 2440. So how can i achieve it to get the orginal values and as per the business requirment i have to disable the seperator option in excel file which i am doing but the calculation of sum is getting wrong. Please refer the screenshot
request you to read range in preserve format refer the below image.
hope it helps!!!
Already tried it does not work it takes the value as 1,26
what happening if you read without preserve format. still the values is wrong
Yes it is getting wrong values if preserve format is yes the value is 1,26 and if i disable it the value is 1.26 but actual value in excel is 1260 as you see in the excel file
Those cells in the Excel file are set to number formatting with decimal places. Try setting “Read formatting” to RawValue in the Use Excel File activity.
using mordern activities?
i tried but same issue it is reading it has 1.26 only
Hi all any solution??