Read csv file to arraylist object

Question

The problem lies in the CVSParser class. I need to read the .CSV file then pass it off to the ArrayList<Club>

Example.csv
Team,W,D,L,GF,GA
Arsenal,24,7,7,68,41
Aston Villa,10,8,20,39,61
...

Club class

public Club(String team, int w, int l, int d, int GF, int GA) {
        ...
    }

CSVParser class

public static ArrayList<Club> CSVParser(String file) throws IOException{

        ArrayList<Club> Lists = new ArrayList<>();
        try{
        Scanner scanner = new Scanner(new FileReader(file));
        scanner.nextLine();

        while(scanner.hasNextLine()){
            String line = scanner.nextLine();
            //System.out.println(line);

            /*will get ArrayIndexOutOfBoundsException: 0 error */
            String[] splits = line.split(",");
            Lists.add(new Club(splits[0], Integer.parseInt(splits[1]),Integer.parseInt(splits[2]), 
                    Integer.parseInt(splits[3]), Integer.parseInt(splits[4]), Integer.parseInt(splits[5])));

        }scanner.close();
        }catch(FileNotFoundException e){
            e.printStackTrace();
        }

        System.out.println(Lists);
        return Lists;

Your post begins with "the problem is at the..." but your post neglects to even begin to describe a problem. — mah
– mah, Commented Mar 11, 2015 at 14:47
Why are you passing a FileReader to your Scanner instead of a File? — mstbaum
– mstbaum, Commented Mar 11, 2015 at 15:23

tbc · Accepted Answer · 2015-03-11 14:57:40Z

1

First, this is the right way to use scanner

Scanner s = new Scanner(input).useDelimiter(",");
int w = s.nextInt());

otherwise, just use a BufferedReader

Next, you have one or more empty lines in csvfile, you should check for the line length before splitting, something like:

if (line.trim().length() > 0) {
    String[] splits = line.split(",");
}

answered Mar 11, 2015 at 14:57

tbc

1231 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read csv file to arraylist object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related