reading CSV through JAVA

Question

Can anyone tell whats the best way of reading a CSV file. The file I am trying to read is nearly 23 MB so it's a taking a lot of time to read the lines through buffered reader:

BufferedReader CSVFile = new BufferedReader(new FileReader("HostSystems.csv"));
String dataRow = CSVFile.readLine(); 
while (dataRow != null){   
    String[] dataArray = dataRow.split(",");  
    for (String item:dataArray) {       
        System.out.print(item + "\t");   
    }            

    System.out.println(); // Print the data line.   
    dataRow = CSVFile.readLine(); 
}

Is there another efficient way?

thanks for the Link....but can you tell me whts the best for a CSV file with more than 40k entries.....may be more. I just want the code to read the data fast. — Monojeet Nayak, Oct 10 '11 at 13:42
A link to the duplicate answer would be helpful, here, if anyone knows it. — Peter vdL, Jul 02 '13 at 16:30

score 1 · Answer 1 · answered Oct 10 '11 at 13:41

1

You can use opencsv or JSefa (to convert it into xml).

answered Oct 10 '11 at 13:41

Tobias

9,170
3
24
30

score 0 · Accepted Answer · answered Oct 10 '11 at 13:43

0

If you want to do not run out of memory and go fast, you need to go down to java.nio. There are plenty questions in here that might help you.

answered Oct 10 '11 at 13:43

ssedano

8,322
9
60
98

reading CSV through JAVA

2 Answers2