[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Create an XLS file from raw data

Posted on 2008-11-14
5
Medium Priority
?
1,494 Views
Last Modified: 2012-05-05
Hi, I was wondering how to convert raw data (from a database [derby database]) to a spreadsheet (xls).

Thanks.
0
Comment
Question by:OggieOne
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:Roger Baklund
ID: 22962619
You would normally use a .csv file as an intermediate step: Export to csv from database, and import the csv file into excel.
0
 

Author Comment

by:OggieOne
ID: 22962693
Is there a way to do the 2 step process programmatically? What I want to do is have an xls file created on the user's machine. My program is a java web app running on the localhost. So I don't want my users to have to open up Excel and have to import anything.

Thoughts?
Thanks,
D.
0
 
LVL 39

Accepted Solution

by:
Roger Baklund earned 375 total points
ID: 22962975
I'm not a java expert, but there should be plenty of libraries available.  

http://poi.apache.org/
http://j-integra.intrinsyc.com/support/com/doc/excel_example.html
http://www.activexls.com/
0
 

Author Comment

by:OggieOne
ID: 22963602
Thanks for the push in the right direction. After a bit of review the http://poi.apache.org/ is my choice and I am already creating a spreadsheet from java. In opens in OpenOffice so I am pleased as punch!

Thanks!
D.
0
 

Author Closing Comment

by:OggieOne
ID: 31516897
Not sure that the questions for completing the solution are relevent for this question. The person who answered pushed me in the right direction and that is all that was needed. Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Suggested Courses
Course of the Month18 days, 6 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question