GroovyCSV
GroovyCSV is a library for Groovy which aims to make csv data easier (and more idiomatically Groovy) to work with. The library was inspired by @goeh's ExcelBuilder that lets you iterate over rows in the excel file using eachLine
and access values using the column names.
Features
- Value-access by header name or position
- Iteration using the ordinary collection methods (
findAll
,collect
and so on) - Support for guessing separator and/or quote character
- Support for reading csv without headers
- Support for skipping initial lines of the csv
Example
The parse method returns an iterator over the rows in the csv. This means we can use any of the default groovy ways to iterate, in this example we see the for each loop in use.
@Grab('com.xlson.groovycsv:groovycsv:1.3')
import static com.xlson.groovycsv.CsvParser.parseCsv
def csv = '''Name,Lastname
Mark,Andersson
Pete,Hansen'''
def data = parseCsv(csv)
for(line in data) {
println "$line.Name $line.Lastname"
}
The parse method takes a String or a Reader as argument.
Output:
Mark Andersson
Pete Hansen
Getting GroovyCSV
GroovyCSV is available through Maven Central.
Maven & Ivy configuration
Latest stable
- GroupId: com.xlson.groovycsv
- ArtifactId: groovycsv
- Version: 1.3
Latest snapshot
- Version: 1.3-SNAPSHOT
- Repository: https://oss.sonatype.org/content/groups/public/
Downloads
GroovyCSV 1.3
Dependencies
- Groovy 1.8.x or later
- OpenCSV 4.x
Many thanks to everyone who's contributed to the project and everyone in the OpenCSV team for doing all the heavy lifting.
Building
GroovyCSV uses Gradle for building as is packaged with the gradle wrapper which will download and install gradle for you behind the scenes the first time you run it.
Build instruction
- Fetch the latest code:
git clone git://github.com/xlson/groovycsv.git
- (Optional) Run the tests using the gradle wrapper
./gradlew test
- Go to the project directory and run:
./gradlew jar
You will find the built jar in ./build/libs
. If you need any dependencies you can download them using ./gradlew downloadDeps
, they end up in the lib
folder.