Creating multiple sheets in excel workbook using UiPath

0 votes
I want to work on an excel workbook where I want to dynamically add new sheets for entering data from data tables. But How I can create them automatically using UiPath? Can anyone please help me regarding this?
Mar 4 in RPA by Ashmita
218 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi @Ashmita, you can create multiple excel sheets dynamically in UiPath using following steps:

1. Use a Sequence activity to put all the steps in an order.

2. Use 'Excel Application Scope' to open an excel workbook. This activity will let you perform various excel operations and also would close the application once the task is done.

3. Now use 'While' condition to loop through the 'Counter' (number of sheets you want to create) and create excel sheets.

4. Then search for 'Write Range' activity and use it to create excel sheets dynamically with changing names. Here you can specify from which data table you want to write data into your excel sheet. 

5. At last increment the counter using 'Assign'.


answered Mar 4 by Abha
• 8,250 points

Related Questions In RPA

0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,090 points
1,190 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25 in RPA by Anvi
• 7,160 points
621 views
0 votes
1 answer

Pivot table in excel using UIpath

down vo I'd suggest you are going to ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,090 points
546 views
0 votes
3 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
1,458 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
217 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
830 views
0 votes
1 answer

Surface automation in rpa?

Surface automation is a visual automation that is done using ...READ MORE

answered Apr 20, 2018 in RPA by wrecker
• 3,090 points
289 views
0 votes
1 answer

Private Chrome window open UiPath

To open the browser in private mode, ...READ MORE

answered Apr 25, 2018 in RPA by wrecker
• 3,090 points
292 views
0 votes
1 answer

Using Else if in UiPath

Hi @John, in UiPath there's no specific ...READ MORE

answered Mar 4 in RPA by Abha
• 8,250 points
336 views
0 votes
1 answer

How to identify UI elements in tagged PDF documents using UiPath studio?

Hey @Smriti, if you have a tagged ...READ MORE

answered Mar 29 in RPA by Abha
• 8,250 points
38 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.