Start UiPath Excel Automation | Excel Activities | Project Scenarios | Examples | Tips &Tricks | RPA

[@MukeshKala]

►►►► To Get the Files ◀◀◀◀◀◀ I have uploaded all the materials to my newly created Website. 👉 Visit Website : mukeshkala.com 👉Go to : Download ► Select the Video ► Download . 👉 Please let me know if you got the Files and drop a Mail - If you face any problem .

[@factstheory168]

world needs more people like him his way of teaching is soooo clear and good love it keep up the good work

[@MukeshKala]

Thank you for your wonderful feedback 🙂

[@aju920]

I am an MBA student. Could you please tell me that this automation help me in future if i studied

[@MukeshKala]

Yes Definitely you can evolve as a Automation Business Analyst

[@aju920]

@@MukeshKala thank you for your response ❤️

[@SyedAli-iq4ku]

wonderful Excel Automation

[@MukeshKala]

Thanks for watching

[@viswanathparigisree]

You made excellent vidoes on UIpath sir.. thanks a lot for your help..

[@MukeshKala]

Appreciate the feedback

[@parokitchen.]

Excel Application Scope is not available, please guide me then what should select instead of Excel Application Scope. Excel Process Scope is there. Should I select it?

[@MukeshKala]

Hello , You are in Modern experience of UiPath , Switch to Classic and you will have it - kzbin.infoQXKAw08kFLY Have a look here how to switch

[@vikrampurohit3033]

Great Session @mukeshKala

[@MukeshKala]

Thank you Bro :)

[@TheHomeChronicles]

thank you for this amazing and helpful video

[@MukeshKala]

Glad to know that, would suggest practising the activities along with watching 🙌

[@vijayalakshmiboya9288]

Excellent coverage of all possible scenarios in excel automation. Thank you so much sir. Got clear idea about excel automation. Very well explained.

[@MukeshKala]

You are most welcome

[@malinivinnamala7085]

Awesome video Mukesh, very clearly explained about Excel Automation. Thank you for sharing your knowledge

[@MukeshKala]

Thank you for your comment , Appreciate your feedback 🤓

[@BrajVrindavanRaman]

Your explanation is amazing , i can dominant on interviewer in excel automation after watched this video

[@MukeshKala]

Super ! Glad that you became Confident on Excel Automation, Cheers

[@CharvikMuddasani]

@@MukeshKala Hi mukesh can you please share files for practice

[@prashantrai5911]

That's what I am looking for.thanks mukesh, waiting for your reframwork video

[@MukeshKala]

On it Bro , Recording Done 👍 , Will Upload Soon 😁

[@prashantrai5911]

@@MukeshKala sounds good

[@cktan4291]

Mukesh, for your example in the 37-40min. If I have my data in columns instead of row, how would I put in the cell to make it go like r1,s1,t1….

[@MukeshKala]

1. So we Count the Number of Columns - Lets Say we Get 5 2. Convert that 5 to E Use the Below link for reference forum.uipath.com/t/convert-integer-to-excel-column/148078

[@cktan4291]

@@MukeshKala in my case it the cell I want to fill is BA-row. Do I just use this code ? :Convert.ToChar(Convert.ToUInt16("A"c)+1)+Convert.ToChar(Convert.ToUInt16("A"c)+0)

[@MukeshKala]

Correct , You can also use activity from uipath marketplace if you dont want to write code

[@iloveyourstatus3929]

Really Excellent🎉🎉🎉🎉🎉

[@MukeshKala]

Thank you so much 😀

[@rajurec2721]

Hi mukesh sir, your explanation always rocks. Thank you so much for your effort s. I had doubt if we doing excel automation, the excel contains 10 column of data. We need to generate business exception in case of data empty. Do we need to generate for 10 columns using if conditions. If yes but making if insides it's become deeply Nested. Please make me understand and if possible do vedio on this

[@MukeshKala]

