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

I love open-source technologies and am very passionate about software development. I like to share my knowledge with others, especially on technology that's why I have given all the examples as simple as possible to understand for beginners. All the code posted on my blog is developed, compiled, and tested in my development environment. If you find any mistakes or bugs, Please drop an email to softwaretestingo.com@gmail.com, or You can join me on Linkedin.

Leave a Comment