Hello,
Yes, you can use 'Get Multiple cells' Excel command to get the data from multiple cells in a spreadsheet. Each time you use the ‘Open-Spreadsheet’ command, it starts a session named ‘Default’ and that will continue to run unless you ended the session using the ‘Close Spreadsheet’ command or close the spreadsheet manually. All the commands between ‘Open-Spreadsheet’ and Close Spreadsheet’ are dependent on the session which is started using the ‘Open Spreadsheet’ command. If you wish to work with many separate excel spreadsheets, specify a different session name while opening the each spreadsheet.
For Excel Integration online sample tasks and demo please visit,
Excel Automation Software - Automate Excel functions with Automation Anywhere
For your reference we have attached sample task, Sample4Clay.atmn. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy Book1.xls under c:\.
This task would copy multiple cells from one spreadsheet to another.
Hope that helps.