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
5,294 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
• 27,930 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 28, 2019 in Selenium by Anvi
• 14,110 points
1,151 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,110 points
1,202 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,340 points
1,228 views
0 votes
1 answer
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,520 points
3,770 views
0 votes
2 answers

Problem while using InternetExplorerDriver in Selenium WebDriver

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

answered Aug 31 in Selenium by Sri
• 2,970 points
4,752 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,890 points
2,732 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 2 in Selenium by Sri
• 2,970 points
3,095 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 2, 2019 in Selenium by Abha
• 27,930 points
2,575 views