UiPath Tutorial | UiPath Excel Automation | Uipath Excel Activities | Uipath ExpoHub

[@dillonmarius306]

This is brilliant! I was having such a hard time with the UiPath Course because it wasn't explaining the dt.row.indexof(row) breakdown. The message box you wrote to show in which row the robot is at is such a great way to explain the 'index'/

[@23Ashishonelove]

Thanks for this video. The index part was much much needed.

[@alvinaaleena8452]

Clear Explanation on Difference between workbook and excel scope.. Thank you..

[@BadamAnand]

The video with explanation is great. Dynamic assignment of values is important. Interested in more on this channel.

[@banupriyar2138]

What a clear explanation!! It's very interesting throughout the video. Expecting more and more videos from this topic. Good work. Thank you

[@AutomatewithRakesh]

Thank you! Hope you have visited our playlist on excel automation kzbin.info/aero/PLhTE7-JU1rhYiJi6V2z83QylMX6154BaT

[@sumitvishwakarma3793]

@@AutomatewithRakesh ok 😘

[@balajimuralidharan2026]

Tat was really awesome with you..d way yu deliver the message was so wonderful..expecting more videos from you..thank yu bro

[@AutomatewithRakesh]

Sure we will

[@preetbenipal1034]

i was struggling with the index part ...thank you so much .....5 stars

[@AutomatewithRakesh]

You are welcome

[@senthilKumar-bo2is]

bro ur explanation skill is amazing ,unique

[@AutomatewithRakesh]

Thank you so much Senthil! Please do visit our video section:kzbin.infovideos

[@surendrakotharu3687]

This is really an awesome video with great information. Thank you very much....Expecting Many More :)

[@khaledbinjameel9639]

What a brilliant video, sums up everything with perfection. Damn u deserve a million subs bro 🙌

[@AutomatewithRakesh]

Thanks for all the love Alex

[@madhusree.a7794]

Thanks for the clear explanation, it was too understandableeeeeeeeee :)

[@gethu1998]

your videos are really awesome...helping a lot...thanks again..

[@AutomatewithRakesh]

It's nice to hear it

[@saikrishna6784]

Thankyou very much for explanation brooo... its help me lot...

[@AutomatewithRakesh]

You are most welcome Sai! Keep Rocking

[@monikadev2884]

I loved the way you teach. Hope you make more n more videos on uipath automation. Also it would be helpful if u would make videos on RPA Business Analyst Interview

[@naveenakula9543]

bro weel explained best videos of ui path helps us to learn easily

[@aneesharavind9922]

Thanks Rakesh Well explained

[@akshaynewase4623]

sir want to extract the data from row 3 to row 7 only which type of activities we can us

[@rpalearner9818]

Good work ji... Neat and Clear..!!

[@bharathtimesk]

Show me step-by-step on how to create UiPath RPA to copy/paste from excel to an online form. You can share instructions with screenshots of each step OR create a video recording of steps and share with me - whichever is easier for you. Create UiPath RPA to copy/paste from the .xls attached to this online form. If you have these skills I have a job plz contact me immediately. " [e-mail]"

[@bharathkumarchalla4937]

king of explanation.....sir can we use counter instead of code....

[@vishavgupta3717]

Thank you sir. I am feeling you as my helping hand...

[@AutomatewithRakesh]

You are most welcome Vishav

[@vishavgupta3717]

@@AutomatewithRakesh sir please tell your videos are enough for complete excel automation or I need also cover it from uiacademy also? Also I need to cover data table playlist separately???

[@humbertolimaferreira2587]

good afternoon, and you can check when i use the append range, the data is recorded, however if i open the file and make some changes and save the file and the robot will extract the data again for this file, it gives error !! ! .Or the excel files cannot be manipulated manually which gives the error? error that is giving is this "Append Range: Sequence contains no matching element"

[@xcetam]

