Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting recordset to xls

Status
Not open for further replies.
drimades

drimades

IS-IT--Management
Nov 8, 2004
221
0
0
MK
I'm using Netbeans to create db application. I need to export the results of a query (recordset) into an excel file.
How can I do that?
 
Sort by date Sort by votes
You can just export is as a plain file with csv format that Excel will recognise an open or use and API like Java POI to create a regular Excel file.

Cheers,
Dian
 
Upvote 0 Downvote
SOLVED using Apache POI. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Makumbi256
  • Locked
  • Question
how can i convert this code to javascript
Replies
1
Views
95
xwb
xwb
hendrikbez
  • Locked
  • Question
Add currency to as value
Replies
1
Views
86
Rick C. Hodgin
Rick C. Hodgin
Rienes
  • Locked
  • Question
How to learn Java
Replies
3
Views
101
Rienes
Rienes
R-MacDonald
  • Locked
  • Question
How to order Software on Java?
Replies
3
Views
136
JacquelineReeser
JacquelineReeser
varocho
  • Locked
  • Question
Need to have gradle build file reference database-connection info within 'application.yml' file
Replies
1
Views
96
Diancecht
Diancecht

Part and Inventory Search

Sponsor

Back
Top