Create an XLS file from raw data

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

Question by:OggieOne
    LVL 39

    Expert Comment

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

    Author Comment

    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.

    LVL 39

    Accepted Solution

    I'm not a java expert, but there should be plenty of libraries available.

    Author Comment

    Thanks for the push in the right direction. After a bit of review the is my choice and I am already creating a spreadsheet from java. In opens in OpenOffice so I am pleased as punch!


    Author Closing Comment

    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!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A Change in PHP Behavior with Session Write Short Circuit ( (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
    If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
    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 choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now