Dataset to CSV File using Excel action

added on May 15, 2015 by Valentineo McGowan
Applies To: AutoMate BPA Server 10, AutoMate 10

How do I create a CSV file from a dataset without using Interactivity actions inside MS Excel, ie, 'File Save As.'?

Here's how to create a CSV file in one step using a dataset with our 'Excel - Set cells' activity.

Download This Task (54.2kb) Dataset to CSV.Excel.aml
Would you like to upload a Sample Task or Workflow to the User Resource Center? Click here!



More Sample Tasks and Workflows

JSON Loop Structure, Encode, Decode Sample (task) 4/30/17Leonard Amabile

This sample task will demonstrate the following: - Decode JSON string into structure/array - Loop structure/array and display values - Encode structure/array into JSON string (raw or formatted)

Round up to Whole Number Using VB Round() Function 4/24/17Leonard Amabile

The VB round() function, by default rounds to the nearest whole number based on the following: 10.00 through 10.50 = 10 10.51 through 10.99 = 11 There are scenarios where you want to round up all decimal values to the nearest whole number. Based on the above criteria, adding 0.5 to any numeric value with a decimal will cause the round() function to round up. For example: 10.00 + .50 = 10 round(10.5) 10.10 + .50 = 11 round(10.6) 10.90 + .50 = 11 round(11.4) The attached tasks will demonstrate the round() function usage to round up numeric values.

Restart a Service (Automate and Intermapper) 3/27/17Network Automation

This sample task will allow you to use Automate and Intermapper to restart a service.

DDE Sample (task) 2/24/17Leonard Amabile

The attached task demonstrates DDE Execute, DDE Poke and DDE Request. The task assumes that Excel is running with a worksheet named Sheet1. DDE Execute: Maximizes the Excel spreadsheet. DDE Poke: Will write the number 7 in row 1 column 1 of Sheet1. DDE Request: Will grab the value from row 1 column 1 of Sheet1 and populate variable varTest.

Workflow Loop Sample (workflow) 8/22/16Leonard Amabile

This sample demonstrates how a workflow loops through a shared dataset using the evaluation object and NO loops within the tasks.

Inline Padding Sample (task) 8/22/16Leonard Amabile

This sample demonstrates how to pad a string inline with leading or trailing spaces.

Split filename into two variables 5/15/15Valentineo McGowan

A task has a name of 'abc_123.txt' I would like the folder name to be the prefix of the filename prior to the "_" delimiter 'C:\abc'. File 123.txt will then be placed inside C:\abc\123.txt

Count Rows in TXT/CSV using Regular Expression 5/15/15Valentineo McGowan

I have a *.txt or *.csv containing column headers and X rows of data. Using RegEx the task simply counts the number of rows based on carriage returns. Great for csv files that have X amount of records and you simply need a total count of rows minus the headers.

Dataset to CSV File using Excel action 5/15/15Valentineo McGowan

How do I create a CSV file from a dataset without using Interactivity actions inside MS Excel, ie, 'File Save As.'? Here's how to create a CSV file in one step using a dataset with our 'Excel - Set cells' activity.

Dataset to CSV using ODS action 5/15/15Valentineo McGowan

How do I create a CSV file from a dataset without Microsoft Excel being present on my machine? Here's how to create a CSV file in one step using a dataset with our new 'ODS (OpenDocument Spreadsheet) - Set cells' activity.

 

Comments (7)

  1. 10/20/15 by Anonymous
    "There was an error during the import" in Automate 9.0.5.4
  2. 10/20/15 by Valentineo McGowan
    Hello Anonymous, The ‘Dataset to CSV File using Excel action' AML sample file is for v10+ and higher. Please feel free to download a 30day FREE trial of AutoMate v10.3 from our Downloads page.
  3. 2/29/16 by Andres Ortiz
    I'm trying to open this sample task on Automate v10.3.0.13 but I get an error "The file "C:\XXXX\Dataset to CSV.Excel.aml" does not appear to be a valid AutoMate Task file
  4. 2/29/16 by Ricardo Castaneda
    Hi Andres, We are not able to reproduce the issue you are describing. I would suggest that you open a ticket with us at AutoMate.Support@helpsystems.com so that we can get to the bottom of this issue.
  5. 3/1/16 by Andres Ortiz
    Thanks I have opened a ticket
  6. 5/11/16 by James Cronin
    I'm trying to open this sample task in Automate 10.4.2.1. I receive "unknown error in converting file." when attempting to open file.
  7. 5/12/16 by Justin Aucoin
    Hi James, The steps below are an example of the Dataset to CSV File using Excel actions. The steps will create a dataset of files on your desktop and then create and write the contents of the dataset to a CSV file on the desktop.
    <AMVARIABLE NAME="varList" /> <AMFILESYSTEM ACTIVITY="get" MODE="both" SOURCE="%GetDesktopDirectory()%" RESULTVARIABLE="varList" RESULTDATASET="dsList" FILEPROPERTY="fullname" /> <AMEXCEL ACTIVITY="set_cell" CONNECTBY="create_workbook" WORKBOOK="%GetDesktopDirectory()%\dataset.csv" OVERWRITE="yes" SETTERTYPE="dataset" DATASET="dsList" CELLROW="1" CELLCOLUMN="1" />
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.1 changelog
11.0.1 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