Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Groovy SQL query to Excel output

 
Mark Ediger
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JExcel Label API has a method signature of Label(int , int , java.lang.String)
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic