How can I get sheet name and data (specific row) in dynamic using the activities in workbook? To be more specific, I have an excel file which contains 15 sheets, I would like to get all sheet names in that excel file. Then, I would like to get the data in the specified sheet name.

Hi welcome to uipath community we can do that with INVOKE CODE activity where we can mention the vb.net code to get all the sheet name from a excel https://docs.uipath.com/activities/docs/invoke-code but using EXCEL APPLICATION SCOPE is very easy…may i know why you dont want to do with that Che…

Get sheet name and info without using Excel application scope

Help

balupad14 (Balamurugan) November 28, 2019, 4:18pm 5

Hi ,
Here is an activity to get only sheets name

Regards
Balamurugan.S

4 Likes

How to get all Sheet names of excel using modern activities

Topic		Replies	Views
Get sheets without using excel scope Activities excel	5	1717	October 19, 2020
How to get all the sheet names of excel without opening excel Studio uiautomation	9	4659	September 30, 2021
Get Excel sheet name without app integration activities Activities excel , activities , studio	2	1286	November 29, 2021
Is it possible to get sheet's names without opening Excel? Help excel , activities , studio	16	4306	October 29, 2018
Need excel sheet name dynamically without installing excel software Help excel , activities	10	4828	August 31, 2018

Most Active Users - Yesterday
Anil_G
ashokkarale
V_Roboto_V
Yoichi
sharazkm32
eliamma.joseph
Vaishnavi_RP
sullivanne
nikhil.chandre
Alan_Riquelmes
More details...

Get sheet name and info without using Excel application scope

Related topics