You are here: Home » All Software Solutions » How to transfer data from excel to any other application?

Categories

See all categories

How to transfer data from excel to any other application?

Automation Anywhere is an intelligent automation software for IT & business processes.
This month's most popular software guide you should know - How to move photos from my iPhone to my computer

1.
 Create a new task
  • Let's say you want to transfer the data present in Excel column as shown in Screenshot 1
  • We will create a task that transfers one cell of Excel and then we will set the Repeat property of Automation Anywhere to transfer multiple cells to the destination application.
  • In the main Automation Anywhere window click on Tools->Task Editor
  • From the list of commands, double-click the 'Insert Keystrokes
  • Select the title of your Excel file from the dropdown list and specify the keystrokes to copy one cell data as show in Screenshot 2
  • Click on Save button in the Insert Keystrokes command.
  • Now your task looks as shown in Screenshot 3
  • Now enter another Keystroke command in the same Excel window similar to above command, but in this command enter the keystrokes to move to the next cell for e.g. Down Arrow as shown in Screenshot 4
  • Save the command.
  • Now the task should look as shown in Screenshot 5
  • Now let's paste the data (copied from Excel) into your target application. Here for illustrative purpose we will use Microsoft Word but it can be any application.
  • As shown above, now enter the keystrokes actions in the Word window to paste the copied data as shown in Screenshot 6
  • In above Keystroke action, we also move to the next column in the Microsoft Word table using the Right Arrow after copying the data.
  • Now the complete task will look as shown in Screenshot 7
  • Save the task and give it appropriate name.
2.
 Transfer multiple rows from Excel
  • After saving the task from editor, come back to main Automation Anywhere window.
  • The folder where you just saved the task will be displayed in the listview.
  • Select your task from the list and click on Repeat section under Properties tab and specify the number of repeats. This is equal to the number of rows you want to transfer from Excel window to Word window in this example. Screenshot 8
3.
 Pre-requisites before running the task.
  • Since in this task we are not using any mouse clicks to select the first cell, it is essential you keep the first cell selected in your Excel file before running the task as shown in Screenshot 1
  • Keep your destination application also open
 
When you run this task, it copies one cell of excel using keystrokes and pastes it to the target application (Microsoft Word in this case) using keystrokes. When the task is repeated, it transfers as many cells from Excel to Word.

Screenshot 1:

Automation Anywhere

Screenshot 2:

Automation Anywhere

Screenshot 3:

Automation Anywhere

Screenshot 4:

Automation Anywhere

Screenshot 5:

Automation Anywhere

Screenshot 6:

Automation Anywhere

Screenshot 7:

Automation Anywhere

Screenshot 8:

Automation Anywhere

Related Software: Automation Anywhere -    

Recommended Essentialware
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.

Recommended Mac Software
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.

by on 21/08/2007Web Developer
Tags:Automation Anywhere, import data from excel to acess, automate complex task, intelligent automation software for it, intelligent software, automation software for business

Tips & Guides Related to How to transfer data from excel to any other application?

Rss

Software Guides

on Web Developer

See all

Top Reviews

on Web Developer

  • Adobe Flash Player - SWF Player
    Adobe Flash Player - SWF Player

    "Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."

    by Owen Wilson on Sep 7, 2009

  • Flash Gallery Builder
    Flash Gallery Builder

    "Flash Gallery Builder Reviews & Free Download"

    by Heren Watson on Jan 10, 2008

  • CoffeeCup HTML Editor
    CoffeeCup HTML Editor

    "CoffeeCup HTML Editor Reviews"

    by Dr. File Finder on Jan 29, 2008

  • SiteSpinner
    SiteSpinner

    "SiteSpinner Review & Download"

    by Dr. File Finder on Feb 23, 2008

See all