Expression argument as a string in Excel sheet Add / insert without overwriting the content

Help Studio
, ,
#1

Hello,
I would like to use this expression and have it written into my Excel sheet as a string. How do I do that? The string should be written under the datatable in the Excel sheet (see pictures). Thank you for your help :slight_smile:

hilfe1.1
hilfe1.1864×637 25.1 KB
Hilfe2
Hilfe2929×604 24.9 KB

#2

Hi @Maxi_B

Where u want to write the expression
Us it under the Berechtigungen column ?

#3

Yes either there or simply under the datatable where string is written on the picture

#4

U can use write cell activitiy for this to write it under the column

#5

when I do that nothing happens except that my data tables are entered in Excel.

hilfe1.2
hilfe1.2965×510 17.9 KB

#6

Specify the cell in write cell as D2

This is the place u need to write as specified in the figure

#7

now my string is overwritten again and again only in d3 and written there. My Program, It is a loop where the string should always be inserted after a read datatable. See image i would like to have my printout executed every time I run it and write it next to or under the datatable that has been read out. Thanks

hilfe 1.3
hilfe 1.3927×668 16.8 KB

#8

Hi @Maxi_B

U can create a counter outside the loop and increment it at the end of loop

In write cell use that counter to write the data

Like this

Let’s say if counter is intialised with value of 2

Then u can use

“D”+counter.ToString

#9

Okay thank you i will try this :slight_smile:

1 Like