Read CSV File Using Selenium Webdriver
How to Read CSV File Using Java Selenium With Example?
import java.io.File; import java.io.FileNotFoundException; import java.util.Scanner; public class csvread { //getting the last data count(rowcount) public static int getRowCount(String csvPath) throws FileNotFoundException { int rc=0; try (Scanner scanner = new Scanner(new File(csvPath))) { scanner.useDelimiter("\n"); while(scanner.hasNext()) { rc++; scanner.next(); } } return rc; } //getting the value from csv cell public static String getValue(String csvPath,int rc,int cc) throws FileNotFoundException { String v=""; try (Scanner scanner = new Scanner(new File(csvPath))) { scanner.useDelimiter("\n"); for(int i=1;i<=rc;i++) { if(scanner.hasNext()) v=scanner.next(); } } return v.split(",")[cc-1]; } //main method public static void main(String[] args) throws FileNotFoundException { int v = csvread.getRowCount("E:/new.csv"); for(int i=1;i<=v;i++) { String t = csvread.getValue("E:/new.csv", i, 1); System.out.println(t); } } }