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

Microsoft Excel spreadsheet software has become an integral part of most business organizations for analyzing , budgeting, or organizing client sales lists.
Having Said that , Most of the Automations require an Interaction to Excel.

➤
👉 This video is a Recording of Webinar conducted as Part of Community Initiative of UiPath. If you are an Beginner to Excel Automation and Ready to take up the Automation, Go Ahead and watch the Recording.

➤

►►►► To Get the Files ◀◀◀◀◀◀

I have uploaded all the materials to my newly created Website.
👉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 .

The Video is having 2 Parts

👉 Part # 1: Explaining all the below activities of excel

Reading excel in UiPath
Excel vs workbook activities
Write data in excel
Insert/delete rows in excel
Insert/delete columns in excel
Copy sheet – excel
Delete range in excel - UiPath
Copy – values / formula / formats
Get workbook sheets in excel
Look up range in excel
Append range – UiPath

👉 Part# 2 - Workshop
Practical explanation of Real-Time Scenarios - Attendees can Follow and Build Along. There would be a Sample Excel Provided to follow along with the Presenter.
Refresh multiple pivots in excel
Append data to dynamic range
Split CSV data to multiple excel
Utilize joins in excel

➤➤➤
👉 Feel Free to comment your email Id in Comments
OR

➤➤➤
Playlist for all Excel Project Scenarios Link

➤➤➤
Playlist for all Excel Automation Activities and their usage

➤➤➤
Other Videos in the Series

⦿ Refresh Multiple Pivots in Excel
⦿ Refresh Pivots with the Help of Send Hotkey
⦿ Refresh Pivots with the Help of UI Automation

⦿ Read CSV Activity in UiPath
⦿ How do we use the Data from CSV into an Excel
⦿ Split the Data from the CSV File to Different Sheets in Excel
⦿ Write Data in Different Sheets.

⦿ How do we use the Invoke Code Activity in UiPath
⦿ How Invoke Code is Different from Invoke VBA
⦿ Write Code to Delete Sheet with the help of Invoke VBA
⦿ Address the Issues of Assembly Reference Error

⦿ How do we Compare and Paste the data in Excel
⦿ How do we Look up Data Across sheets and Merge
⦿ Loop via DataTables

1. How to Write Data in Excel in UiPath
2. What are the different ways to Write Data in Excel in Uipath
3. Difference between Excel and WorkBook Write Range
4. How to Write Data With or Without Formats

1. How to Select Range in Excel in UiPath
2. How to Delete Range in Excel in UiPath
3. Options While Deleting Range.

1. How to Copy Paste Range in Excel in UiPath
2. How to Copy Entire Sheet in Excel.
3. Copy Paste Only Values or formulas or Cell Formats or Number Formats.

1. How to Insert/remove Rows from Excel
2. How to Insert /Remove Columns from Excel.
3.Insert/ Remove at specified position

1. How to Read Cell value in Excel in UiPath
2. How to Read Cell value with Formula in UiPath
3. Write Cell in Excel Uipath

1. How to use Get Workbook Sheet in UiPath
2. How to use Get Workbook Sheets in UiPath
3. Difference between Get Workbook Sheet and Get Workbook Sheets
4.Scenarios and Usage

1. What is Macro
2. Create Macro in Excel
3. Execute Macro in Excel Uipath
4. Scenarios and Usage

1. How to create Pivots in Excel
2. How do we Refresh Existing pivots in Excel
3. Scenarios and Usage

1. What are Tables in Excel
2. Why do we need Tables in Excel
3. Create Table in Excel with Uipath Studio
3. Filter Existing Table in UiPath Studio

1. Get Table Range in Excel
2. Insert Column in Excel Table
3. Delete Column in Excel Table

1. LookUp Range in Excel - UiPath
2. Auto Fill Range in Excel - UiPath
3. Remove Duplicates Range in Excel - UiPath

➤➤➤
#UiPath #ExcelAutomation #UiPathCommunity #Automation #UiPathCommunity #MockInterview #Feedback

➤➤➤ Happy Automation !

➤➤➤ Social Media Links

[MukeshKala]

►►►► To Get the Files ◀◀◀◀◀◀

I have uploaded all the materials to my newly created Website.
👉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 .

[factstheory]

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

[malinivinnamala]

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

[vijayalakshmiboya]

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

[prashantrai]

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

[viswanathparigisree]

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

[TheHomeChronicles]

thank you for this amazing and helpful video

[Ye_timepagal]

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

[BrajVrindavanRaman]

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

[cktan]

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….

[vikasdahiya]

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.

[ketanwajekar]

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.

[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?

[rajurec]

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?

[utsav_singhofficial]

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

[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?

[jayakrishna]

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

[k.chandrashaker]

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.

[radhab.d]

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

[shaiknabi]

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