how to read csv file without specific number of column in java and without change the code after every additional column

Question

I tried to write code to read csv file, and I stored the data in an array of object but after every change in the number of columns, I should read another column and change the code. because I want to use the same class for different csv files with different number of columns without need to change the code for every file.

    public class Read_CSV {
        public static Object[][]readCSVdata(String csvFilePath){
     //String csvFilePath = null;
     ArrayList<Object[]>dataList = new ArrayList <Object[]>();
        String line = "";
          String cvsSplitBy = ",";
        try (BufferedReader br = new BufferedReader(new FileReader(csvFilePath))) {

        int iteration = 0;
        
        while ((line = br.readLine()) != null) {
            if(iteration == 0) {
                iteration++;  
                continue;
            }
            String[] arri = line.split(cvsSplitBy);
            Object[]arri1= {arri[0] , arri[1],arri[2] };
              //here after every additional column I should add another cell
            dataList.add(arri1);
        }      
        br.close();
        return dataList.toArray(new Object[dataList.size()][]);

    } catch (IOException e) {
        e.printStackTrace();
        return null;

    }

}

}

Nowhere Man · Accepted Answer · 2020-07-08 20:01:16Z

1

You could use the array of strings after splitting each line:

while ((line = br.readLine()) != null) {
    if(iteration == 0) {
        iteration++;  
        continue;
    }
    String[] arri = line.split(cvsSplitBy);
    
    dataList.add(arri);
}

Then dataList will contain arrays of strings.

Or you have some other requirements?

answered Jul 8, 2020 at 20:01

Nowhere Man

19.7k9 gold badges21 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

how to read csv file without specific number of column in java and without change the code after every additional column

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