How to embed grid images into excel,while exporting gird to excel and saving the excel.

Hi

use this code to this, just copy and paste to ur button click.

private void Excel_Export()

{

    Response.Clear();

    Response.Buffer = true;

    Response.AddHeader("content-disposition",

     "attachment;filename=GridViewExport.xls");

    Response.Charset = "";

    Response.ContentType = "application/vnd.ms-excel";

    StringWriter sw = new StringWriter();

    HtmlTextWriter hw = new HtmlTextWriter(sw);

    GridView1.AllowPaging = false;

    GridView1.DataBind();

    for (int i = 0; i < GridView1.Rows.Count; i++)

    {

        GridViewRow row = GridView1.Rows[i];

        //Apply text style to each Row

        row.Attributes.Add("class", "textmode");

    }

    GridView1.RenderControl(hw);

 

    //style to format numbers to string

    string style = @"";

    Response.Write(style);

    Response.Output.Write(sw.ToString());

    Response.Flush();

    Response.End();

}

thank you

Rakesh I'm confused about your question.....

Hi Amit,

Thanks for the reply.

My idea is  to upload a grid with images into excel,so i can achieve this by just rendering the Grid into Streamwriter.By this approch images are getting referenced by their url's, so if user opens the exported excel it is fine and if he saves it also works untill the connectivity between the user machine and the server is avail.

Thanks
Rakesh