I have one gridview and one table in an aspx page, that has filled with user details now I need to export gridview and table data to word and excel document based on selection.How can i do it. I...

Question

0.00/5 (No votes)

See more:

I have one gridview and one table in an aspx page, that has filled with user details now I need to export gridview and table data to word and excel document based on selection.How can i do it please help me any one.I try to use this code but this code does not work with images , just with text.

try
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + ViewState["fileName"].ToString() + ".doc");
Response.Charset = "";
Response.Buffer = true;
EnableViewState = false;

Response.ContentType = "application/vnd.word";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Panel1.RenderControl(htmlWrite);
Response.ContentEncoding = System.Text.Encoding.UTF8;
//Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />");
Response.Write(stringWrite.ToString());
Response.End();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

but this code does not work with images , just with text.

Posted 15-Jul-13 18:43pm

Md. Shihab Uddin

Updated 15-Jul-13 22:55pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar A khan · Answer 1 · 2013-07-15T19:08:00

Add a template field to your grid put a checkbox in that template field for selection purpose.

C#

HtmlTable tbl=new HtmlTable();
foreach(GridViewRow row in GridView1.Rows)
{
  if(row.RowType==RowType.DataRow)
  {
     CheckBox chk =row.FindControl("chk") as CheckBox;
     if(chk.Checked)
      {
         // find the labels or text in the the grid here create HtmlRows and Cells here
         HtmlTableRow r=new HtmlTableRow();
         HtmlTableCell c1=new HtmlTableCell();
         HtmlTableCell c2=new HtmlTableCell();
         c1.InnerHtml=((Label)row.FindControl("Label1")).Text;
         c2.InnerHtml=((Label)row.FindControl("Label2")).Text;
         r.Cells.Add(c1);
         r.Cells.Add(c2);
         tbl.Rows.Add(r);
      }

  }

}

HtmlTextWriter htw=new HtmlTextWriter();
stringWriter sw=new stringWriter(htw);
tbl.RenderControl(sw);
// set header  and write to response