The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Answers Forum
Export sql to Excel

4 replies. Most recent reply: May 7, 2002 3:01 AM by Blue

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a flat view of this topic  Flat View
Previous Topic   Next Topic
Threaded View: This topic has 4 replies on 1 page
Mohamadou

Posts: 2
Nickname: msow
Registered: Mar, 2002

Export sql to Excel Posted: Mar 20, 2002 2:18 AM
Reply to this message Reply
Hi,
I want to export the result of a sql request.
I can do it without commercial product (only api java)
but I want to do it without giving column name of my future table in the Excel file at first.
I want to put directly from my java program the names of column of my future table in the excel file.

Question : Do you know how to give the name of the columns from java ?
thanks !


Re: Export sql to Excel Posted: Mar 25, 2002 7:29 AM
Reply to this message Reply
Posted by: Mohamadou    Posts: 2 / Nickname: msow / Registered: Mar, 2002
thank's I have solve my pb!


Re: Export sql to Excel Posted: Mar 25, 2002 8:37 AM
Reply to this message Reply
Posted by: Patrick Shih    Posts: 1 / Nickname: blackdevil / Registered: Mar, 2002
Could you tell me how do you export the result of a sql request using only the Java API? Thank you.


Re: Export sql to Excel Posted: Apr 2, 2002 6:40 AM
Reply to this message Reply
Posted by: Nono Carballo Escalona    Posts: 1 / Nickname: ncarb / Registered: Apr, 2002
I really don't have the answer, but I need to return an sql result as an excel document and you say you know how to do it. Can you teach me how?

Thanks in advance

Nono


Re: Export sql to Excel Posted: May 7, 2002 3:01 AM
Reply to this message Reply
Posted by: Blue    Posts: 1 / Nickname: blujus / Registered: May, 2002
In order to perform I/O to/from excel format files, you can use the POI (open source)project from apache.
This provides high level access to excel workbook and sheet objects. The project is POI but the actual package used for Excel file format manipulation is hssf.
I have used this project in another Open Source project and it works very well!


Topic: steps to deploying Application in Weblogic 5.1 Previous Topic   Next Topic Topic: calendar program
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use