Moving Around a Spreadsheet

[TennUser]

Hello

My task is to move some values from one spreadsheet and creating new smaller spreadsheets based upon the data in the larger spreadsheet.

I need to move around the larger spreadsheet to determine some values. Am I restricted to using the $ExcelColumn$column# or can I use other variables?

In my spreadsheet there are multiple sets of info that need to be broken out into separate files. So I look for the end of a list, then go back up and pull out info and put into the separate spreadsheet. After I have completed that table, I close the new small file and move on to the next set of information.

So I have multiple issues:
1. keeping two spreadsheets open and pointers correct in each
2. moving up and down in a spreadsheet.

I have used the product in the past to take spreadsheet data and paste it into a web doc, that was great! I am now trying to use it for spreadsheet to spreadsheet which I thought would be just as easy.

Thanks for your help.

[forumsupport]

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.