►►►► 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 .
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
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
@@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)
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
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
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
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?
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
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"
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.
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.
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?
Hello , You are in Modern experience of UiPath , Switch to Classic and you will have it - ruclips.net/user/shortsQXKAw08kFLY Have a look here how to switch
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
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.
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
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
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.
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....
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 ruclips.net/video/QbZy3WhqgLA/видео.html
@@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.
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 ruclips.net/video/JIopirJcbsY/видео.html
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.
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
►►►► 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 .
world needs more people like him his way of teaching is soooo clear and good love it keep up the good work
Thank you for your wonderful feedback 🙂
Awesome video Mukesh, very clearly explained about Excel Automation. Thank you for sharing your knowledge
Thank you for your comment , Appreciate your feedback 🤓
Excellent coverage of all possible scenarios in excel automation. Thank you so much sir. Got clear idea about excel automation. Very well explained.
You are most welcome
That's what I am looking for.thanks mukesh, waiting for your reframwork video
On it Bro , Recording Done 👍 , Will Upload Soon 😁
@@MukeshKala sounds good
You made excellent vidoes on UIpath sir.. thanks a lot for your help..
Appreciate the feedback
Your explanation is amazing , i can dominant on interviewer in excel automation after watched this video
Super ! Glad that you became Confident on Excel Automation, Cheers
@@MukeshKala
Hi mukesh can you please share files for practice
thank you for this amazing and helpful video
Glad to know that, would suggest practising the activities along with watching 🙌
Really Excellent🎉🎉🎉🎉🎉
Thank you so much 😀
Your explanation is awesome.
Thanks! 😃
wonderful Excel Automation
Thanks for watching
Thanks Sir!!
Most welcome!
Amazing Explanation...
Thank you 😊
Great Session @mukeshKala
Thank you Bro :)
👍 nice and logical
Thank you! Cheers!
Thanks Mukesh
Thank you
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
Instead of lookup , i would suggest , read the data always in a datatable and then do a Datatable search
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
Assets : ruclips.net/video/JZD76zl_FtI/видео.html
For Queues - Practice this Use Case - ruclips.net/video/j8EEaaLaFT4/видео.html
Thank you for your feedback.
Very Nice
Glad you liked 😊
nice work
Thank you! Cheers!
Nice video, please provide the excel for practice purpose along with you....
Hi Naveen - Thank you for the comment - Please drop me a note on email id mentioned in description and I shall forward the files
I am an MBA student. Could you please tell me that this automation help me in future if i studied
Yes Definitely you can evolve as a Automation Business Analyst
@@MukeshKala thank you for your response ❤️
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….
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
@@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)
Correct , You can also use activity from uipath marketplace if you dont want to write code
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
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
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
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
sir i drop the mail please checkout
Mukesh sir, it is not required to change row count to string in message box.
Yes Message box can print the integer directly 🙂
are you giving online training on Ui path can a non coder can learn this
No, I Dont have any online training , everything is available over RUclips
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?
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
Invoice number is 10 digit number
So we just read all the data in text and then apply regex to get the 10 digits
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?
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"
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.
- Dont use the browse functionality - Just copy paste the complete path of the file in excel app scope
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.
Yes Absolutely - ruclips.net/video/y5tVZCeLcjM/видео.html
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?
Hello , You are in Modern experience of UiPath , Switch to Classic and you will have it -
ruclips.net/user/shortsQXKAw08kFLY
Have a look here how to switch
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
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
HI MUKESH I HAVE TRIED THE SAMPLE PROJ AND THE DATA OF INDUSTRY IS NOT TRNSF TO OTHER SHEET AS IN SPERATED FORMAT
Hi , Try to run the Automation in the debug Mode , Also make sure that changes are being saved after the operation.
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.
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
@@MukeshKala thank you...your explanation is amazing. 👍😀
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
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.
@@MukeshKala can you please do vedio on this if possible?
Hi Mukesh,
Lookuprange doesn't work for blank cells, is there any work around? Thanks in advance
Okay , Try this - Delete the blank cells First and then perform the lookup
@@MukeshKala Thanks for reply. Cannot delete the blank cells as we need to update the blank cells and corresponding rows(which contain data)
In that case you can write an VBA macro and invoke the same in Uipath
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....
1. Replace the % with Blank " "
2. Now you would be remaining with 12
3. Convert Now
@@MukeshKala ok sir
ruclips.net/video/xMXfco_EQLM/видео.html - This is your Video For Reference
can u please explain the process to summarize a column of a excel or google sheet for a particuar keywords, urgent
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
ruclips.net/video/QbZy3WhqgLA/видео.html
sir please create a video like this on pdf automation.
Noted , Thanks
please upload the excel automation with modern activities
Yes very soon
@@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.
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
ruclips.net/video/JIopirJcbsY/видео.html
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.
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.
hi @Tutorials by Mukesh Kala plz share the project files for practise
Please drop me a note on my mail id available in description
Many thanks for the tutorial. Would you please email the files used during the tutorial.
Sure , Drop me a note on my mail id available in description
can you please share the Excel sheets as well for practise along side you?
Sent
@@MukeshKala Thank you so much
Hi, Is it possible to get the source file that you have used to practice my self.
Yes , please share your email id and I shall send you the details...
Or drop me a note on mailmukeshkala@gmail.com
sir Can u share csv and xaml file ?
All files are uploaded on the website , please find the link in the description or pinned comment
i dont have an Excel Application Scope?? What do i do???
ruclips.net/user/shortsQXKAw08kFLY?feature=share
Watch this video and in 2 min you will get the answer
@@MukeshKala Thankyou So much Sir ! It really helped ,I watched a dozens of videos to solve my query , it means alot !
Can you share me all the materials and all the xaml files Sir.
Sure , please drop me a note on mailmukeshkala@gmail.com
Hello. Could you please share the files with me?
Sure , can you pls drop me a note on mailid available in description and I shall revert with files
5:00
👍
Hello Mukesh
Hello
Can you send me the files
Your email id pls
Guru
🙏🙏
Hi
Hello
Pls send me files
Thank you for your comment , Shared Files over mail 🙋
please hindi m bna do
Bilkul , Thoda Time lagega - But agar bahut urgent hai , Ek mail karo - mailmukeshkala@gmail.com and me aapko hindi me bata sakta hu excel automation.
can u please share those excel sheets
It’s uploaded on my website , please find the link in description of video
can u share me the files for practice purpose
All Code and Files uplaoded on my website : mukeshkala.com/videos-download/
can you please send me the files?
Files uploaded on my website , please find the links in description