Getting the value of the Cell and paste it to another Excel

Help StudioX
,
1

Hello Everyone,

Just a beginner question. How to get the value of this cell:
image
then write it to another excel file?
image

2

Hi @Gus_Fring,

You can use read range activity, provide a range as “B1:B3” and for output of that give a datatable variable.
then write that datatable using write range with the range “B1:B3”

3

Hello @Mohsin_Inamdar ,

I sent the wrong format of the other excel file, how to do that if the other excel file has a format like this?
image

4

Then you can use write cell activity for pasting values
use three write cell activities

In 1st write cell give the range as “B3” and you can give the value in below format
dt_yourDtVariable.Rows(1).item(1).ToString ---- For address

In 2nd write cell give the range as “B5” and you can give the value in below format
dt_yourDtVariable.Rows(2).item(1).ToString ---- For Mobile Number

In 3rd write cell give the range as “B6” and you can give the value in below format
dt_yourDtVariable.Rows(0).item(1).ToString ---- For Name

Thanx

5

Hello @Gus_Fring

If you just want to copy and paste the data from one column to another in the same order, you can use Read Range activity and then use Write Range in the second excel to write the datatable.

If not you want to add it based on the cell values, you can create a dictionary.

Thanks