Generating an Excel Spreadsheet

Class 2

Intermediate Java 30-IT-397

Using a content type of applicatin/vnd.ms-excel, we can use the source code below to generate an excel spreadsheet.

<%@page contentType="text/html"%>
<html>
<head><title>JSP Page</title></head>
<body>

<%-- <jsp:useBean id="beanInstanceName" scope="session" class="package.class" /> --%>
<%-- <jsp:getProperty name="beanInstanceName" property="propertyName" /> --%>

<% response.setContentType("application/vnd.ms-excel"); %>

<table border = 1>
    <tr><th></th><th>First Quarter</th><th>Second Quarter</th><th>Third Quarter</TH>
    <tr><td>Sales</td><td>10000</td><td>15000</td><td>50000</td></tr>
    <tr><td>COGS</td><td>5000</td><td>10000</td><td>30000</td></tr>
    <tr><td>Operating Expense</td><td>4000</td><td>4000</td><td>16000</td></tr>
    <tr><td>Net Income</td><td>1000</td><td>1000</td><td>4000</td></tr>
</table>

</body>
</html>

IE opens this within itself, Netscape will prompt you to open Excel.

isThreadSafe Attribute

Created by: Brandan Jones December 20, 2001