How to get all the data from a single excel documents but different sheets

[pravin_calvin (pravin kumar)]

Hi @Rahul_Singh_Kamboj

Well! You can try by joining Data tables Using LinQ.

Please refer the thread below!

Can we perform Joins and filters on multiple datatables (more than 2)?

I have to read data from multiple sources and then have to perform some inner joins and take out final result. i.e. I am planning to read data from Source1 and store in DataTable1 similar, from Source2 to DataTable2 and so on. I have to perform some inner joins and apply some conditions to get the final result. Can we do it? In ‘Join DataTable’, we can perform an action on only 2 tables.

And Looping @ppr @Yoichi @Palaniyappan @lakshman for more elegant Methods!

Regards