I want to know how to create multiple sheets in one file

Help
1

I want to know how to create multiple sheets in one file and the name is unique, and when I run uipath studio in the file, there will be a new sheet every time.

Please tell me.
Thank you.

image
image1035×54 1.83 KB

1 Like
2

@BoBou_JunG

Create one flag variable and Initialize it to 1 and then increment it one by one.

And provide sheet name like this:

         flag.Tostring+"September 62"
1 Like
3

Hi
in addition to @lakshman
–create a counter variable of type int32 with default value as 2 defined inthe variable panel
–then use a while loop and mention the condition like how many sheets needed as a set limit say ten sheets
counter < 12
and inside the loop use a EXCEL APPLICATION SCOPE and mention like this
image

hope this would help you

Cheers @BoBou_JunG

1 Like