RE: Redaing data from different Sheets

Help Studio
, ,
1

Hello,
If I Dont Have Excel Installed in My System Then Is this Possible to Extract Sheet Names From Excel File?

Thank You…!

3

Hi @IK5295,
This is one of possible way:

image
image484×649 12.2 KB

Your For Each loop need to have item set as String type:
image
And this is the result:
image

4

@Pablito I Tried this Method But I dont Have Excel in my System…

Thank You…

5

Sorry for misunderstanding. You can try this method. However is not efficient and official by any way. I’m just reading content as a raw text and using regex searching for sheetnames. But this can work slowly if excel file is bigger I guess:
(?<=worksheets\/)\w+(?<=\d)

image
image1121×606 30.3 KB

Then you need to remove duplications but it shouldn’t be hard.

6

Thank You… @Pablito I tried this But This method is not giving Exact Output or Not Reading Excel as a Text also …

7

Well it probably depends on which excel version the file has been saved. In my case it’s Excel 365 and If I will open xlxs data through notepad I can clearly see that among many unknown characters I can see excel sheet names followed by the “worksheets” word.
image
I’m not sure how is it in your case. I only showed you that it is possible to get this without excel. Just experiment :slight_smile:

8

Thank You… @Pablito I got different Method on Forum That Method is giving Exact Output…
once again Thank you for Helping …
Happy Automation…