Append multiple sheets into one workbook in Studio

Hi Team,

Hope you are well. I need help. I have two separate workbook.

  1. Book1 - Sheet1
  2. Book2 - Sheet2

I want to insert the sheets of both the workbook into a new workbook. so it should have
3) Book 3 - Sheet1, sheet2

I am new to this tool and i have searched for the solution but couldnt find the xaml . Can you please share,

Thanks,
Sri

1 Like

Hello @srinivas_pradeep

You can use the attached workflow. Input files are there in the InputFolder and output is generating in the exceldt.xlsx file.


ExcelAutomationDemo.zip (2.0 MB)

1 Like

Hi @Rahul_Unnikrishnan ,

Thank you so much. Really appreciate your help. Can you please help me with the below? When
i tried to open the xaml its giving the warning sign that

Also can you please help me how to install this library “Use Excel File” ? When i try to check in the managed package or search activities i am not getting this.

1 Like

Hello @srinivas_pradeep

These are the modern activites. Can you.plz check whether you are using modern designer

Else right click on the project in the project panel and in the settings use modern designer for this project.

What is the warning message? Can you share that here

1 Like

Hi @Rahul_Unnikrishnan ,

Thank you for the clarification and reply. Sure i will try to use modern designer for this project.
The warning is "Uipath recommends using “Use excel file” inside Excel Process scope.

Thanks,
Sri

1 Like

The warning is actually fine !

1 Like