Excel Options

Previous  Top  Next

You can use this Tab to control how Process Runner works with Excel

 

clip0070

 

hmtoggle_plus1Actions

    Always switch to Excel/iBook during Run: This will automatically show Excel file that is being used as soon as you click Run and log in to SAP.

 

    Auto adjust cell width when inserting header information: After Process Runner places extracted data from SAP to Excel, clicking this option will automatically perform auto width adjustment in Excel.

 

    Apply Text data types to Excel columns when writing characters data from SAP to Excel: By default, Excel eliminates preceding zeros if cell's data type is not set to Text. By enabling this option Process Runner will change Excel column format to Text. Excel should keep preceding zeros in tact as received from SAP in that case.

 

    Convert SAP date to Excel system date on BAPI/RFM receive: Generally SAP data is retrieved as string of YYYYMMDD, selecting this option will force Process Runner to convert this textual date returned by SAP to your Excel's date format.

 

    Format SAP time on BAPI/RFM receive: SAP time is usually returned as HHMMSS format. Selecting this option will force Process Runner to convert this time to HH:MM:SS.

 

optionsexcelb2

 

hmtoggle_plus1Defaults

    Sheet Name: Process Runner automatically decides default Sheet name depending on your Excel's language setting. You can change that value here and next time you create a file, this value will be used as a default Sheet name.

 

    In Cell -Delimiter: BAPI can return number of rows in a table. All the rows can be placed in one cell by Process Runner (so you can later on parse them using Text to Column function Excel). This is done via selecting Block Type to "In Cell" in Mapper. When this option is selected, Process Runner will use delimiter specified here as a row separator. Process Runner supports the following delimiters:

 

 clip0077

 

    Excel Language: This displays the default language that is set in Control Panel -> Regional & Language Options -> Regional Options.

 

    Number of Excel rows to show in Mapper: This option lets you decide the number of rows to be shown in Drag n Drop Excel Grid just below Mapper.

 

    When Excel is Locked, auto retry every: If somehow the excel file gets locked by user while editing or for some other reason, this option checks it every n seconds (where n is the number of seconds that user has provided) & releases the lock if it isn't thereby allowing seamless execution of Production Run with no stop at all.

 

clip0071

 

hmtoggle_plus1iBook Setting

    Disable iBook (internal Excel book) functionality: This will disable the internal iBook functionality. You can only use external excel then.

 

    Auto turn off web toolbar in iBook: This option will automatically turn off web toolbar in iBook. Default is ON.

 

optionsexcelb4

 

 

 

 

See Also

Color Options | RFM/BAPI | Transaction Options | Scripting Options | Data Extractor Options | Excel Options | EShare Options | Updates | Other Options