How can I read a CSV file in Selenium using Webdriver

0 votes
How can I read a CSV file in Selenium using Webdriver?
Jul 16, 2019 in Selenium by Trisha
13,054 views

1 answer to this question.

0 votes

Hey Trisha, you can read a CSV file in Selenium opencsv. OpenCSV is a third-party API used to easily read data from a CSV file. Following example shows how to use it:

import java.io.FileReader;
import java.util.Iterator;
import java.util.List;

import au.com.bytecode.opencsv.CSVReader;

public class ReadCSVFile {

 public static void main(String[] args) throws Exception {
    
 CSVReader reader = new CSVReader(new FileReader("C:\\Users\\Abha_Rathour\\Desktop\\demo.csv"));

  List<String[]> list=reader.readAll();
  System.out.println("Total rows which we have is "+list.size());
            
 // create Iterator reference
  Iterator<String[]>iterator= list.iterator();
    
 // Iterate all values 
 while(iterator.hasNext()){
     
 String[] str=iterator.next();
   
 System.out.print(" Values are ");

 for(int i=0;i<str.length;i++)
{

   System.out.print(" "+str[i]);

}
   System.out.println("   ");
     
    
}

}

}
answered Jul 17, 2019 by Abha
• 28,140 points

Related Questions In Selenium

0 votes
1 answer

How can I refresh a browser window in different ways using Selenium Webdriver?

Hello Piyush, you can refresh a browser ...READ MORE

answered May 29, 2019 in Selenium by Anvi
• 14,150 points
3,227 views
0 votes
1 answer

How can I clear the text in a text box using Selenium WebDriver?

Hello Akriti, you can clear the text ...READ MORE

answered May 29, 2019 in Selenium by Anvi
• 14,150 points
6,761 views
0 votes
1 answer

How can I download the *.jar file from http:// seleniumhq.org using selenium WebDriver?

For Selenium Standalone Server use this: profile.setPreference("browser.helperApps.neverAsk.saveToDisk", "application/java-archive"); and ...READ MORE

answered Apr 9, 2018 in Selenium by Martin
• 4,320 points
3,508 views
0 votes
1 answer

How can I travel forward and back in a browser using selenium?

You can use the Navigate interface to ...READ MORE

answered Dec 31, 2018 in Selenium by Nabarupa
12,227 views
0 votes
2 answers

Finding WebDriver element with Class Name in java

The better way to handle this element ...READ MORE

answered Apr 10, 2018 in Selenium by nsv999
• 5,500 points
13,607 views
0 votes
2 answers

Problem while using InternetExplorerDriver in Selenium WebDriver

enable trusted connection  in internet explorer by ...READ MORE

answered Aug 31, 2020 in Selenium by Sri
• 3,190 points
9,102 views
0 votes
1 answer

Geo-location microphone camera pop up

To Allow or Block the notification, access using Selenium and you have to ...READ MORE

answered May 11, 2018 in Selenium by Samarpit
• 5,910 points
7,197 views
0 votes
2 answers

How to use such xpath to find web elements

xpath are two types. 1) Absolute XPath:    /html/b ...READ MORE

answered Sep 3, 2020 in Selenium by Sri
• 3,190 points
7,851 views
0 votes
1 answer
0 votes
1 answer

How can I send some data to a Prompt Alert box using Selenium Webdriver?

Hey Abhishek, you can use sendKeys() method ...READ MORE

answered Jul 3, 2019 in Selenium by Abha
• 28,140 points
9,490 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP