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.