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:
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