New Sheet in Excel

Help Studio
, ,
1

Is there a way to create a new sheet in Excel without building a datatable?
Just need to write content in some cells.

Thank you,

2

hi @A_Learner

You can simply use a Write Cell Activity and pass “” in NewSheetName cell A1, Use this for creating a blank sheet.

And you wanna write data in some cells that could also be done using write cell.

3

grafik
grafik643Ă—611 41.7 KB

use the name of the Worksheet that you want to get created newly

1 Like
4

Thank you, @ppr.
Is there a way to do with classic activities?

Thanks so much,

5

grafik

6

Hi @A_Learner,

Using the “Insert Sheet” activity you can create a New Sheet in the Exce you want.

For your clear understanding take a look at the below images I have attached the workflow with output.

Before using the “Insert Sheet” Activity.

image
image1919Ă—1020 60.3 KB

After using the “Insert Sheet” Activity.

image
image1919Ă—1023 63 KB

This is the workflow image.

image
image633Ă—692 23.2 KB

1 Like
7

This did not work. Thank you,

8

avoid ping-pong chats. what was done in detail, what is failling. Suggested approach was working at our end

2 Likes
9

To avoid the missing out of essentials - ensure:

grafik
grafik512Ă—521 49.4 KB

or use:

1 Like
10

Actually, your question is have to create a new sheet in Excel right?

11

@Dinesh_Thavamani
Yes, correct.
@ppr @adiijaiin
All the above suggested methods working when the file is not in One Drive location.

Thank you,

12

was working also under this filepath
grafik

13

@ppr
Thank you for the input.
I do not know the reason.
When the file is under C:~mydesktop it works fine.
In one drive, not throwing any error, runs fine.
Do not find sheet or the cells data written.

14

@A_Learner

If you want to use Excel from One Drive, you can use the Integration Service. First, make a connection to One Drive in UiPath Integration then use the “Add Sheet” Activity. In the activity property select the Workbook and then give the Sheet name you want.

Refer the below images.

image
image792Ă—648 23.6 KB

Below in Studio:

image
image1504Ă—667 53.1 KB

1 Like
15

Is this per user basis or can be setup in Orchestrator?

Thank you,

16

we suggest to split the topic.

Question was about classic activities. Answer was given for this.

When integration Service wants to be explored have a look here:

and other docus.

If further asistance is needed on this, then open a new topic.
It should also be noted that some authorizations must be approved by the Azure Administrator

1 Like
17

If you have access you can setup by your own in the Integration Service.

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.