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.
- Value-access by header name or position
- Iteration using the ordinary collection methods (
findAll,collectand so on) - Support for guessing separator and/or quote character
- Support for reading csv without headers
- Support for skipping initial lines of the csv
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
GroovyCSV is available through Maven Central.
- GroupId: com.xlson.groovycsv
- ArtifactId: groovycsv
- Version: 1.3
- Version: 1.3-SNAPSHOT
- Repository: https://oss.sonatype.org/content/groups/public/
GroovyCSV 1.3
- 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.
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.