Hello,
If you want to transfer a column from an excel file to another application, you can create a task as follows:
1.) Open the Excel file and click the cell that you want to start copying from.
2.) Use 'Keystroke' command, CTRL+C to copy the first cell from excel, 'Down Arrow' key to go to next cell in column
3.) Similarly, CTRL+V to paste it into another application.
4) Use keystroke, 'Tab' to move the cursor to next field in another application.
5.) Save the macro.
Set repeat N times and run. It will copy data from Excel into another application. If you had 100 cells to copy, you can copy this way by setting 100 repeat.
Alternatively, try using our advanced automation product, Automation Anywhere 5.5.1 that provides Excel command that works tightly with excel to perform routine functions like Go To cell, get cells, run excel macro etc. You can use ‘Excel-Open Spreadsheet’ command to open the excel spreadsheet in which want to entered the data, ‘Excel-Go to Cell’ command to go to the particular cell in the spreadsheet and use the ‘Excel-Get Cells’ feature to extract the data in spreadsheet.
You can view demo on Excel commands usage from,
http://www.tethyssolutions.com/AAExcelIntegration.html
You can download free trial version of Automation Anywhere 5.5.1 from our website:
Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.
Hope that helps.