How To Wrap an Excel Workbook

  1. In ModelCenter, create a new Model using the File > New menu item or by clicking the New Model button on the Standard or File toolbar. Either action will open a Windows dialog to save the new workflow.

  2. Drag the Excel plug-in from the favorites folder of the Server Browser to an open, saved workflow.

    Drag the Excel Plug-In from the Server Browser into the Analysis View.

  3. The Initialize PACZ dialog opens. Select the option that best describes the files for your workflow, then select the folder or file as needed. For more information on the Initialize PACZ dialog options, click the Help button in the dialog.

    The Initialize PACZ dialog lets you choose how to set up the files and folders for your workflow.

  4. An Excel file selection dialog displays. Select the file and click the Open button.

  5. The Select Variables dialog opens.

    The Excel Plug-In extracts all variables and ranges from the file and displays them. Select the check box to choose a variable.

  6. Select the variables and ranges from the Excel file to include in the plug-in.

  7. Click the OK button to import the ranges.

  8. The Excel Plug-In displays the selected ranges.

    The Excel Plug-In displays the selected ranges.

  9. Click the Apply button to add the variables to the model.

    The Apply button in the Excel Plu-In toolbar adds the variables to the ModelCenter workflow.

  10. Close the Excel Plug-In.

  11. You can then change these values and run the Excel component just as any other component.

    The ModelCenter workflow with the Excel Plug-In added. The component and its variables can now be used like any other ModelCenter component.