Sample Tasks and automation workflow examples, uploaded by Network Automation employees and customers, highlight and demonstrate features of AutoMate and AutoMate BPA Server.
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.
Subscribe to Recent Sample Tasks and Workflows via RSS Recent Sample Tasks and Workflows
|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|