Compiler ERROR: Copying in Excel sheet : cell to cell

excel
studio

#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:


#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:


#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)


#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: