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