How to validate headers of an excel file (.xlsx), if they are correct or not?

Help Studio
1

I am trying to figure out a way possible in which I can compare the headers in different columns in Excel(1) against an excel(2) which contains a list of predefined headers. Can anyone please help me and provide me the solution to this?

2

@OliverH

Welcome to our uipath community.

Download below package from Uipath Connect or search for DataTable.Activities under Manage packages in Uipath studio and then use Display DataTable Columns activity for both Excel files and then compare both strings. If it is equal then both Excel files contains same ColumnNames else not.

3

Thank you Lakshman for responding. Can you please provide me a sample solution file?

1 Like
4

Hello Oliver,
Did this helps you, please check out -