Looping With Excel

Applies To: AutoMate 6, AutoMate 5
 

More Tutorials

Automate Complete Introduction 6/21/172261 views
The Automate Enterprise Ops Console Overview 5/17/171785 views
Getting Started With AutoMate 10 2/19/1510241 views
Getting Started With BPA Server 10 1/30/155067 views
How to Extract Information from Exchange 11/29/125582 views
How To AutoMate VMware 10/29/128346 views
How To AutoMate Amazon Web Services (AWS) 9/25/127489 views
How To AutoMate Email and SMS Notification 8/28/1211515 views
How To AutoMate PowerShell Scripts 7/31/1220674 views
How To AutoMate Web Services 7/5/127968 views
How To AutoMate Web Extraction 7/5/127755 views
Getting Started: BPA Server 9 2/24/128792 views
Getting Started With AutoMate 9 1/6/1221542 views
Overview of the BPA Server Management Console (SMC) 2/24/116573 views
Getting Started With BPA Server 8 2/16/117054 views
Getting Started With AutoMate 8 12/21/1017432 views
Interacting with a Drop-Down Menu 1/24/0820183 views
AutoMate BPA Server Agent Deployment 12/18/0716005 views
User Resource Center 10/16/0711145 views
Account Page 10/16/079504 views
AutoMate BPA Server 7 10/16/0726211 views
Looping and Sending Emails From a List 5/22/0713973 views
Looping With Excel 3/23/0722406 views
Terminal Emulation 2/20/0717011 views
Download File from Web 1/16/0719267 views
Web Account Login 11/20/0622422 views
SQL Query a CSV File 9/1/0630492 views
FTP Uploads by Files Last Modified Date 7/18/0617633 views
FTP Download by Date 6/1/0619257 views
The File Watcher and FTP Actions 3/14/0628472 views
AutoMate 6 Intro (Outdated, See "Getting Started With AutoMate 8") 3/13/0661695 views
 

Comments (6)

  1. 3/27/07 by Anonymous
    This tutorial has opened up some new ideas for me and shown me some smarter ways of doing things I currently do poorly. Thanks AutoMate! From an AussieMate! Sydney Australia
  2. 10/2/07 by Beth Blankenship
    It would be nice if the sample task was readily available to download.
  3. 10/3/07 by Marjo Martinez
    Beth, Your suggestion is an excellent idea, therefore, we will work on creating sample tasks that will coinside with each tutorial and add them to the URC as well as include them to future downloads of AutoMate. Thanks for the input. Marjo AutoMate Support Technician
  4. 12/31/07 by Ubaldo Rauso
    It very clear and simple Very good job
  5. 7/1/15 by Anonymous
    This is based on the version 6 of AutoMate however the version 10 is quite different. I was also not getting past number 11 when running the program
  6. 7/7/15 by Valentineo McGowan
    The below AML code was built in version 10.3.0.13. NOTE For the *.xls file used in step 6; you will have to build your own to match what was used in the example when the video first began. The remaining code is the same and has been tested.
    <AMVARIABLE NAME="theCompany" /> <AMVARIABLE NAME="theFirstName" /> <AMVARIABLE NAME="theLastName" /> <AMVARIABLE NAME="theRow" VALUE="2" /> <AMVARIABLE NAME="theColumn" VALUE="1" /> <AMEXCEL SESSION="ExcelSession1" WORKBOOK="C:\Users\vmcgowan\Desktop\excel.sample.xlsx" /> <AMEXCEL ACTIVITY="get_cell" SESSION="ExcelSession1" ACTION="cellbyposition" RESULTVARIABLE="theCompany" CELLROW="%theRow%" CELLCOLUMN="%theColumn%" /> <AMVARIABLE ACTIVITY="increment" RESULTVARIABLE="theColumn" /> <AMEXCEL ACTIVITY="get_cell" SESSION="ExcelSession1" ACTION="cellbyposition" RESULTVARIABLE="theFirstName" CELLROW="%theRow%" CELLCOLUMN="%theColumn%" /> <AMLOOP ACTIVITY="expression" CONDITION="until" EXPRESSION="%theCompany = &quot;&quot;%"> <AMVARIABLE ACTIVITY="increment" RESULTVARIABLE="theColumn" /> <AMEXCEL ACTIVITY="get_cell" SESSION="ExcelSession1" ACTION="cellbyposition" RESULTVARIABLE="theLastName" CELLROW="%theRow%" CELLCOLUMN="%theColumn%" /> <AMSHOWDIALOG>Company: %theCompany% First Name: %theFirstName% Last Name: %theLastName%</AMSHOWDIALOG> <AMVARIABLE ACTIVITY="increment" RESULTVARIABLE="theRow" /> <AMVARIABLE ACTIVITY="set" VARIABLENAME="theColumn" VALUE="1" /> <AMEXCEL ACTIVITY="get_cell" SESSION="ExcelSession1" ACTION="cellbyposition" RESULTVARIABLE="theCompany" CELLROW="%theRow%" CELLCOLUMN="%theColumn%" /> <AMVARIABLE ACTIVITY="increment" RESULTVARIABLE="theColumn" /> </AMLOOP> <AMEXCEL ACTIVITY="close_workbook" SESSION="ExcelSession1" SAVETYPE="do_not_save" />
Please sign in to your account or your comment will be forever stored under "anonymous".
Include Code Snippet

Search the URC

Subscribe to Version History via RSS
Subscribe to Version History via RSS
Version Watcher

11.0.2 changelog
11.0.2 changelog
other versions downloads

Contribute

Subscribe to Latest Resources via RSS
Subscribe to Latest Resources via RSS
Latest Resources

show filter options

Subscribe to Forum Posts via RSS
Subscribe to Forum Posts via RSS
Forum Posts