Hold the specific data fields in variables, and then just use the Excel activities to write the DataTable and information held in variables into the spreadsheet Append Range and Write Cell Excel activities will likely do the trick Table data vs namevalue pairs The UiPath data scraping functions are perfect In case the number of sheets of your workbook(s) is/are unknown, simply use GetSheets which comes out of the box The idea is as follows The idea is as follows Excel Application Scope > GetSheets > Use Read Range activity and pass item under sheet name and store output in DataTable > Use Merge DataTable activity to merge all sheets data Renaming an Excel Sheet is one of the most common functionalities that we come across in most RPA implementations This Snippet allows you to do this without using hotkeys It uses vbnet code via invoke code activity It can be integrated easily with any project across different customers without any modification
Uipath Excel
