How to Add dynamique number of rows to Auto fill Range activity

[Soudios (Sou)]

[prasath17 (Guru)]

@Soudios - What is the variable type of NBLignes?

Before the Auto Fill range…Please use the writeLine and print the value and check…

[Soudios (Sou)]

INT32

What i want is to count the number of rows and put on auto fill range for example :
“A1:Z and the number of rows”

[prasath17 (Guru)]

@Soudios - Then please add like this…

““A1:Z” + NBLignes.tostring

Beaceus Source Range field accepts only string type…

[Soudios (Sou)]

yes so how can i do ?

[ppr (Peter Preuss)]

it looks like the studioX Activity Copy/Paste Range is used.

Any Reasons for this?

When using the Excel related Copy/Paste Range activity:

You can work on String base

[prasath17 (Guru)]

@Soudios - Just add .tostring as shown above.

I have given the code already.

[Soudios (Sou)]

@ppr

Yes because copy sheet doesnt work for me