This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Groovy and the fly likes Groovy SQL query to Excel output Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Languages » Groovy
Bookmark "Groovy SQL query to Excel output" Watch "Groovy SQL query to Excel output" New topic

Groovy SQL query to Excel output

Mark Ediger

Joined: Jun 16, 2012
Posts: 1
I have a hopefully simple question from a beginner...
My sql.eachRow query returns two numbers from two rows (in the "ID" column), as it should. But using the JExcel API, I cannot get the code to insert the two numbers on top of each other in my excel sheet.

And I get the following error: groovy.lang.GroovyRuntimeException: Could not find matching constructor for: jxl.write.Label(java.lang.Integer, java.lang.Integer, java.lang.Long)

I know my JExcel API is working, so is my sql call...I am able to add individual cells, one at a time, into my XL sheet. But it crashes when my .eachRow closure needs to iterate over more than one result. Am I messing up with the class of what I'm returning? I'm using Groovy 1.8.6. Thanks.

Varghese Paul

Joined: Aug 02, 2004
Posts: 14
JExcel Label API has a method signature of Label(int , int , java.lang.String)
wood burning stoves
subject: Groovy SQL query to Excel output
Similar Threads
How To compare two excel sheets using java
importing data from database to excel sheet through JExcel Api
jxl package doenot exists
JExcel API and Servlet - File upload
JExcel API clarifications