Finding specific header in Excel

Help
,
1

I have header in Excel- ( Name , Address , Phone Number , Gender) but i have to check if the Excel contain these header or not ?

Please guide me how to do…?

2

@Tabish_Faridi

Use Text Exists activity whether the excel contains header or not.

Regards,
Karthik Byggari

3

Thanks for quick reply… can you please share any demo link or xaml if any.

4

Can you share the sample excel file please?

5

Sample Excel.xlsx (8.5 KB)

6

How you want to search the header I mean first you want the whole excel data and then you want to search that header or excel is open already and in that you want particular header to be searched?

7

Is there way to check header of an excel without opening, I guess No?

Take case- i am already in excel application scope - i want to verify only header. sample excel i have uploaded. please have a look.

8

p6.xaml (10.0 KB)

Hi @Tabish_Faridi
I think the above solution will help you out , just pass the keyword you want to search in the header of the excel. and you will get the result like true if it exist else false.

9
  • Use Read Rows with A1 as range. Output as FirstRow.
  • If FirstRow.contains(“Name”)=true
  • Writeline(“Name header exist”)
10

Thanks, Is it possible to verify all header in single go ? How?

11

Yes. You need to give AND operator.

If (FirstRow.contains(“Name”) and FirstRow.contains(“Address”) and FirstRow.contains(“Phone Number”) and FirstRow.contains(“Gender”))

12

Thank you. It worked :+1:

13

Great. :slightly_smiling_face:

Please mark the solution as solved.

14

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