ASP - Excel - Images

[blyxx86]

I was having issues with exporting an ASP table that included images. I have since found a solution for this error, and hope that what I have found becomes useful for some others on this site.

At the top of the page:

<%
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=MyReport" & ".xls"
%>
 

Then the part that had the image in the main HTML/ASP script used to look like this:

<img src="/images/custlogo/<%=rs("LogoName")%>" title="<%=rs("Customer")%>"/>
 

Now I replaced the relative path with the full path:

<img src="http://www.mysite.com/images/custlogo/<%=rs("LogoName")%>" title="<%=rs("Customer")%>"/>
 

After making this change it fixed the problem of showing up a 'blank' placeholder in the excel spreadsheet.

I hope this helps fix any issues that others may have encountered. :)