Select Range of Cells - Excel

[Clay]

Hello,
Does Automation Anywhere have an option to select a certain range of cells?

I know this can be done using an Excel Macro, but can it be done with the software alone?

I would like to be able to select a certain range of cells, copy the cells to a new worksheet and save the new worksheet.

Thank you,

Clay

[forumsupport]

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.