Jim,
I have done what you describe. While I do not know of a
Java class that allows you to construct an Excel format file, a CSV (or comma separated values) file will suffice.
I use two
JSP "views" (in the MVC sense) for my data... one is a normal HTML table, and one is a CSV file. The trick is to get the web browser client to recognize it as something that Exel can open.
Here is the JSP code for that:
The ReportAttributesBean contains what is essentially metadata. this includes things like the reference that allows retrieval of the ResultSet from the session. The custom tags render the data. I think that the important part for your purposes is in the first few lines of the page.
PCS
Philip Shanks, SCJP - Castro Valley, CA
My boss never outsources or has lay-offs, and He's always hiring. I work for Jesus! Prepare your resume!