Excel Options

Previous  Home  Next

This set of options will be helpful in defining the behaviour of excel and iBook when using Process Runner.

 

Click on 'Options' button in standard toolbar and click on 'Excel' tab in Options window.

 

Option_StdToolbar

Options_Excel1

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.

Automatically save Drag and Drop mapping changes to external Excel file: This will automatically save the drag and drop mapping changes to external file if external Excel is used instead of iBook.

Open external Excel in safe mode: By checking this check box allows to open the external Excel file used to open in safe mode.

Show hidden worksheets: Enabling this option shows hidden worksheets.

Always open new Excel instance for external excel: When enabled this option opens new excel instance of external excel file each time.

Force read hidden column values: When enabled, Process Runner will read hidden column values if the mapped column is hid in excel file.

 

 

 

Options_Excel_Action1

 

 

 

 

Excel2

 

 

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.

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.

Column to show in Mapper: This option lets you decide the column  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.

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

Always open new excel instance for iBook: This option when enabled opens new excel instance of iBook each time.

 

Options_Excel_iBookSettings

 

Next:

Enterprise Settings