How to Read CSV File Using Java Selenium With Example?

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);
      }
   }
}

Check Also: Handle Element Using Selenium WebDriver