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

1.3

Dependencies

opencsv 4.x

Documentation and more information

Javadoc

Features

Value-access by header name or position
Accessing values as a map
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
Support for skipping lines at the beginning as well as empty lines

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
skipLines: skips the specified number of lines at the beginning (default: 0)

Usage example

Basic usage

@Grab('com.xlson.groovycsv:groovycsv:1.3')
import static com.xlson.groovycsv.CsvParser.parseCsv
def csv = '''ID,Product
3,Shoe
1,Table'''

def data = parseCsv(csv)
for(line in data) {
    println "ID=$line.ID, Product=$line.Product"
}

Output:

ID=3, Product=Shoe
ID=1, Product=Table

Custom separator and quote character

@Grab('com.xlson.groovycsv:groovycsv:1.3')
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-Nielsen
Pete Hansen

Parsing a headerless file

@Grab('com.xlson.groovycsv:groovycsv:1.3')
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

The Apache License, Version 2.0

Author

Leonard Gram (leo@xlson.com)

Contributors

Downloads

GroovyCSV 1.3

GroovyCSV 1.2

GroovyCSV 1.1

GroovyCSV 1.0

GroovyCSV 0.2

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