Basic Excel Controls

This topic describes the how to configure the basic Excel controls.

To configure the options in Basic tab

  1. In Process Runner, open the Process file that you want to update.
  2. Go to the Edit tab and click the pop-up icon. The Basic tab > Excel Controls window is displayed.
  3. In Read/Write Option section, select the following options:
    • To enable Process Runner to read the value that is as displayed in the Excel file, select Execute only filtered rows.
    • To define the filter parameters, select Filter Excel Rows where Column and enter the values for the additional fields.
    • 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.
    • To set the limit for Process Runner to check or search, after which Process Runner automatically abort the filter process, enter a value in Blank row threshold for stopping.
    • 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.
  4. In the Other Option section, select the following options:
    • To define when to save the Excel file, select an option from the Save Excel dropdown list, enter the value for the additional field, and optionally select Also apply when file is used in Excel Add-In.
    • To display Excel during the run, select Show Excel on Run.
    • (Only for Data Extractor) To use the character set, select from the Character Set dropdown list.
  5. Select OK. The changes are saved.