# Process studio - get entire excel object in any data object

**URL:** <https://community.automationedge.com/t/process-studio-get-entire-excel-object-in-any-data-object/888>\
**Category:** Get Help & Discuss\
**Created:** [December 15, 2018, 10:54am UTC](https://community.automationedge.com/t/process-studio-get-entire-excel-object-in-any-data-object/888 "2018-12-15T10:54:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sudesh.mohane](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@sudesh.mohane](https://community.automationedge.com/u/sudesh.mohane)\
**Post date:** [December 15, 2018, 10:54am UTC](https://community.automationedge.com/t/process-studio-get-entire-excel-object-in-any-data-object/888/1 "2018-12-15T10:54:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AnonymousBot](https://avatars.discourse-cdn.com/v4/letter/a/958977/32.png) [@AnonymousBot](https://community.automationedge.com/u/AnonymousBot)\
**Post date:** [July 20, 2021, 1:01pm UTC](https://community.automationedge.com/t/process-studio-get-entire-excel-object-in-any-data-object/888/2 "2021-07-20T13:01:18Z")

</div>

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.