Set cell in Excel

Help
1

How to set cell the Excel application inside a loop? Am able to read the Excel value one-one but unable to set it into different worksheet in same sequence.

2

Did you try write cell activity?

I hope you want to write cell in a separate sheet

Thanks,
Prankur

3

@PrankurJoshi - Yes, I tried but it is only setting the text in A1 and B1 cell only

4

Can you share an example or workflow?

5

ExcelWriteCellCode.xaml (11.5 KB)

Am reading the data from sheet1 and trying to paste it into a sheet2.

6

@PrankurJoshi - Have checked the file which i have uploaded here.

7

You will need to have a counter here and every time you write into a cell increase the counter by 1. Assign dynamic Cell Number value like this

image

Counter would be 1,2,3 and so on so your code will write in cells A1,A2,A3 and so on

Thanks,
Prankur

8

I tried to pass counter as well, but in that scenario it’s giving me an error.
Can you please share me the one example or can you do a modification on existing one share it with me.

9

Have a look at this sample

ExcelWriteCellCode.xaml (12.1 KB)