Selenium - How to copy entire excel column without using iterator



  • I'm new to selenium and I'm having following query.

    Query: Am working on a project where I need to copy 4000 values from an excel in a single go and I need to paste that in the list box of application. (The list box in the application can accept maximum of 4000 values)

    The excel consists of 4000 values in its first 4000 rows(In a single column). I just need to copy all the values instead of using iterators.

    Can anyone help me in achieving this?



  • @Mohan - Can you add why you particularly looking for without iterator?

    Very simple solution without iterator

    public Object[][] signUpPage1FieldValidationData() throws Exception{
               Object[][] retObjArr=getTestData("", "");
               return(retObjArr);
    

    Let me know, if you have some dificulty. All the best!



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2