GroovyCSV by xlson

A simple CSV parsing library for groovy

GroovyCSV is a library to make csv processing just a little bit Groovier. The library uses opencsv behind the scenes and merely tries to add a thin layer of “Groovy-ness” to the mix.

Latest version

Dependencies

opencsv 2.1

Documentation and more information

Javadoc
GroovyCSV 0.2 Released

Features

Value-access by header name or position
Iteration using the ordinary collection methods (findAll, collect and so on)
Full support for OpenCSV’s configurability
Support for guessing separator and/or quote character
Support for reading csv without headers

Arguments to parse or parseCsv

separator: configures the separator character to use (default: ,)
quoteChar: configures the quote character to use (default: “)
escapeChar: configures the escape character for the separator and quoteChar (default:\)
autoDetect: sets up autodetect that will honor other configurations you’ve done (default: false)
columnNames: set custom column names instead of using the first line
readFirstLine: reads the first line as csv instead of using it as headers

Usage example

Basic usage

@Grab('com.xlson.groovycsv:groovycsv:1.0')
import com.xlson.groovycsv.CsvParser
def csv = '''Name-Lastname
Mark-'Anderson-Nielsen'
Pete-Hansen'''

def data = new CsvParser().parse(csv, separator: '-', quoteChar: "'")
for(line in data) {
    println "$line.Name $line.Lastname"
}

Output:

Mark Andersson
Pete Hansen

Parsing a headerless file

@Grab('com.xlson.groovycsv:groovycsv:1.0')
import com.xlson.groovycsv.CsvParser
def csv = '''Apple,2
Pear,5'''

def data = new CsvParser().parse(csv, readFirstLine:true,
                                 columnNames:['fruit', 'qty'])
for(line in data) {
    println "$line.fruit ${line[1]}"
}

Output:

Apple 2
Pear 5

License

Apache V2

Authors

Leonard Axelsson (leo@xlson.com)

Downloads

GroovyCSV 1.0

GroovyCSV 0.2

You can also clone the project with Git by running: $ git clone git://github.com/xlson/groovycsv