Inserting Image In Excel Sheet Using JSP

In this example, we create excel sheet and display image on that.

Inserting Image In Excel Sheet Using JSP

Inserting Image In Excel Sheet Using JSP

     

In this example, we create excel sheet and display image on that. We can request that the browser open the results in Excel and suggest the file to use when the user saves the file by setting the following two response headers: Content-Type and Content-Disposition

Here, we use page directive and set the contentType attribute by the value "application/vnd.ms-excel". The purpose of setting this contentType is to display the output in excel format.

<%@ page contentType="application/vnd.ms-excel" %> 

We set the header as: response.setHeader("Content-Disposition", "attachment; filename=\"mult-table.xls\"").The response object provides a convenience method for setting the Content-Type header. Both can be set with the setHeader method.

In this example we insert the image and the output will display in excel format with image.You can use third party APIs to create the excel sheet, which you can learn in our next example. The third party APIs are provided by Jakarta Apache Foundation group.

 The code of the program is given below:


<% response.setHeader("Content-Disposition""attachment; 
filename=\"mult-table.xls\""
); %>
<%page contentType="application/vnd.ms-excel" %>


<table><tr><td><img src="/excel/images.jpg" ></td></tr></table>

The output of the program is given below:

Download this example.