Sunday, 10 January 2016

How to read all data from CSV file



import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.List;

import au.com.bytecode.opencsv.CSVReader;

public class ReadCSVData
{

public static void main(String[] args)
{
    String filename = "D:\\selenium_NEW_PRACTICE\\test_data\\test_csv_data.csv";
    ReadCSVData parseCSVFile = new ReadCSVData();

    System.out.println("Starting to parse CSV file using opencsv");
    parseCSVFile.parseUsingOpenCSV(filename);
}

private void parseUsingOpenCSV(String filename)
{
CSVReader reader;
try
{
    reader = new CSVReader(new FileReader(filename));
    String[] row;
    List<?> content = reader.readAll();

    for (Object object : content)
    {
        row = (String[]) object;
        for (int i = 0; i < row.length; i++)
        {
            // display CSV values
        System.out.println("Cell column index: " + i);
        System.out.println("Cell Value: " + row[i]);
        System.out.println("-------------");
        }
    }
}
catch (FileNotFoundException e)
{
    System.err.println(e.getMessage());
}
catch (IOException e)
{
    System.err.println(e.getMessage());
}
}
}

No comments:

Post a Comment