Get worksheet range as collection

[Hema__rao]

Hi,

I am reading range of excel sheet into a collection. There are 1650 rows but it is extracting only 17 rows into output collection. I have used number of rows and given input as end cell. Could you please help me what might be the issue?

 

[Sachin_Kharmale]

Hi @Hema__rao ,

Try with Get Worksheet as Collection Fast action,

 

[Hema__rao]

Hi Sachin,
I have also tried that action but it is not extracting all the rows. Do you think there is a problem with excel file?

 

[Sachin_Kharmale]

Hi @Hema,
Yes may be because all actions MS Excel VBO work as expected. Probably your excel file having problem.
try with another worksheet/Excel file.

i hope it will help you ,...!