My Oracle Support Banner

E-NV: How To Specify “Range of Cells” And “Range Values” Within The Excel Formulas Function (VLOOKUP, HLOOKUP etc.) When Using OPENXML (Doc ID 2733702.1)

Last updated on DECEMBER 04, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Goal

In the Excel Application, it uses excel binaries to execute the Excel Formula Functions such as VLOOKUP, HLOOKUP etc., and so in the Excel Formula, it requires a “Range of Cells” specified within a parameter for this to happen.

When using Excel Binaries, the “Range of Cells” can be specified in the following 3 manners

1. Range with Row/Column values (e.g.: A1:B20).

2. Entire row range: without specifying column name. (e.g.: 10:20)

3. Entire column range: without specifying row value. (e.g.: C:E)

However, when you use OPENXML mode in PIA, since the execution uses Excel Libraries instead of Excel Binaries, the execution of these values occurs only after the nPlosion process is completed and not before like when using Excel Binaries. Therefore, if the “Range of Cells” and “Range Values” remain the same, it would not bring back the desired results.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.