File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Record Export? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Record Export?" Watch "Record Export?" New topic
Author

Record Export?

Edward Durai
Ranch Hand

Joined: Oct 09, 2004
Posts: 223
Hi Xperts,

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

edward


Thank You<br />Edward
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

XL file? Can you explain what that is?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Edward Durai
Ranch Hand

Joined: Oct 09, 2004
Posts: 223
.xls file (excel).
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Ah that makes more sense. However, this is not an ORM question. I think the JDBC forum might be more appropriate.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

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

Joined: Dec 15, 2005
Posts: 333
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Record Export?