This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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: 20078
    
  30

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 - OCEJPAD 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: 20078
    
  30

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,
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: looking for a good CSV generator and reader
 
It's not a secret anymore!