Excel Automation - Real Time Project Scenarios and Solutions

During one of my #Excel #Automation #Project with #UiPathStudio , Faced an situation where I was restricted to use the components/activities from the UiPath Marketplace and had to automate the process with only the #Activities provided by UiPath.

Hereby sharing an playlist of project automation scenarios that can be beneficial during excel automation :

⦿ Hide Columns in Excel
⦿ Unhide the Columns in the Excel file
⦿ Unhide all the columns at once .
⦿ Compare and Paste the data in Excel
⦿ Match and Paste Data Across Sheets
⦿ Look up Data Across sheets and Merge
⦿ Loop via DataTables
⦿ Loop inside the Invoke Code
⦿ Delete Multiple Sheet with the help of Invoke Code
⦿ 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.
⦿ Get the Dynamic Cell in the Excel
⦿ Write Data to Sheet where Data is Not starting from the Cell A1.
⦿ Refresh Multiple Pivots in Excel
⦿ Refresh Pivots with the Help of Send Hotkey
⦿ Refresh Pivots with the Help of UI Automation

Appreciate Your feedback :slight_smile:

Playlist Link :


Any idea to do the automation for values in the below highlighted column(Col D) based on other columns…

Any help appreciated. Thanks in advance!

#uipath #rpa-discussions #excel-tables #balareva #excel-formula #vba-excel-macros

Uploading: image.png…