How to extract the exact value from the other sheets without rounding the decimals

How to extract the exact value from the other sheets without rounding the decimals. How to extract them

@anjani_priya

Please provide the input and output sample

@anjani_priya
Try by using vlookup or copy paste range activity

I want 21 values from 21 sheets

Use for each excel sheet

actually i have a code but in that iam getting the values by rounding off. How to get them exactly with decimals

actually i have a code but in that iam getting the values by rounding off. How to get them exactly with decimals.

@anjani_priya
Share the input and expected output.So, that we will help you out

@anjani_priya

what activity you are using to read the data “Read Range” or “Copy Paste Range”
If you are Read range Then enable preserve format option in Read Range.

sample1.xaml (17.2 KB)
this is the code i have
iam getting rounded values but i want exact values

Hi @anjani_priya

Can you please share the input excel too.

Regards

1 Like

@anjani_priya

Try by Run the code by enabling the preserve format in readrange activity Properties.

iam not getting the values

@anjani_priya
Share the input excel

Capture44
iam getting like this

1 Like

@anjani_priya

Use copy paste range activity instead of Read range

I have used preserve format but its taking more time than usual

@anjani_priya

Okay,Was it giving the correct output or not.

its giving but taking more time

How to reduce the time