How to convert a field to an Excel mappable field in GUI Scripting

Process Runner automatically detects fields which can be mapped to Excel. However, you may want to map a scroll position or something else that is not commonly mapped to Excel.  You can easily convert these fields to an Excel mappable field.

To convert  to Excel mappable fields please follow these instructions.

1.Go to Mapper and make sure you are in “Advance view”. (Select “Advance view” from mapper tool bar from the bottom of the “Mapper” tab.)

2.Select a line that you want to convert to an Excel mappable field. Then double click on the GUI Scripting column for that line to bring up an editor.

3.Change the numeric value listed that you want to be mapped from Excel to %IVALUE%. For example, if value of 4 should come from Excel, delete 4 and replace it with %iVALUE%. Click “OK” to save your changes and go back to Mapper tab.

4.Now change the mapping type to “Excel to SAP” and type Excel column name in “Map Value” column next to it.

When you run this process, it will now take the value from Excel column B and changes will be reflected in your result.

Next:

How to convert CSV file to Excel