No need to have nested loops … just one for each loop where we will loop all the columns in the dataTable…. Inside the foreach use read column activity , chek the output count .. if zero meaning it’s blank

[@radhab.d4965]

pls send me the video on queues and assets.. and this is the first time i watched ur video it was awesome.. i got more points from this video

[@MukeshKala]

Assets : kzbin.info/www/bejne/gIunaGmwocR5qqs For Queues - Practice this Use Case - kzbin.info/www/bejne/oGmodpSXgcZ5ipY

[@MukeshKala]

Thank you for your feedback.

[@pavankaranji]

Sir plz clear my doubt... using lookup range, if same value is more than 2 times in sheet. It showing only one cell location. Why not second location?

[@MukeshKala]

Because its looking into the particular Range you specified... Lets say the Forst value is available in A2 and second value is available in A10 To get the First value - I will use range as "A1:A5" To get Second Value will use "A6:A12"

[@Ye_3timepagal]

time stamp 54:45 that lookup part is okay but consider we have a excel which consists of a value ,consider "RPA " at 2 locations so which value it will give? i mean the cell reference it will give? i tried doing along with you here I purposefully I kept in the excel and run the bot it showed me some different cell which is blank

[@MukeshKala]

Instead of lookup , i would suggest , read the data always in a datatable and then do a Datatable search

[@utsav_singhofficial]

Mukesh sir, it is not required to change row count to string in message box.

[@MukeshKala]

Yes Message box can print the integer directly 🙂

[@gagansingh3481]

are you giving online training on Ui path can a non coder can learn this

[@MukeshKala]

No, I Dont have any online training , everything is available over KZbin

[@rpa6646]

Your explanation is awesome.

[@MukeshKala]

Thanks! 😃

[@vishalpande5060]

Thanks Sir!!

[@MukeshKala]

Most welcome!

[@k.chandrashaker1241]

Can we join two tables? consider if table 1 "ID " Column and tabel 2 "ID" Column are same based on this can we join both the tables to get the data in one table.

[@MukeshKala]

Yes Absolutely - kzbin.info/www/bejne/r2bXh415mrGWoK8

[@naveenshivaraj6158]

Nice video, please provide the excel for practice purpose along with you....

[@MukeshKala]

Hi Naveen - Thank you for the comment - Please drop me a note on email id mentioned in description and I shall forward the files

[@jatinnandwani6678]

Thanks Mukesh

[@MukeshKala]

Thank you

[@SyedAli-iq4ku]

👍 nice and logical

[@MukeshKala]

Thank you! Cheers!

[@jayakrishna6635]

Hi Mukesh, Lookuprange doesn't work for blank cells, is there any work around? Thanks in advance

[@MukeshKala]

Okay , Try this - Delete the blank cells First and then perform the lookup

[@jayakrishna6635]

@@MukeshKala Thanks for reply. Cannot delete the blank cells as we need to update the blank cells and corresponding rows(which contain data)

[@MukeshKala]

In that case you can write an VBA macro and invoke the same in Uipath

[@visumanelli107]

Very Nice

[@MukeshKala]

Glad you liked 😊

[@stardhanee1740]

nice work

[@MukeshKala]

Thank you! Cheers!

[@swatityagi8647]

Sir i am learning from your channel.. but i am not get one thing on youtube that, uif i have an excel i just want excel is blank or holding any value.. how can we find that

[@MukeshKala]

To Check if there are any data in sheets - just use a read range and read the sheet and check the dataTable Count , If count =0 , Sheet is empty

[@vikasdahiya181]

hello sir, when i saved annual-survey file provide by you. i could not find in excel application scope in path of uistudio. what is reason behind this.

[@MukeshKala]

- Dont use the browse functionality - Just copy paste the complete path of the file in excel app scope

[@akonhassan]

