Groovy load .csv files

Question

How to read and import .csv file in groovy on grails. I have .csv file with data and
need to import in to db using user interface .

Answer 1

There are as always different possibilities to work with CSV files in Groovy.

As Groovy is fully interoperable with Java, you can use one of the existing CSV libararies, e.g. OpenCSV.

Depending on the complexity of the CSV file you are using, you can also use the standard file/string handling possibilities of Groovy:

def sql = Sql.newInstance("jdbc:mysql://localhost:3306/mydb",   "user", "pswd", "com.mysql.jdbc.Driver") def people = sql.dataSet("PERSON") new File("users.csv").splitEachLine(",") {fields ->   people.add(     first_name: fields[0],     last_name: fields[1],     email: fields[2]   ) } 

EDIT: Kelly Robinson just wrote a nice blog post about the different possibilities that are available to work with CSV files in Groovy.

EDIT #2: As Leonard Axelsson recently released version 1.0 of his GroovyCVS library, I thought I should definitely add this to the list of options.

Answer 2

Using xlson's GroovyCSV:

@Grab('com.xlson.groovycsv:groovycsv:1.3') import static com.xlson.groovycsv.CsvParser.parseCsv  for(line in parseCsv(new FileReader('countries.csv'), separator: ';')) {     println "Country=$line.COUNTRY, Capital=$line.CAPITAL" } 

The field names are taken from the header of the CSV file.
If the CSV file has no header, you can specify the field names programmatically.