*
The moose likes I/O and Streams and the fly likes looking for a good CSV generator and reader Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "looking for a good CSV generator and reader" Watch "looking for a good CSV generator and reader" New topic
Author

looking for a good CSV generator and reader

Doua Beri
Ranch Hand

Joined: Sep 24, 2009
Posts: 60
Hi. I found on the net several CSV readers and generators but I want to ask you before I start using one in my application, what is the best to use.
I'm looking for answers from the ones who actually used one in thei applications.

Thank you
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19654
    
  18

Accessing File Formats, the Excel section. I myself have used opencsv quite a few times, and it's really easy to work with.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Doua Beri
Ranch Hand

Joined: Sep 24, 2009
Posts: 60
Rob Prime wrote:Accessing File Formats, the Excel section. I myself have used opencsv quite a few times, and it's really easy to work with.


thankx for your answer and for the link. I saw a few examples and it's very easy. Did you tested in reading large csv files( 100MB+) ??
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19654
    
  18

Not really, but it reads each line one at a time like a BufferedReader does. As such, only one line (as a String[]) should be in memory at a time.

Unless you're using the readAll method of course, but that should be obvious.
Arthur Burma
Greenhorn

Joined: Nov 12, 2009
Posts: 16
Hi,
have a look at POI http://poi.apache.org, it's a good performance spreadsheet writer,
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: looking for a good CSV generator and reader
 
Similar Threads
extract data from .csv
Help Needed regarding reading the csv file
Reading multiple CSV files
Write Japanese characters to CSV
Open .csv file within jsp