Need suggestion which one is most suitable for UiPath to do excel / Data table manipulation to learnLINQ quires or SQL quires

Help
1

Hi All,

Thanks in Advance.

which one is most suitable for UiPath to do excel / Data table manipulation to learn LINQ quires or SQL quires
Kindly let me know good website or channel in youtube to follow.

Best Regards,
Naveen Ch

2

Hi,

There are more information and challenges in the community for excel/datatable and sql related queries you can have look into them.

or you can try to load a excel into datatable using excel application scope read range and perform linq operations using assign activity and learn more about it.

For database related activities you can use excel as database or you can load from database using database activities.

Let us know if you can get the details from form.

Regards,
Pavan H

1 Like
3

I would say both as are important, as it fully depends on the automation process.
If it uses a database then obviously SQL is important but you may also need Linq to manipulate the input data.

If you havent looked at SQL before W3 Schools - SQL gives a good introduction.

For Linq - Linq Learning is a good place to start.

There are many more places to learn online, a simple google may give you more detail your require for those.

2 Likes