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 on 1 page. 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 threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat 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
Advertisement
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 !


Mohamadou

Posts: 2
Nickname: msow
Registered: Mar, 2002

Re: Export sql to Excel Posted: Mar 25, 2002 7:29 AM
Reply to this message Reply
thank's I have solve my pb!

Patrick Shih

Posts: 1
Nickname: blackdevil
Registered: Mar, 2002

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

Nono Carballo Escalona

Posts: 1
Nickname: ncarb
Registered: Apr, 2002

Re: Export sql to Excel Posted: Apr 2, 2002 6:40 AM
Reply to this message Reply
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

Blue

Posts: 1
Nickname: blujus
Registered: May, 2002

Re: Export sql to Excel Posted: May 7, 2002 3:01 AM
Reply to this message Reply
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!

Flat View: This topic has 4 replies on 1 page
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