Excellent Video brother. I have a few questions; 1: How to make the Excel scope dynamic. Ex- In a parent folder 1, I have multiple sub folders created date wise and placed the files. So the BOT will select the latest file? Can it be done? 2:Also How can I copy paste excel data to another excel when it matches certain condition? Could you please guide me through ?

[@Maheshpatel-fy1tu]

Love "Automate With Rakesh "

[@AutomatewithRakesh]

Thank you

[@kstevenson3504]

Any suggestions on how to change values of cells on grids in Windows Forms? I don't see anything online. Everything is about Excel. If i have a two columns, how do i copy one value from one cell column to the adjacent column next to it? The rows will vary. Some will have 1 row other 20+. I had hoped i could use arrow keys but it said there was a scope issue. Thanks

[@AadhyaMummaWorld]

suppose if i login in to putty application there are few commands for fetching output from excel example for understanding stored in excel file(which need to be executed in putty) : A.1.cat info.txt info2.txt > mergedinfo.text 2.cat info.txt info2.txt > mergedinfo.text1 3.cat info.txt info2.txt > mergedinfo.text3 4.cat info.txt info2.txt > mergedinfo.text4 B.1cp /home/hostinger/myfile.txt /home/etc/ here if i am getting the output by (1.cat info.txt info2.txt > mergedinfo.text)it should exit from the loop and execute next set of commands i.e. B 1,if i am not getting output with command 1 then it should go to command 2 or 3 till output comes. How i need to write condition for this could you please help me if my scenario is understandable

[@mpumisetshedii]

Hi does the row index start counting at 1 and the column index at 0?

[@AutomatewithRakesh]

I think both starts counting from 0

[@tirushma]

Hell Rakesh, Can you please help me which video should i refer for checking the last used row in excel

[@amishaverma4627]

Rakesh can we make pivots without having ms excel in the machine?

[@AutomatewithRakesh]

Hi Amisha, I have never tried that, I think excel is required for the pivot.Check if you have an workbook activity for Pivot and let me know

[@amishaverma4627]

@@AutomatewithRakesh thanks for replying but with workbook activity there is no way to create pivot table

[@maniguru6553]

Hi bro, Thank you, great video making and explaining content. This make a easy to understand beginner as well. I want one think in UI path like how to get a data from Excel and search a web and get the particular data from(any label text) in a web page and stored in to the same excel sheet. Kindly u make a video for this bro.

[@bhavanasairam3007]

hi sir, for me everything worked properly except the write cell operation it shows always ....failed setting the current sheet to sheet1 exception type:uipath.excel.excelexception I have checked my excel extensions and updated still it was showing the same and im getting the same problem in pdf automation when im using the write cell please help me

[@stefanomarcon9382]

Hi Rakesh, first of all thank you for your tutorial........amazing usefull. I follow all your instruction but I have a problem with office 365 when I have to use For Each Raw. Have you any tutorial on this matter?

[@prashanthreddyjonnalagadda1961]

thanks for the great explanation

[@AutomatewithRakesh]

You are most welcome

[@shrutikadongre1046]

Hello sir, very well explained..thankyou so much, although I have a doubt in the write cell part.. why didnt we use range as D2 directly instead of quoting the whole expression?

[@krishnakrishh9589]

I think directly giving D2 is static or hard coded, and execution goes row by row, when we give D2 it will go on replacing the value in D2. so, by writing expression it will write on row by row.

[@factosity8021]

As we know excel application scope having more benefit than workbook. Then in what situation we have to use workbook. Or why there is need of workbook if all work we can do using excel application scope?

[@AutomatewithRakesh]

Workbook has a special feature for example if you are using write range activity of workbook and in case the file does not exist with that name it will create a file automatically and write it

[@soujanyakota5063]

could you explain the excel formula you used to write the status "write cell formula"

[@aleenamariyamt4555]

excellent work

[@Aruncharm]

