Excel - creating multilple tabs

Help
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: Dropbox - File Deleted

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.