Get worksheet range as collection


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?
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 ,...!