Read A specific Sheet

Help Studio
, ,
1

Hello All,
I have created a workflow in which I am reading a specific sheet from all the excel files available in that folder.
But while running the bot gets stuck and stays stuck after opening the excel file and navigating to the excel sheet which is required for infinite duration.
What should I do.
Thanks
Over here I have attached only one… But I also need a solution to go through the same process for multiple Excel files…
Main.xaml (18.5 KB)
Input-SEZZZ.xlsx (24.6 KB)

2

@Pranay_Kumar_Bose

Did you try with read range workbook activity?

cheers

3

Hey @Pranay_Kumar_Bose ,

I have done some modifications in your Xaml File and i have attached it below
New folder.zip (24.0 KB)

It worked well for me after the modification
Below is the output screenshot

image
image1570×827 66.8 KB

Hope it helps you!

4

Its not working in my m/c…
Same result i.e getting stuck after opening the excel file

5

Can you please elaborate… cuz my rest of the workflow is using read range workbook only…
Thanks

6

I don’t know whether I can achieve my requirement using the Classic once…

7

@Pranay_Kumar_Bose

Read range workbook activity is to read the excel from backend it would not opwn only

Are you facing any issues with it as well?

Cheers

8

Hey @Pranay_Kumar_Bose , I guess you are facing difficulties because of versions of modern excel activities or something cause it worked fine in my environament
So i have modified your workflow using workbook activities instead of modern activities
Please find the file below
New folder.zip (24.7 KB)

hope it helps you

1 Like
9

@Pranay_Kumar_Bose , Adding on to it , I’ve noticed that you have 2 sheets which contains the name “Unbilled”
image

So it gives the output of last sheet in the workbook containing the name “Unbilled”

If you want the first sheet which contains the word “Unbilled”
Then after read range you can use an Break activity such that the loop gets stopped and doesn’t iterate further
Like the screenshot below

image
image499×598 12.1 KB

Hope it helps you out

Happy Automation!

1 Like
10

Sorry for Late Reply…
Thanks @Vikas_M, this is working well and is fulfilling my requirements.
Also, Thanks for the explanation regarding 2 Unbilled Sheets… I have used the break since I needed the first only
Marking It as solution for Thread closure

11

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