Exporting Image and GridView to Word/Excel is Impossible!

[manmit.walia]

Hello Fellow Developers,

I have a small problem that you might be able to help me with. The
method that I am trying to create is the ability to export a GridView
and a image to word or excel. I know that some people have already post
about this topic but could not find a reliable answer. To my knowledge,
I have the code down right. The GridView writes to the word document
perfectly just not the image. All I get is a red 'x' image notifying me
that word cannot find the path of the image.

Below is my code. Any help would be grateful.

Legend:

---------------------------------

partsGrid = GridView

pieImage = asp.net Image, which is dynamically created using GDI+

---------------------------------
intro = "<div align=center><f ont style=FONT-SIZE:'18pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>" + rptlbltype.Text +
"</font></div><br>";
intro = intro + "<div align=center><f ont style=FONT-SIZE:'11pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>Date From" + " " + sDate.Text + " " +
"to" + " " + eDate.Text + "</font></div><br>";

string temp = rptlbltype.Text + "-" + " " + sDate.Text + "to" +
eDate.Text;

Response.Clear( );

Response.AddHea der("content-disposition", "attachment;fil ename=" +
rptlbltype.Text + ".doc");

Response.Charse t = "";

Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);

Response.Conten tType = "applicatio n/vnd.word";

System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();

System.Web.UI.H tmlTextWriter htmlWrite = new
HtmlTextWriter( stringWrite);

StringWriter stringWrite2 = new StringWriter();

HtmlTextWriter htmlWrite2 = new HtmlTextWriter( stringWrite2);

partsGrid.Rende rControl(htmlWr ite);

pieImage.Render Control(htmlWri te2);

string totalText = intro + stringWrite.ToS tring() + "<br/>" +
stringWrite2.To String() ;

Response.Write( totalText);

Response.End();

[Steve C. Orr [MVP, MCSD]]

You need to make sure you're specifying the full path to the image, not a
relative path.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
<ma**********@g mail.comwrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .

Hello Fellow Developers,

I have a small problem that you might be able to help me with. The
method that I am trying to create is the ability to export a GridView
and a image to word or excel. I know that some people have already post
about this topic but could not find a reliable answer. To my knowledge,
I have the code down right. The GridView writes to the word document
perfectly just not the image. All I get is a red 'x' image notifying me
that word cannot find the path of the image.

Below is my code. Any help would be grateful.

Legend:

---------------------------------

partsGrid = GridView

pieImage = asp.net Image, which is dynamically created using GDI+

---------------------------------
intro = "<div align=center><f ont style=FONT-SIZE:'18pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>" + rptlbltype.Text +
"</font></div><br>";
intro = intro + "<div align=center><f ont style=FONT-SIZE:'11pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>Date From" + " " + sDate.Text + " " +
"to" + " " + eDate.Text + "</font></div><br>";

string temp = rptlbltype.Text + "-" + " " + sDate.Text + "to" +
eDate.Text;

Response.Clear( );

Response.AddHea der("content-disposition", "attachment;fil ename=" +
rptlbltype.Text + ".doc");

Response.Charse t = "";

Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);

Response.Conten tType = "applicatio n/vnd.word";

System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();

System.Web.UI.H tmlTextWriter htmlWrite = new
HtmlTextWriter( stringWrite);

StringWriter stringWrite2 = new StringWriter();

HtmlTextWriter htmlWrite2 = new HtmlTextWriter( stringWrite2);

partsGrid.Rende rControl(htmlWr ite);

pieImage.Render Control(htmlWri te2);

string totalText = intro + stringWrite.ToS tring() + "<br/>" +
stringWrite2.To String() ;

Response.Write( totalText);

Response.End();

[Pankaj.3107]

Hi Everyone,
I do also have the same problem....
I have also given the full path of image,but still it is not showing
the image in Word document...
The GridView writes to the word document
but not the image. All it show is a red 'x' image . but on clicking
the image on word document it display the image....
any help would be gratefull..
thanks
Pankaj

Steve C. Orr [MVP, MCSD] wrote:

You need to make sure you're specifying the full path to the image, not a
relative path.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
<ma**********@g mail.comwrote in message
news:11******** **************@ p79g2000cwp.goo glegroups.com.. .

Hello Fellow Developers,

I have a small problem that you might be able to help me with. The
method that I am trying to create is the ability to export a GridView
and a image to word or excel. I know that some people have already post
about this topic but could not find a reliable answer. To my knowledge,
I have the code down right. The GridView writes to the word document
perfectly just not the image. All I get is a red 'x' image notifying me
that word cannot find the path of the image.

Below is my code. Any help would be grateful.

Legend:

---------------------------------

partsGrid = GridView

pieImage = asp.net Image, which is dynamically created using GDI+

---------------------------------
intro = "<div align=center><f ont style=FONT-SIZE:'18pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>" + rptlbltype.Text +
"</font></div><br>";
intro = intro + "<div align=center><f ont style=FONT-SIZE:'11pt'; COLOR:
'#8B0000'; FONT-FAMILY: 'Verdana'>Date From" + " " + sDate.Text + " " +
"to" + " " + eDate.Text + "</font></div><br>";

string temp = rptlbltype.Text + "-" + " " + sDate.Text + "to" +
eDate.Text;

Response.Clear( );

Response.AddHea der("content-disposition", "attachment;fil ename=" +
rptlbltype.Text + ".doc");

Response.Charse t = "";

Response.Cache. SetCacheability (HttpCacheabili ty.NoCache);

Response.Conten tType = "applicatio n/vnd.word";

System.IO.Strin gWriter stringWrite = new System.IO.Strin gWriter();

System.Web.UI.H tmlTextWriter htmlWrite = new
HtmlTextWriter( stringWrite);

StringWriter stringWrite2 = new StringWriter();

HtmlTextWriter htmlWrite2 = new HtmlTextWriter( stringWrite2);

partsGrid.Rende rControl(htmlWr ite);

pieImage.Render Control(htmlWri te2);

string totalText = intro + stringWrite.ToS tring() + "<br/>" +
stringWrite2.To String() ;

Response.Write( totalText);

Response.End();