Hello,
You can use Excel commands to transfer data between the spreadsheets. Sessions allow you to work with multiple spreadsheets. To define a session name, you need to open a spreadsheet through 'Open Spreadsheet' command of Excel command. To retrieve the data from range of cells use 'Get Multiple Cells' command. The rows and columns of the range are stored in the system variable $Excel Column$.
For Excel Integration online sample tasks and demo please visit,
Excel Automation Software - Automate Excel functions with Automation Anywhere
We have also attached a sample task for your reference. To run this task,
. Please copy attached .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .xls under C:\.
This task would copy different set of data from attached excel file and would transfer into two different spreadsheets.
Hope that helps. If you could tell us more about your case, we would be able to help you more with specific task.
Also, if you can email us your phone number at
support@tethyssolutions.com then one of our expert can call you and guide you in right direction as to how to automate your task.