Excel - creating multilple tabs


#1

yl
September 21, 2016 12:56 ANSWERED
Hi,

Is there a way for robot to create excel tabs by a pre-defined range?

For example, if I have a list of 27 items and I want to set up 27 tabs for each item in excel. Is there a way for robot to do?

Thank you so much,

yl


#2

Andrei Pop September 26, 2016 11:38
Hello,

You can use Send HotKey activity with SHIFT + F11 in excel.

Check this sample: https://www.dropbox.com/s/c0iry399kzbp8pm/CreateMultipleSheets_V1_sample.zip?dl=0

Thanks,

Andrei


#3

Mihai Badita September 26, 2016 17:20
Any Write Range/Cell activity with a new “Sheet” parameter will create a new sheet - if it doesn’t exists already.