<div>
You would normally use a .csv file as an intermediate step: Export to csv from database, and import the csv file into excel.
</div>


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

<div>
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.<br />
<br />
Thoughts?<br />
Thanks,<br />
D.
</div>


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.

<div>
Thanks for the push in the right direction. After a bit of review the <a href="http://poi.apache.org/" rel="ugc">http://poi.apache.org/</a>&nbsp;is my choice and I am already creating a spreadsheet from java. In opens in OpenOffice so I am pleased as punch!<br />
<br />
Thanks!<br />
D.
</div>


Thanks for the push in the right direction. After a bit of review the http://poi.apache.org/ [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.

<div>
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!
</div>


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!

<div>
<div class="content wysiwyg-content">
Hi, I was wondering how to convert raw data (from a database [derby database]) to a spreadsheet (xls). <br />
<br />
Thanks.
</div>
</div>


Hi, I was wondering how to convert raw data (from a database [derby database]) to a spreadsheet (xls). 

Thanks.

Create an XLS file from raw data

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.