Excel DataTable

Help
,
1

Hi All,

I’m preparing robot for the excel program.

So regarding about it robot have to copy data from excel sheet and paste to another excel sheet(already prepared excel) so that time I used to extract data store in to data table (using read range activity : Output table variable type set as DataTable) after that I add the data table activity and set the input and output values like below
image

image

But when I using write range activity cannot give the data table name due to string …

image

can you please help to go through this

Tharindu.

1 Like
2

Hi @S_D_RPA

Write range can take only datatable as input buddy
but it seems Dt_one is a string
place the datatable variable that is obtained from the read range activity that read the first excel file
Cheers @S_D_RPA

1 Like
3

@Palaniyappan Sorry buddy I didn’t get ur idea can u please explain again

I already used Output data table
image

4

Fine
Can i have a view on your xaml if possible a screenshot
Cheers @S_D_RPA

1 Like
5

Ok fine @Palaniyappan

please check below

image
image

1 Like
6

No worries
the output of the Read Range activity will be a variable of type datatable
pass that variable to Write Range activity as input for datatable property buddy
no need of output datatable and send hot key
Simple
Cheers @S_D_RPA

1 Like
7

@S_D_RPA

You have to pass copyData to Write Range Activity. Because it will take input as dataTable but not String.

8

read range for first excel and use that variable in write range for write it in other excel directly

1 Like
9

@Palaniyappan
Buddy thank u very much as u told i try that method its worked but have little bit problem

after execute below error showing,

image

im still not try to handle the exception…
can i know is this error can solve without try catch…?

Tharindu

10

@ImPratham45
thanx buddy

11

is it work for u?

1 Like
12

Mention this write range workbook activity outside the excel application scope and try buddy
Cheers @S_D_RPA

1 Like
13

I think its also work,

I already try @Palaniyappan 's method

your method also can try

thanks buddy

14

Ok
Happy Automation :blush:

1 Like
15

@Palaniyappan
I tried but still as previous

Tharindu

1 Like
16

Hee thanx broo

good day

17

Kindly share your xaml buddy if possible
Cheers @S_D_RPA

1 Like
18

wait buddy i will share.

I set the try catch activity to handle the exception…

19

Fine
Cheers @S_D_RPA

1 Like
20

Thanx broo