Match Sheet name with the config text

Help
,
1

Suppose I have a text in config. I want to check which sheet name has the text which I have in the config and get the exact sheet name from excel file

2

@Sana_Afreen Have an excel scope. In properties, create workbook variable as an output.

Then, Check workbook.Getsheets.Contains(TheText).

image
image1433Ă—788 52.9 KB

3

Hey @Sana_Afreen,

Check this workaround for you :slight_smile:

image
image689Ă—924 15.9 KB

Thanks

4

okay, After that if text exist then how to get that sheet name

5

which sheet name contains the text

6

@Sana_Afreen You will have to loop through the Workbook.GetSheets and print item.tostring if the sheetname exists as per the config value. Use below workflow for your reference,

test.xaml (7.2 KB)

7

@Sugumar8785 In write line it is giving the name of all the sheet even if the text doesnt match

8

Have you put the textexists in a if condition?

9

yes @Sugumar8785. I have used exactly what you gave. I only want the sheet name for which the text is match. But it is giving all the sheet name

10

Inside this WorkBook.GetSheets.Contains(“”) , Have you put text inside the double quotes.

As you said it is config text, you will have to use it instead of quotes.

11

Yes @Sugumar8785 I have put the text inside quote

12

Could you take a screenshot and post it here so that I can check what went wrong.

13

somehow textexists is always true

14

image
image1132Ă—535 24.4 KB

Config value is Cover

15

Sorry, My bad. Can you please change the assigned value of TextExists to item.Equals(“YourConfigText”). Updated workflow as below,

test.xaml (8.8 KB)

16

Hi @Sugumar8785. It is working fine now if I put one of the sheet name as my config text.

But the text can not always be the sheet name. For Example the text is Primary and the sheet name is “Primary Test”. So it will check for the word primary and give the sheet names in which word primary is there

17

In such cases, you will have change the condition as below,

item.ToString.Contains.toLower((Your Config String).toLower)

So If the particular word exists , it will give you the sheetname

  • If it has helped you , please mark this as a solution. Thanks.
18

thankyou so much. It worked

1 Like
19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.