How to get sheets from Excel or check if sheet name exist

Help Something Else
, ,
1

I need to do something (e.g. inside If sheet.name(“sheet3”) condition is true). How Can I get sheet name from my excel file?
P.S. Modern design experience mode…

2

@vlast

Welcome to forums

Use Excel Application scope and give the path of the excel file

Now use Get Sheets activity and declare a variable

Use For Each activity and change the type argument to String and pass the variable you created in Get Sheets activity

Inside For Each use If condition and write as Item.ToString = “Sheet3”

Then-> Place a Messagebox and True
Else → Place a Messagebox and False

Hope this will help you

Thanks

3

@vlast

If you want to break the loop once the condition is true then

You can place the break activity

Hope this will help you

Thanks

4

As I know Use Excel Application scope does not exist in Modern

5

Provide sheet name as you want to exist in if condition that particular sheetname exist or not

image
image582×544 9.68 KB

2 Likes
6

I have Excel Process Scope instead Excel App Scope. Do you know solution for modern?

7

use this with latest

image
image698×697 20.1 KB

8

Thanks.
One more question.

Why if I search For Each Excel Sheet Activity it exist but does not exist in Workbook without searching ?

P.s. Hope you understand what I talking about. Forum does not allow me posting screenshots :confused:

9

use snip tool and paste it and send it to me

10

Are You mean use ctrl+C & ctrl+V to paste image? It`s not work too

11

*This also doesn’t work
(Can’t find edit button)

12

Can you ping me on my mail: sg2070156@gmail.com

13

Thanks. No need more. Also I found how get current sheet use code:
Excel.SelectedSheet() it return current sheet.
Also Excel.Sheet is IWorksheetIndexer. Interesting, how I can use it to return sheet what I need something like this?

var sheet = Excel.Sheet.Select(x=> x.Name=="sheet3")

where it can be represented to Assign activity

14

ok great

15

I am facing this issue can you please help me Vlast

16

what buddy? tell me

17

Hi, the solution of @Sagar_Gupta1 is almost complete. Just change the condition to CurrentSheet.Name.ToString instead of CurrentSheet.ToString :slight_smile:

19

I know I’m a bit late, but in case anyone needs it: The C# version that worked for me (I needed an exact match) is: YourExcel.SelectedSheet.Name == “YourSheetName”