Is it possible to use sheets names as an array in “Input Dialogue”?

Help
1

Dears,

Is it possible to use sheets names as an array in “Input Dialogue” as follows :

image
image954×615 77.3 KB

Thanks in Advance

2

Hi @hsendel,

It’s possible to use sheets name in an array like the below-

YourArrayVariable={“Sheet1”,“Sheet2”,“Sheet3”,“Sheet4”,“Sheet5”,…,“Sheet10”}

Thanks & Regards,
Apurba

2 Likes
3

Thanks @apurba2samanta, but my query is to read the sheets from Workbook and insert them as array in “Options” in “Input Dialogue”.

4

Hi,

Yes it is possible, inside an excel application scope activity place a Get WorkBook Sheets activity. This will result you the sheet names in a List(Of String) datatype, so you need to convert this in the input dialogue options as yourListSheets.ToArray()

1 Like
5

Hi @hsendel,

Please try with the below -

image
image434×549 5.75 KB

Hope it will help you.

Thanks & Regards,
Apurba

2 Likes
6

@apurba2samanta, This will only create Sheets List, How to add them to “input dialogue” ?

7

sheets.ToArray will resolve this issue.

1 Like
8

Hi @hsendel,

Input Dialogue wants input from the user. So, you can’t get value directly in Input Dialogue .

Thanks & Regards,
Apurba

1 Like
9

Fine
hope these steps would help you resolve this
–use excelapplication scope and pass the file path as input
–in this activity we will be having a output property in the property panel named WORKBOOK. Get a variable from that property named out_workbook
–now while still being inside the excel application scope use a INPUT DIALOG BOX activity where in the options mention like this
out_workbook.GetSheets.ToArray()
which will give us sheet names as a option in input dialog box activity

Cheers @hsendel

1 Like
10

Great!!! @Palaniyappan, Last thing How to exclude some sheets from this array?

1 Like
11

can i have a example
Cheers @hsendel

12

Sure. Please find in attachment where I want to exclude Sheet 3 and 4Example.zip (8.9 KB)

1 Like
13

here you go itts resolved
hsendel.zip (8.8 KB)

Cheers @hsendel

1 Like
14

have modified the code pls hve a look on to it
Cheers @hsendel

1 Like
15

is it working
@hsendel

16

I got an error message at UiPath Level, I’m troubleshooting:
The project has the same name as a referenced package (“UiPath”). This scenario is not supported and will lead to dependency resolve issues.

17

remove the project.json and open the xaml
@hsendel

1 Like
18

Thanks a lot !!! Case Closed :slight_smile:

1 Like
19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.