Get Employee details form Excel

Balamurugana · February 17, 2021, 5:39pm

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

NIVED_NAMBIAR · February 17, 2021, 5:40pm

How u search the employee details

what input you are giving. Can u please elaborate?

Regards

Nived N

Happy Automation

Balamurugana · February 17, 2021, 5:42pm

Hi Naved,

Input is Employee ID,

NIVED_NAMBIAR · February 17, 2021, 5:43pm

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

Balamurugana · February 17, 2021, 5:43pm

Correct

NIVED_NAMBIAR · February 17, 2021, 5:53pm

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

Hope it helps you

Regards
Nived N
Happy Automation

Balamurugana · February 19, 2021, 3:24am

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

monsieurrahul · February 19, 2021, 5:44am

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

Balamurugana · February 25, 2021, 3:40am

Working find. Thanks for your support