Process studio - get entire excel object in any data object

Hello Guys,

I’m reading excel file using Microsoft Excel Input and performing some business validations in
Modified Java Script
for (i = 0; i <= getInputRowMeta().size(); i++){
var value = row[i];

Through this code we can iterate over single row of excel at a time.

Is it possible to iterate over all rows at a time in Modified Java Script, if yes how ?

Can we get all rows of excel in any data collection/any function ?

Please reply.


Hello Sudesh,

The modified java script step does not include the above mentioned functionality.

I believe the best possible approach for this will be using Apache POI. You can use Apache POI in User defined Java class step by writing Java code for your usecase.