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:
|
The output of the program is given below:
