Get sheets without using excel scope

[Chirag1991 (Chirag Singh)]

Hello All,

I have a scenario I want to fetch sheets name from Excel but u could not use Excel scope.
I am not well aware with invoke code that how I can use invoke code for the same

Any examples will be helpful

Thanks

[prasath17 (Guru)]

@Chirag1991 - Yes you can do using “Get sheet name” from the BalaReva.Excel.Activities

Example:

Write Line: String.Join(Environment.NewLine, Sheets)

[1996 (Neelima G)]

Hi @Chirag1991,

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 but using EXCEL APPLICATION SCOPE is very easy.

Activities - Invoke Code

Refer this Below Link hope this helps you

VB Code To Get List of Sheet Name

Hello, I’m trying to get a list of sheet names without using the Excel Application Scope. The server I’m working on does not have Excel installed. Does anyone know any code to accomplish this?

Thanks,
Neelima.

[Chirag1991 (Chirag Singh)]

Hello I do not see this activity in my uipath, could you tell me the version of this mine studion is 19.10

[prasath17 (Guru)]

@Chirag1991 - Go to Manage Packages…and add the below package…

[m.mezzacapo]

Helllo guys, i reach the goal on my end with Python. Try to following these steps:

1. Install Python 3.6 version (latest supported by uipath was 32 bit i guess)
2. Use my flow as reference to understand how it works (please consider that maybe you need to install a different version of python)
   best regards,
   MattiaGetSheetName.zip (41.2 KB)