How to Read Workbook Sheets, Save them to file and use the list in Input Dialogue?

Help
1

Dears,

How to Read Workbook Sheets, Save them to file and use the list in Input Dialogue ?
Knowing that I’m able to do that but the execution time is too much. I’m sharing my example. Thx

2

May I know how long it takes
Especially at which stage of the process
Cheers @hsendel

3

Hello @Palaniyappan, it takes up to 10 seconds which is too much :slight_smile:

4

Hmm not a big count
May be because of the list count
May I know how many records are read and what is the list variable count passed to the input dialog box
Cheers @hsendel

5

it takes exactly 18 seconds.
it was taking more than that before and I have added one activity to calculate only the number of rows and create a list only based on that rows(not the whole column)

6

Fine
Kindly tell the process been carried out
Like what activities where used in sequence and how many records were there in the excel
Cheers @hsendel

1 Like
7

Please find in attachment my example.WBSheets2InputDialogue.zip (13.4 KB)

8

@Palaniyappan, Did you see my example?

9

sorry buddy
few mins pls
let me check now
Cheers @hsendel

1 Like
10

i got the issue its due to LOOPING of all the sheets in the excel file
as you have around 10 sheets it has to read – loop – append – write and then use that in input
image

Cheers @hsendel

1 Like
11

So what to do in this case ?

12

if we want the data from all the sheets , no other go buddy
and i hope its not taking more time and its usual, ONLY IF IT GOES MORE THAN A MINUTE we need to think upon
else its fine
Cheers @hsendel

13

I don’t need data from sheets, only get sheets names from workbook.Do I need to remove this part ?
image

1 Like
14

hmm
Fine
it seems like you are appending them all together
if the data is not needed then you can remove that APPEND LINE ACTIVITY inside the for loop and get the data from a specific sheet and try once
Cheers @hsendel

15

If I remove APPEND LINE ACTIVITY , How to print the list of Sheets?

1 Like
16

Fine
i got to know the process
even the FOR EACH loop wont lead to much time may be around two seconds just
–its because of lot of xlsx file reading and datatable formation before INPUT DIALOG BOX ACTIVITY IS used
Thats why
your process actually looks good
Cheers @hsendel

1 Like
17

Anyway Thx a lot, Still in case there is a quicker solution plz share it

1 Like
18

sure
i hope we are good now
Cheers @hsendel

1 Like