Write cell for each

Help
1

Helo!

i have problem with write cell i use get text variable in write cell and i use for each row but it write same cell…

2

Hi @AalpeA,

The thing is that you have to provide a dynamic range to the write cell to write in the next cell.
Steps to follow :

  1. Declare a variable as count
  2. Initialize it with the value 1
  3. In the for each loop increase the value of the count variable by 1 using assign activity.
    in the assign activity : count = count + 1
  4. Then in the write range activity, give the range as “A”+count.tostring

Then, it will automatically write in the next cell

1 Like
3

Hi,

so better for understand.
I cant declare variable as count because i use

Excel scope - for eachrow - write row - get text - writ cell number that i get from text - and again.

4

Are you passing the cell number to the write cell activity which you are getting?

If possible, attach the workflow so that I will try to understand the issue

5

@AalpeA

image
image1366×768 80.4 KB

image
image1366×768 71.5 KB

6

Anybody?

7

it is buged or something?

8

Its writing all the rows of data in the screenshot.

May be I’m not getting the question.
Can you please let me know what’s the issue?

9

issue is that get text activity output is not for each cellMain.xaml (42.4 KB)

@HareeshMR @Teja_L

10

The file is corrupted. can you please add the zip file?

11

@HareeshMR

MSCI2.zip (237.7 KB)

12

The workflow is not developed correctly. In the end, I guess you have the issue right?

  1. The write cell activity which you are using, need to be in the Excel Application Scope. Check this : https://activities.uipath.com/docs/excel-write-cell

  2. Get row item is used without the iterations

  3. You want to write a datatable into an excel, you have to give write range , but you are giving write cell which is not going to write the data

The solution i guess is ,
You want to get the row item in one excel and you want to write it in another excel. So you can use Excel application scope within another application scope.

Open Excel application scope and read the data using for each row. Inside that for each row, use another application scope to write cell value. If you want to check the value, use If activity before opening second application scope.

13

No,

I want .Excel get the row item - write to sap - sap output NUMBER - and this NUMBER write to column K to excel but this NUMBER is not working as for each row and it write same cell K1 i want to write K1 again proces and write K2 again proces and write K3

14

Its just a simple thing then,

  1. Declare a variable as count and Initialize value = 1
  2. Then before the write cell activity, use assign activity to increment the value by 1
    As : count = count + 1
  3. In the write cell activity, give the range as :
    “K” + count.tostring

It will automatically increase the cell value and write your value to the next cell

15

It not work or i m idiot…coount

KS is output from sap

16

Leave KS as it is the data you want to write in a cell.

Go for new variable… Declare a new variable and do the stuff

17

first Print and check the ks value is incrementing or not.

18

image
image1366×768 146 KB

image
image1366×768 145 KB

image
image1366×768 123 KB

image
image1366×768 140 KB

19

@AalpeA… Please let me know if it is working

20

@HareeshMR

I working on this :smiley: