Excel Data paste as with value

Build
#1

Hello Everybody,

Can I know is there have any method to get the excel data to write range (I mean copy some excel values and paste to another excel using write range ) as with value…?

Thank u

#2

yah
we can use excel application scope and use read range so that we will be getting a datatable
which can be passed as input to write range activity from workbook activities to write into another excel sheet

Cheers @S_D_RPA

#3

Hi,

nop I mean I already get the values but after paste values are not paste with applied formula format… is there any method to get the full value format from source excel…?

Thank u

#4

Hi @S_D_RPA

You Can Use “copy paste range”

Thanks

#5

Hi

I need get the value from separate workbook to another workbook…?

#6

Hi @S_D_RPA
Ya,you can use copy paste range and in properties pane there are so many options are available.As per your need you can change like value or formula etc.And also you can input your range.

Thanks
Capture