Automating Complex Excel Processes and Data Table through RPA

Watch a practical example of how to sort data in an Excel file and iterate through all rows. Learn how UiPath operates with Excel and Data Tables:
- Excel application scope
- Opening a workbook - access modes
- Read and write range
- Output datatable
#RPA #AutomationFirst #UiPath #RoboticProcessAutomation
🚀Join our community for more updates:
Blog - www.uipath.com/blog
Developers’ Blog: www.uipath.com/community/rpa-...
Connect! - connect.uipath.com/
LinkedIn - / uipath
Twitter - / uipath
Facebook - / uipath
#ExcelAutomation #DataTableAutomation

[@juniorfumi7860]

00:00 - Introduction 00:45 - Excel 05:21 - Miscellaneous Spreadsheet Activities 07:15 - Sort Table 08:10 - Read/Write Cell 09:28 - Resume 10:02 - Pratic Exemple

[@aden1368]

mvp

[@blackmarkit7752]

This is awesome! I've been working in automation for a few years and still learning. Thank you

[@alickrodrigues9836]

Helped a lot and learned new things thanks and keep making such informative video tutorials

[@arjuneol]

Gosh just this small video is informative and saved me hours of searches and hit and trials. Thanks a Ton!

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@krisbal2608]

Great video

[@SyiarDigital]

thank you

[@sivasankar566]

Superb one I literally like this for the Excel and data table skills.

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@LoudryAchmad]

VERY GOOD

[@Feddersen85]

It is just a general thing in UIPath videos that things are done quickly without explanation... take "rowItem" 12.17... And the next part is that on the "Certification" on your webpage the resolution of the video is too small, so I have to watch it on youtube, and fast forward on your page... Its just one of many issues on the documentation side!, besides that a cool product!

[@jeremykusnadi5148]

I am getting a type mismatch error when using the write range function. I am following your work here step by step. Thoughts?

[@ankechaithu]

VERY THANK FULL TO U USEFUL VIDEO

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@mikefardell]

Having trouble adding 'output data table' package / action... any tips?

[@loomdoby]

i have one excel with 20 columns, can we group the columns like group A:D, group F:H etc....

[@Riprog]

Great video, just a bit annoying that these small suggestion videos pops up hiding the content at the end.

[@felipesephora3397]

Does somebody know if I can copy something from Excel and paste on Internet Explorer or Google Chrome?

[@gabrielbonet]

the WriteValue activity does not appears to me instead I'm using the WriteCell activity but I get this error "Write cell: Object reference not set to an instance of an object.", help.

[@repocheta43]

HI, good as usual. Can you share the Excel file for employees data?

[@utkarshtripathi9118]

huhcsn

[@mrsjaya73]

Do you have a video to demp comparing two columns from excel 1 to two columns in excel 2 and updating excel 1 with data from excel 2 if match is found?

[@UiPath]

Hi mrsjaya73, For any technical support/questions using our Community Edition, please use the Community Forum (forum.uipath.com/) and also check the Resources page (www.uipath.com/developers/guides-and-resources) as they cover all the theoretical and practical knowledge on UiPath. If you are using the Enterprise version, please fill out this form: www.uipath.com/company/contact-us/contact-technical-support

[@Radhakrishnan]

For the Pratic Exemple, if I put the "For Each Row" inside the "Excel application Scope" then I can fetch the data and filter the result. If the put the "For Each Row" outside the "Excel application Scope" then I am unable to fetch the data.

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@alanooi1005]

Is there any source to get the sample excel file been used in the training?

[@utuberay007]

what if there are errors in macro, will UIpath picks up errors and shows and also will it call macro asynchronously OR synchronously

[@OurStoryz123]

Ray, for that you can use try catch activity

[@maciejk4185]

Logistyka UMCS przejmuje ten filmik!

[@TotiDan123]

Where can i got to the Advanced training? I just finished the "RPA Developer - Basic Training" in the academy but i cant find the advanced training on your website.

[@naveenkumar-mh3sf]

Advance RPA training will get only on your company sponsorship..it is not free as Basic Training

[@dharmateja3379]

Hi @porhallur where u completed basic training can you please provide me link thanks in advance

[@bhavanie5819]

how to transpose rows into columns? Kindly explain

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@raspierwin2194]

Hi, i am following your step and at minute 4:23, the scope only available for do and sequence. There is no write/read excel. Do you have any idea why?

[@M-Topor]

Right it's like you write. Select "Sequence" and it works.

[@DavidMwangikamau]

did you ever get a solution to this?

[@DavidMwangikamau]

for the solution to this--> stackoverflow.com/questions/46196455/uipath-excel-file-read-write

[@MehediHasan-cs8fu]

Hardcopy to excel?

[@UiPath]

Hi Mike, please check the forum for more technical queries: forum.uipath.com/

[@VladimirSanchez]

What can be done with RPA and UIPath that can't be done with Python?

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@mishmohd]

having trouble justifying the last three names' inclusion in the new table

[@aspirants_adda6984]

How to read excel data in data table

[@utkarshtripathi9118]

kzbin.info/www/bejne/b6bZaKiFbLStj7c

[@LoudryAchmad]

TESTINGTESTING

[@LoudryAchmad]

VERY GOOD