Append multiple sheets into one workbook in Studio

Help Studio
, ,
1

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

2

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.

image
image597×694 18.7 KB

image
image563×638 15.6 KB

ExcelAutomationDemo.zip (2.0 MB)

3

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

image
image1112×661 23.7 KB

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.

image
image1112×661 29.3 KB

4

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

5

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

6

The warning is actually fine !