Hello Mukesh I have several items in the workqueue. Now, I want to perform the first step of the process for all items and change the reference of each item, showing the result of this first step - lets say, the result of the first step can be “A” and “B”. Now, I perform the second step, only for items with reference “A” and after that the third step, only for items with the reference “B”. So, I don’t want to process an item in “one peace flow” but step by step. How can I change the reference without deleting the item and recreating it

[@MukeshKala]

Once you have added the item to the Queue. You can retreive the Unique Reference by using transacItem.Reference. Now here , Even if u try to change the UniqueReference using assign activity say transacItem.Reference = 1234 UiPath Studio will not throw any Error , But the Item will NOT be updated in Queue. Hence , Once Added - We Cannot Update the Unique Reference.

[@rajurec2721]

@@MukeshKala can you please do vedio on this if possible?

[@maheshbaraskar4565]

Hello sir, I have a question......when one column in excel having data in percentage(%),for example 12%.....so how to use that column, How to convert it into int or Double....

[@MukeshKala]

1. Replace the % with Blank " " 2. Now you would be remaining with 12 3. Convert Now

[@maheshbaraskar4565]

@@MukeshKala ok sir

[@MukeshKala]

kzbin.info/www/bejne/rn67l5allKqEgq8 - This is your Video For Reference

[@rajurec2721]

If excel having text data and one invoice number. We don't know where invoice number containing in the excel. How we extract invoice number dynamically?

[@MukeshKala]

Your Invoice Should have a Pattern or an identification say INVC001 .... We read all the data in Datatatable and then may be LINQ would work .. we can also try reading all data in Text / csv and then apply Regex

[@rajurec2721]

Invoice number is 10 digit number

[@MukeshKala]

So we just read all the data in text and then apply regex to get the 10 digits

[@ujwalabamhane6944]

Amazing Explanation...

[@MukeshKala]

Thank you 😊

[@justvigie1518]

Hi, Mukesh. I'm struggling a bit in here. Can you help me? Scenario: I want to run a report with a formula of "DateToday minus 13 business days". What I want is that it will automatically type into it instead of typing it.

[@MukeshKala]

Hello, 1. You can always use an activity called Write Cell to Type the Values. 2 . Same like as a Human we Drag the Formula and get Values , same way a robot also can implement the formula in the Cell , So all You have to do is - Write down the formula in the cell where value is required.

[@kirankiran-bf3ow]

