Reading the sheet name from Excel (without Excel open)

Help
1

Hi all

I’d like to read sheet name(s) from Excel without opening the excel files.

I’ve spotted a few threads around and some completed Xmals, but as some of them are a few months old/seem to potentially contain errors for some users, please can I ask if anybody out there has a completed xmal that can do this?

Thanks in advance
Jordan

2

Hi Jordrowley,

Please try using Get Workbook Sheets Activity.

Thanks,
Arun

1 Like
3

Use Excel Application Scope and in properties uncheck visible option
Then use Get Workbook Sheets or by using workbook name which is given in Excel Application scope propertie: workbookname.getsheets

2 Likes
4

@ArunVelaayudhanG @ImPratham45

Hey both, thank you for replying. Sorry, my post wasn’t very clear - in the VM I am using, there is no Excel installed, so I can’t use the Excel Application Scope activity :frowning:

Thanks
Jordan

5

Hi @jordrowley,

read this post help me and will hep you :slight_smile:

2 Likes