Sample Tasks and automation workflow examples, uploaded by Network Automation employees and customers, highlight and demonstrate features of AutoMate and AutoMate BPA Server.

Task or Workflow of the Month

Loop Dataset using Excel Actions

Jul 2007by LaRee Stach

This sample task will use the appropriate 'Excel' actions in AutoMate to grab data from the first few rows and columns of an Excel Document (rows 1 to 5 and columns A to C) and populate a dataset with the grabbed data. It will then loop through the rows of the dataset and show the data within each column of the current row in a message box. With each successive loop the current row of the dataset is incremented.

Note: The task will prompt you to select an Excel document from which to grab the data from. Make sure that the selected document includes at least some data in the first 5 rows/ columns.

Download This Task Sample_Loop_Dataset_Using_Excel_Actions.aml
Would you like to upload a Sample Task or Workflow to the User Resource Center? Click here!

Subscribe to Recent Sample Tasks and Workflows via RSS
Subscribe to Recent Sample Tasks and Workflows via RSS
Recent Sample Tasks and Workflows

task added on comments rating
Move to and click on image. 2/26/11 0
Remove Extension From File Name 2/17/11 0
SharePoint: Retrieve List Data 2/16/11 0
VMware: Create and Manage your VM Snapshots 1/27/11 4
SharePoint: Download File(s) From Shared Documents 12/10/10 0
Send Email SMTP For AOL, GMAIL, HOTMAIL, And YAHOO 11/19/10 0
Trigger on Low Disk Space / Drive Space on Remote 10/22/10 0
Delete Last Line of a File (vbscript) 8/10/10 0
Export Crystal Report PDF (vbscript) 3/17/10 3
Create File of a Specific Size 3/16/10 1
Delete Last Line of a File 2/10/10 0
Connect Terminal: Determine if Line is Busy 1/11/10 2
Rename File to its Parent Folder Name 11/10/09 0
Even / Odd Number Determination 9/29/09 1
Base16 Encode and Decode (vbscript) 8/8/09 0
Process Stat Report 7/16/09 0
List Environment Variables 6/24/09 0
Create, Get, Append & Delete Environment Variable 6/24/09 0
FTP - Loop Through Currently Uploading Files 6/9/09 0
FTP - Delete Files Older Than 30 Days 5/29/09 0

Search the URC

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

9.0.5 changelog
9.0.5 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