Convert a field to an Excel mappable field in GUI Scripting

This topic describes how to map a scroll position or something that is not commonly mapped to Excel by Process Runner automatically. You can convert these fields to an Excel-mappable field.

To convert fields to Excel-mappable fields

  1. Open the GUI Scripting Process file and select Advanced View on the Mapper tab. The Advanced View is displayed.
  2. Select a line that you want to convert to an Excel-mappable field. Double-click the GUI Script column for that line. The GUI Script Editor window is displayed.
  3. Change the numeric value listed that you want to be mapped from Excel to %IVALUE%. For example, if 4 should come from Excel, delete 4, replace it with %iVALUE%, and click OK. The changes are saved.
  4. On the Mapper tab, change the mapping type to Excel to SAP and type Excel column name in Map Value column.

When you run this GUI Scripting Process file, it takes the value from Excel column B and the updates are reflected in your result.