Exporting JSP data into excel with image

Question

In our project we are having the requirement to export the JSP page into excel. We cannot use Apache POI or any other open source APIs. I came across the below mentioned simple way of doing

<%
response.setHeader("Content-Disposition", "attachment;filename=\"mult-table.xls\""); %> <%@ page contentType="application/vnd.ms-excel" %> <table><tr><td> using image src to load images </td></tr></table>

The excel is generated but the image is not shown in the excel. In our JSP pages we are having many images which should also get exported into excel along with other data.hanks

Please let me know how to do it.

Thanks Ravi

Pablo Garcia · Accepted Answer · 2012-10-01 13:35:38Z

1

I use the complete URL in HTML image code, because when you download the excel, it's a text xls file, with format HTML, and the images embeddable and the absolute path, intead it can solve the image source. like this:

<%
// Java CODE
...
String url=request.getRequestURL().toString(); // URL base page
String imageUrl=url.substring(0,url.indexOf(request.getRequestURI()))+"/images/logo.gif"; // image absolute url
...

%>
...
<!-- HTML CODE -->
...
<img src="<%=imageUrl%>" width="198" height="36" /></th>
...

edited Oct 1, 2012 at 13:35

answered Aug 22, 2012 at 15:13

Pablo Garcia

13812 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vladimir Kravets · Accepted Answer · 2011-05-14 09:29:02Z

0

As far as I know you can not insert an image in xls file, when this html xls

answered May 14, 2011 at 9:29

Vladimir Kravets

3306 silver badges22 bronze badges

Collectives™ on Stack Overflow

Exporting JSP data into excel with image

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related