Hi, Thank you for posting these videos, helps in learning UiPath. Need your help please. I have my Uipath.excel package installed and the version is v2.16.2 but I don't get "Excel Process Scope", "For each Excel Row", "Use Excel" kind of activities. Your fix would be of great Help. Please and thank you

[@johnbennet7816]

Hi Sir, Very well explained. I cant find the "for each row" activity. I have checked under data table activity, I cant find it. Please help

[@praseethamuralidharan1170]

Hi Rakesh, Your videos are very interesting. Crisp & clear explanation. Thank you very much. Can you put videos on G-suite

[@elijahlwagula1667]

After the "Message box" text for each row,there seems to be a missing step. My "TypeInto" activity is asking for the "Use Browser" Activity. What could I be missing?

[@AutomatewithRakesh]

If you need to type in browser use the use browser application activity and check

[@elijahlwagula1667]

@@AutomatewithRakesh .thanks. Is there a lesson that can help me with this? I am entirely stuck there and I haven't found a workaround. Adding the "Use browser" Activity has lengthened the step but is not leading me to highlight the data entry points on the form to complete the process. I am not sure where to add the "Use browser" and which activity to move to next.

[@waldemarzielinski6958]

hi rakesh, thanks a lot for this very good exemple ! very instructif I even add a set Range color activity with "D"+(fulldt.Rows.IndexOf(row)+2).ToString in Range and it worked

[@AutomatewithRakesh]

Excellent

[@FedericoRaga]

Muy bien explicado!

[@AutomatewithRakesh]

gracias

[@irfanshaik2698]

well Explained bro.....

[@Blogtn18]

hi sir i have a doubt that does ui path has scope in future

[@AutomatewithRakesh]

Hi Ashwini yes the robotic process automation has a lot of scope and demand and UiPath is one of the top skill you should learn

[@Blogtn18]

@@AutomatewithRakesh tnx sir bcz in my office they are planned to put me in ui path project but my manager told to learn selenium bcz ui path has no scope sir thank u for clear my doubt sir

[@AadhyaMummaWorld]

If Excel has list of commands, that any one of the command displays the output it should come out of the loop, or else it should pick next command for getting the output in putty by using excelsheet.could you please help me how i can write code in uipath.

[@AutomatewithRakesh]

What’s is the command can you explain in more details

[@Bnikhil01]

Thanks sir 👍

[@AutomatewithRakesh]

Most welcome

[@ponnanikhil9611]

Good video.. I think some what it difficult to understand to beginners. Bcz I'm also a beginner.

[@AutomatewithRakesh]

You may start from the uipath Basics in the playlist

[@AutomatewithRakesh]

And you should find it easy

[@dattaveeravalli2446]

Sir in the Google form the places are jumbling in each time of submit,then what activities will apply in that type challenge sir.. .

[@AutomatewithRakesh]

Hi Datta you need to use Anchor Base kzbin.info/www/bejne/Y2PHfGN4Z9N3aaM

[@AutomatewithRakesh]

Use the video

[@dattaveeravalli2446]

Tq sir for trigger response and clarify that

[@Varmaraj07]

Nice explanation sir

[@Liberal_Slayer]

sir do you give ui path classes?

[@AutomatewithRakesh]

Right now all my classes will be on KZbin videos do not have enough time to conduct online classes

[@akepatisujitha53]

Hi can you please provide that google from link it will hlp to practice

[@WanderRoads]

Hello Sir, Can you please try making video on SQL query execution using UiPath? I did not find a right video on what is a SQL server , What is workbench or clients and What Data sources do? though I am able to configure it now, I would love to see your high quality content and step by SQL lessons , configuration till use cases. Really appreciate your efforts.

[@AutomatewithRakesh]

Hi Rajesh, sure, will try to create contents around it

[@WanderRoads]

@@AutomatewithRakesh that's amazing 😍 thank you so much.

[@sathishkumars5468]

