Get Employee details form Excel

In Excel sheet have 100 employee details , How can search one employee details . Please help to me.

Hi @Balamurugana

How u search the employee details

what input you are giving. Can u please elaborate?

Regards

Nived N

Happy Automation

Hi Naved,

Input is Employee ID,

So u need the complete data about employee in final?
is it right?

Correct

Hi @Balamurugana
Check this sample workflow
sample workflow.zip (2.0 MB)

Hope it helps you

Regards
Nived N
Happy Automation

2 Likes

Thanks Nived.
how to use IF condition, attached samplesample workflow.zip (8.1 KB)

Hi @Balamurugana, you can get the row count of the Data Table variable (dt2) to check this like: dt2.rows.Count > 0.

If the dt2 has at least 1 row of data, your employee details will be printed and if not, it won’t print anything.

Hope this helps!

Good workflow, by the way @NIVED_NAMBIAR :slight_smile:

1 Like

Working find. Thanks for your support

1 Like