Question

2
Replies
530
Views
kanam Member since 2012 58 posts
ServiceNow
Posted: May 30, 2017
Last activity: June 2, 2017
Closed
Solved

Handling multiple sheets in a single Excel book

Hi. Can I have an idea on what is the best approach to create a Robot to handle multiple sheets in a single Excel book? Assume that each sheets can be edited.

If we use multiple Excel connectors to point each sheets, we need to close and re-open the Excel each time you switch the sheets.

One approach that comes to my mind is using Windows application to handle Excel application with SendKeys to switch sheets. But, of course, it doesn't sound like a good approach.

Any suggestions?

Thanks,
Moritaka Kanai

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn