Excel Controls

This topic describes how to use the options in the Excel Controls section on the Edit tab.

To configure the options in the Excel Controls section

  1. In Process Runner, open the Process file that you want to update.
  2. Go to the Edit tab and select Excel Controls and perform the following steps:
  3. To run only the filtered rows and not process the rows hidden by the current filter, select Run only filtered row.
  4. To display Excel during the run, select Show Excel on Run.
  5. The current version of Process Runner does not support iBook functionality, and the Export iBook option is enabled only when a Process file with internal iBook is used. You can use the Export iBook option to remove iBook, compress the Process file, and export iBook data to Excel file manually. Only if you are using a Process file that was designed using 5.20.11 or a lower version, the iBook data is exported as an Excel file to the Process Runner working folder that is configured under Tools > Application> Options > Path, and then is mapped to the Process file automatically.
    ExportiBook
  6. To enable Process Runner how to interpret the values stored in the Excel, select one of the following from the Read Excel cell values dropdown list:
    • As Displayed:Process Runner reads the value that is as displayed in the Excel. The value might be rounded off.
    • As Internally Stored:Process Runner reads the original value that is stored internally. The original value is read through.
  7. To write the header information to Excel at the end of each run, which is useful when the you must retrieve fields from SAP to Excel, select Field, Description, or Both to indicate the header type and select the execution type as follows:
    • Input field Only: Indicates that the header type must be applied for Excel to SAP run.
    • Output Field Only: Indicates that the header type must be applied for SAP to Excel run.
    • Both: Indicates that the header type must be applied for both Excel to SAP run and SAP to Excel runs.
  8. To edit additional settings, click the pop-up icon. For information about how to edit the options in the Basic tab, select Basic Excel Controls. For information about how to edit the options in the Expert tab, select Expert Excel Controls.