Export Images to Excel using ASP

Use the following two steps for exporting images to MS excelsheet.

Step1: Header Declaration
<%
Response.ContentType="Application/vnd.ms-excel"
Response.AddHeader "content-disposition", “attachment; filename=""cpse-"& Month(Date())& Day(Date())& Year(Date()) &".xls"""
%>

Step 2: add this XML snippet where you want your image to appear:

<!–[if gte vml 1]><v:shape

id=”_x0000_s1075″ type=”#_x0000_t75″ style=’position:absolute;margin-left:3pt;

margin-top:7.5pt;width:71.25pt;height:71.25pt;z-index:36′>

<v:imagedata src=”http://www.southdreamz.com/wp-content/themes/palz/images/SouthDreamZ.jpg”

o:title=”NYC_logo-cpse”/>

<x:ClientData ObjectType=”Pict”>

<x:SizeWithCells/>

<x:CF>Bitmap</x:CF>

</x:ClientData>

</v:shape><![endif]–>

Finally, you might need to change the values of width, height or anything you want, but please leave the absolute path where the image resides on your server. I’ve been struggling with this problem for weeks. Hope this helps.