Dynamıc sheet

[sedayngl_sedayngl33 (Seda Yüngül)]

Hi
Can u help me please ?
My output panel like thıs
VEGETABLES
tomato
patato
…and so
FRUITS
apple
orange
banana
…and so
DRINKS
water
mınerak water
…
I have excel sheet VEGETABLES(A1 CELL), FRUITS(B1CELL), DRINKS(C1CELL)
How can my robot wrıte excell sheet?

[Surya_Narayana_Korivipadu]

But I’ve already answered this question. right?

TRUE CELL writing

Are you printing this to output panel using a list or array of strings? If yes, follow the below steps: Assign rowNumber variable to 2. Also create a string variable named “column” Now you can use for each loop to loop through this list, and use string data type for looping item { If(item = “VEGETABLES”) { column = “A” } else if (item = “FRUITS”) { column = “B” } else if (item = “DRINKS”) { column = “C” } else if(item = “COLOURS”) { column = “D” } else { use write cell acti…