I guess instead of typing "D"+readDT.Rows.indexOf(row)+2.. We can created Counter variable default value 1 and In assign activity add value (counter+1) for counter variable and type : "D"+counter.toString in write cell activity

[@AutomatewithRakesh]

Good Satish we can do it multiple best ways! Keep it up

[@AutomatewithRakesh]

More dynamic is better

[@poddarfamily]

Hello sir, can you make video on latest changes in Ui path tools, in new version many changes so I am confused

[@AutomatewithRakesh]

In the activity panel click on the filter option and click on show classic you will get all the activities

[@pogabudditabassum4982]

This error has been occuring An organisation unit is required for this action errorcode:1101 can u help me out

[@AutomatewithRakesh]

I’m not sure about the error I mean need to check the workflow to suggest something

[@mopurkishore4600]

Awesome 👍

[@neelimakosri6477]

hi Rakesh, I am trying to read the column name but getting the below error.Not sure what could be the reason. Can you please advise Message Box: Column 'Name' does not belong to table DataTable.

[@AutomatewithRakesh]

Hi Neelima, I need to see the workflow and where that error is popping up. My general guess is that you need to check your excel file and see if there is any extra gap or space in the NAME column. Save and close it and try to re run

[@neelimakosri6477]

@@AutomatewithRakesh Hi Rakesh there are no spaces, still it wasn't working. I have used row("Name").tostring which did not work, but when I have tried using row(0).tostring it did work.

[@AutomatewithRakesh]

Looks like something wrong while using the column name! Index value is idle and does not matter if someone edits the column name in future. So good job Neelima

[@bharathtimesk]

Show me step-by-step on how to create UiPath RPA to copy/paste from excel to an online form. You can share instructions with screenshots of each step OR create a video recording of steps and share with me - whichever is easier for you. Create UiPath RPA to copy/paste from the .xls attached to this online form. If you have this skills I have a job plz contact me immediately. " [e-mail]"

[@adarshjain2745]

How do i extract table structure written/printed over a page, into an excel sheet correctly without typing it manually.

[@mouriyamathivanan215]

In my project only the then part is working and else part is not working

[@kuntumallasreekanth7454]

How to convert json file to csv are excel

[@AutomatewithRakesh]

I will try to create a video around it, Sreekanth! Mean while, You may like to watch all UiPath tutorials: kzbin.infovideos Chapter wise playlist here: kzbin.infoplaylists

[@rameshwarvishwakarma8002]

Hello Sir, i have just started learning Uipath and love all your videos. I am getting one below issues while practicing this excel automation. Unexpected error has occurred during the library compilation process: Could not find file 'C:\Users\Rameshwar\Documents\UiPath\Excel Automation\~Main.xaml'. I have checked the path and found that Main.xaml file is there on the path but still getting the error. Please help.

[@AutomatewithRakesh]

For unexpected error close and reopen application if doesn’t work restart laptop and try

[@rameshwarvishwakarma8002]

@@AutomatewithRakesh I restarted my machine and it is working fine. Thanks you so much 🙏🙏

[@piyushohri1]

Why we can't write D2 -D5 in write range cell?

[@mesunil5274]

There is no excel application scope in latest community edition

[@AutomatewithRakesh]

Enable classic from activity filter option else look for use excel application scope

[@mesunil5274]

I also tried gmail automation but it's giving the out put as invalid credentials though I have given imap activity and I'd and password correctly

[@SM-hp9pd]

Sir how can we do if the forms are shuffled?

[@phalgunvempati]

how to handle ,if we got error in current row and if we have data in next row, how to proceed without using Orchestrator.

[@WakoKiler]

Wouldn't it be better to create a variable called counter where counter = counter+1 and give it a default number 1 and then in write cell do "D" + counter. Just my suggestion.

[@AutomatewithRakesh]

yes you can always develop a better logic! If it is capable of achieving what is required than all good!

[@Expert_Tony23]

