Process studio - get entire excel object in any data object


#1

Hello Guys,

I’m reading excel file using Microsoft Excel Input and performing some business validations in
Modified Java Script
e.g.
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.

Thanks,
Sudesh