Problem description & analysis

Below is the content of Excel file users.xlsx:

We are trying to find record where name is user_1. Below is the desired result:

Solution

Write the following script p1.dfx in esProc:

Explanation:

Set value of script parameter username as user_1.

A1  Import data of the Excel file and return it as a table sequence.

A2  Get record where name value is equal to value of parameter username from A1’s table sequence.

Read How to Call an SPL Script in Java to learn about the method of integrating the SPL script into Java.

Q & A Collection

https://stackoverflow.com/questions/62571193/how-can-i-get-a-specific-cell-value-from-an-excel-file