hii...can you please tell me the importance or future scope of this automation?

[@AutomatewithRakesh]

Are you asking about this example in this video or in general you wish to know the future scope of automation

[@Expert_Tony23]

Noo.. I was asking for in general scope of this kinds of automation in future... Where else it could be used... And do companies really hire for these automations.... Etc?

[@AutomatewithRakesh]

Yes the future of IT is automation. The next era is of automation where machines and bots will do all the mundane and repetitive jobs

[@AutomatewithRakesh]

We are just in the starting phase of this era and learning this will be of great benefit in my opinion

[@nitaprasad3855]

I have a user interface where I have to put image from Excel file . Is that possible in UIPath ? How can we do that ? Can you make a video on that plz?

[@AutomatewithRakesh]

Can you please share the application name where you would like to paste the image

[@vsuguneswari]

(Q).What activity should you use if you want to add to the existing .xslx document? (1) Workbook write range (2) Excel write cell (3) Excel append range (4)Workbook append range

[@saikiran.madana]

Can you please do the video of Excel as database

[@yaparalanaveen4543]

sir i am not getting employee sheet please help me.

[@AutomatewithRakesh]

Which employee sheet !! Do you need?

[@SanjayRathod-gp4uo]

Hi bro... You are doing a great Job... I am Working to Automate Tracenet website ( I mean trying to fill data from Excel to Webpage) At login page each time Request id on address bar is difference and it will not allow Type into activity to perform. Also this website is not secure sing at address bar beginning. I cant type id in selected box. kindly help me. i am learning a lot from your Videos and hope for positive response from your side. Thanks a lot.

[@AutomatewithRakesh]

Hi Sanjay for such instances you need to use dynamic selectors. Please follow Selectors playlist which will help you

[@soundharrajan356]

Hi r u providing online class (RPA UIPATH)

[@AutomatewithRakesh]

Ho Soundhar not as of now because of my busy schedules

[@divyapv4292]

Good

[@hemanthk2561]

Plzz do REFrame-work project with using orchestrator bro... that's is the difficult one we want change the arguments in transaction State, and we want add arguments, i saw one video bt i can't get it, plzz do the video bro

[@AutomatewithRakesh]

Hi Hemanth, I have already published 3 sample projects in RE Framework, hope you had a chance to visit them! In case you have not had a chance please visit the video section of my youtube channel

[@AutomatewithRakesh]

We have covered in detail the state transaction state using Orchestrator

[@hemanthk2561]

Ok bro i will see now....i am downloading ur all REFrame-work videos....😊

[@hemanthk2561]

I already saw the videos bro, bt i am expecting another project with REFrame-work bro..

[@hemanthk2561]

Really thanks for u support and ur clarifying our Queries, my frnd Srinath is torchering about mail activities right... thanks for supporting us...🥰

[@madhushashi06]

Hi... I have used "=TEXT(H2, "mmm-yy")" in UiPath Write cell activity... but it is giving error.. although it works perfectly in Excel... Could you please help here to solve :)

[@AutomatewithRakesh]

Hi Madhura use this video kzbin.info/www/bejne/g6uYh4aPg692eLM

[@madhushashi06]

@@AutomatewithRakesh Thank you so much for reply 🙂.... I will check video and let you know if it solves my problem.. Thank you

[@hemanthk2561]

Bro waiting for REFrame-work project bro

[@sakshampratapsingh1955]

Done

[@juannepomuzeno4517]

COMPLETEDDDDDDDDDDD

[@AutomatewithRakesh]

Good Job! Continue the learning Journey! You can do it!

[@techeewithshashi6865]

Error ERROR Validation Error BC30512: Option Strict On disallows implicit conversions from 'String' to 'IReadRangeRef'. Main.xaml Error ERROR Validation Error Activity is valid only inside the "Use Excel File" scope. Main.xaml getting this error what i have to do sir this error is from READ RANGE