Task: Extract DPs into separate excel sheets with respect to Region specified. Please extract all the DPs into separate excel files, where data has been captured (excluding DP codes with decimal values, i.e. only parent DPs required, have attached the DP list ) And in each file data needs to be separated as per Region (List of regions provided in Dp list sheet) For reference have attached an sample output file, please follow the same format(File Name - 746_Data.xlsx) Please find the attached source files on which the extraction needs to be done(Retagged

[@MukeshKala]

The Comments does not allow to share files on youtube , Drop me an email to mailid available in description which part you need assistance with

[@kirankiran-bf3ow]

sir i drop the mail please checkout

[@ketanwajekar2547]

If I'm getting excel file containing data to be used every day in the same folder. And every day bot is using excel data for processing. But at the same time there will be yesterdays excel file as well in same folder which has been processed yesterday itself and I want to use that new excel file. So how to do that.

[@MukeshKala]

You would need to segregate the data ...now segregation can be done using 2 ways 1. Whenever creating excel - Create it with filename followed by system datetime ... Excel_24_09.xlsx 2. If there would be only one excel ...then create different excel sheet

[@ketanwajekar2547]

@@MukeshKala thank you...your explanation is amazing. 👍😀

[@g.e.7814]

Many thanks for the tutorial. Would you please email the files used during the tutorial.

[@MukeshKala]

Sure , Drop me a note on my mail id available in description

[@csat2710]

sir please create a video like this on pdf automation.

[@MukeshKala]

Noted , Thanks

[@shaiknabi4517]

HI MUKESH I HAVE TRIED THE SAMPLE PROJ AND THE DATA OF INDUSTRY IS NOT TRNSF TO OTHER SHEET AS IN SPERATED FORMAT

[@MukeshKala]

Hi , Try to run the Automation in the debug Mode , Also make sure that changes are being saved after the operation.

[@nithyakavitharant2013]

can u please explain the process to summarize a column of a excel or google sheet for a particuar keywords, urgent

[@MukeshKala]

Application.WorksheetFunction.Sum(ws.Range("C:C")) This is the VBA that you would have to invoke - Based on your requirement you might want to tweak the VBA . 1. Use Excel Application Scope 2. Take an Activity Called - Invoke VBA 3. Invoke the VBA for Summarization. Please Refer this video on how to use VBA kzbin.info/www/bejne/h5O9qmaNndaagqM

[@venkatapraveenmooli6699]

Hi, Is it possible to get the source file that you have used to practice my self.

[@MukeshKala]

Yes , please share your email id and I shall send you the details... Or drop me a note on [e-mail]

[@sravyab-y5f]

please upload the excel automation with modern activities

[@MukeshKala]

Yes very soon

[@sravyab-y5f]

@@MukeshKala hi sir as a beginner with a career gap from where to start the rpa UI path from scratch? and are you providing any online coaching classes for rpa ui path please share the details sir . I need a mentor.

[@MukeshKala]

I don’t have any program as such, however I can guide you to get started with - sharing a video with all the details UiPath - Where to Start Learning RPA? - Beginners - @UiPath | UiPath RoadMap for Beginners kzbin.info/www/bejne/gHrSoZyof8iVqbs

[@tanvigupta5097]

can you please share the Excel sheets as well for practise along side you?

[@MukeshKala]

Sent

[@tanvigupta5097]

​@@MukeshKala Thank you so much

[@shaiknabi4517]

hi @Tutorials by Mukesh Kala plz share the project files for practise

[@MukeshKala]

Please drop me a note on my mail id available in description

[@ShwetaGhotekar]

sir Can u share csv and xaml file ?

[@MukeshKala]

All files are uploaded on the website , please find the link in the description or pinned comment

[@priyanshumishra7831]

i dont have an Excel Application Scope?? What do i do???

[@MukeshKala]

kzbin.infoQXKAw08kFLY?feature=share Watch this video and in 2 min you will get the answer

[@priyanshumishra7831]

@@MukeshKala Thankyou So much Sir ! It really helped ,I watched a dozens of videos to solve my query , it means alot !

[@vikrampurohit3033]

Can you share me all the materials and all the xaml files Sir.

[@MukeshKala]

Sure , please drop me a note on [e-mail]

[@vinayakumar5756]

Hello Mukesh

[@MukeshKala]

Hello

[@fernanespinosa651]

Hello. Could you please share the files with me?

[@MukeshKala]

Sure , can you pls drop me a note on mailid available in description and I shall revert with files

[@akonhassan]

Guru

[@MukeshKala]

🙏🙏

[@085953a]

5:00

[@MukeshKala]

👍

[@arunshoury6121]

Can you send me the files

[@MukeshKala]

Your email id pls

[@niharikareddy1071]

Hi

[@MukeshKala]

Hello

[@tirupatireddychinnapureddy6900]

Pls send me files

[@MukeshKala]

Thank you for your comment , Shared Files over mail 🙋

[@ankitpal3052]

please hindi m bna do

[@MukeshKala]

Bilkul , Thoda Time lagega - But agar bahut urgent hai , Ek mail karo - [e-mail] and me aapko hindi me bata sakta hu excel automation.

[@Darahas-eg6pv]

can u please share those excel sheets

[@MukeshKala]

It’s uploaded on my website , please find the link in description of video

[@ThulasiK-i6b]

can u share me the files for practice purpose

[@MukeshKala]

All Code and Files uplaoded on my website : mukeshkala.com/videos-download/

[@mounika9453]

can you please send me the files?

[@MukeshKala]

Files uploaded on my website , please find the links in description