• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Record Export?

 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Xperts,

how to export a records from the table to XL file.

edward
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XL file? Can you explain what that is?
 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
.xls file (excel).
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ah that makes more sense. However, this is not an ORM question. I think the JDBC forum might be more appropriate.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You've got a number options with Excel. You could export your data using whatever tools your particular database provides (such as DTS with SQL Server or exp with Oracle) in a format you can import into Excel, CSV being the most obvious one. Or you could write some VBA control in Excel to connect to the database and query the data itself. Or if you wanted to do this in Java you'd need to write a program that uses JDBC to get the data and possibly Jakarta POI to create the Excel spreadsheet.
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Personally, I'd use jasper reports for formatting the output.
http://jasperreports.sourceforge.net/features/index.html

Besides Excel, it'll do .rtf, .pdf, .txt, .html and .xml
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic