Defining a Process > Defining Model Elements and Advanced Elements > Arrays > Export Arrays to Spreadsheets

Export Arrays to Spreadsheets

When you export the contents of an array to a Microsoft Excel® worksheet, Process Simulator loads the data into the worksheet from left to right (i.e., within a row), and then from top to bottom (i.e., within a column).

 

Note: Exporting data from an array to a worksheet requires Microsoft Excel 97 or later.

 

Steps to export the contents of an array to an Excel spreadsheet:

  1. Click Arrays from the Model Elements dialog box.
  2. Click the array for which you want to import data.
  3. Click the Export File button.
  4. Either double-click the Export File box, or click the ellipsis icon in the box, to cause the Array Export dialog box to appear.
  5. In the File box of the Array Export dialog box, type the name of the Excel file to which you want the array data to be exported. Alternatively, you may click the Browse button to navigate folders to find and select the Excel file.
  6. In the Sheet box, type the name of the worksheet within the Excel file to which the data should be exported. If the worksheet does not yet exist, it will be created during the export process.
  7. In the Cell Start box, type the cell reference of the starting location for the export data to be loaded into the worksheet. This cell will receive the value stored in the first position (i.e., the first row and first column) of the array. Type the cell reference (e.g., B50), which is the column letter and row number in the worksheet.
  8. In the Cell End box, type the cell reference of the ending location for the export data to be loaded into the worksheet. This cell will receive the value stored in the last position (i.e., the last row and last column) of the array. Type the cell reference (e.g., E100), which is the column letter and row number. Note: the numbers of rows and columns specified for the worksheet should be the same as those numbers for the size of the array. All rows and columns of the array will be exported to the Excel worksheet.
  9. If you want the data export to occur only after the final replication, click the check box for Export after final replication only; otherwise, the export of data will occur after each replication.
  10. Click OK.

 

 

Below are descriptions of the fields in the dialog box.

 

File — the name of the Excel file to which you want to export the array data. You may type either a fully qualified path to your Excel file or a path relative to your Visio file. For example, if your Excel file is in the same directory as your .mod file, simply enter the name of the Excel file into this field.

 

Sheet — the name of the worksheet in the Excel file to which you want to export the array data.

 

Cell Start — the cell in the spreadsheet which is to receive the first piece of data exported from the array.

 

Cell End — the cell in the spreadsheet which is to receive the last piece of data exported from the array. Note: the column letter and/or the row number for this cell must be greater than that provided in the Cell Start box.

 

Note: If you export multiple times to the same spreadsheet, Process Simulator will overwrite the spreadsheet with new data for each run of the simulation. If you wish to prevent your data from being overwritten, you can make a backup of the spreadsheet between each run of the simulation.

 

Note: When the simulation is run, the array data will be saved to the specified worksheet. If you run multiple scenarios and/or replications, array data from each run will be written to a separate, automatically created worksheet in the Excel file.


© 2014 ProModel Corporation • 556 East Technology Avenue • Orem, UT 84097 • Support: 888-776-6633 • www.promodel.com