Compiler ERROR: Copying in Excel sheet : cell to cell

Learn Academy Feedback
,
1

Hi,

I am unable to Copy data : cell to cell in excel sheet.
Declared the variables from Read cell to Write Line (Activity).

Priya :slight_smile:

b1
b11366×768 34.1 KB

2

@Priyahk Cellno variable is generic change it to DataTable

3

hi indra,
I changed, but arising like can not convert datatable to generic…

:slight_smile:

b2
b21366×768 49.9 KB

4

@Priyahk Can you tell what’s your exact scenario you are doing

5

Hi Indra,
I want to copy some C2 cell into E2 cell in Excel sheet.

:slight_smile:

6

@Priyahk Check attached file

SampleExl.zip (7.4 KB)

1 Like
7

Instead of having a Write Range, use the Write Cell activity.
Then input the variable you created in the Result field of your Read Cell.

If you know that the output of a given cell will always be of String type. Then make sure that your variable has the correct type. You could also in the Write Cell activities Value field put nameOfVariable.ToString.

8

Hi Stevengoehler,

In Activity panel no write value… only write range.
So, i use both Read range and Write Range with specific cell.

:slight_smile:

9

@Priyahk glad you found a solution. I am puzzled how you cannot have both Read Cell and Write Cell activities in the Activities Panel :slight_smile:

10

Hi Stevengohler,

I use the Read rang and Write rang activity to copy the data from one cell to other cell…

:slight_smile: