Hi

 I have implementes above both type writen code but i am geting the error like....

" System.Web.HttpException: Control 'GridView'Test' of type 'GridView' must be placed inside a form tag with runat=server. "

Thanks

Sanjay Verma

To avoid the IE6-specific problem of the .xls file not being found in the "temporary internet files\Content.IE5" folder, in addition to the snippets presented above, you have to do the following:

Response.ClearHeaders();
Response.CacheControl = "Public";

So what you have to do is Response.ClearHeaders() before setting your own attributes.

snippet:

                    Response.ClearHeaders();
                    Response.CacheControl = "Public";
                    Response.Charset = "";
                    Response.AddHeader("Content-Disposition", "attachment; filename=file.xls");
                    Response.ContentType = "application/vnd.ms-excel";
                    Response.BinaryWrite(yourExcelStream.ToString());

Thanx for all of you as i got the solution by marius.poenari.

thanx a lot

Hi to StrongTypes ,

                              I have some image in the gridview when upload this to excel but there is no images found, may i know why no images uploaded into Excel file?  Please give a code lot of days i tried this task.......

using System;

using System.IO;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Text;

/// Summary description for Class3

/// </summary>

public class Class3

//*********Export to Excel**************

//first let's clean up the response.object

//set the response mime type for excel

//create a string writer

//create an htmltextwriter which uses the stringwriter

//instantiate a datagrid

//set the datagrid datasource to the dataset passed in

//bind the datagrid

//tell the datagrid to render itself to our htmltextwriter

//all that's left is to output the html

Hai Anubha,

                Thanks for your response. I tried this code it's working, i export the records into the excel and open it there is all images with data. if i paste this excel file to another system and open the excel file then there is no image found, could you please tell me why no images will display in another machine?

Hi Ryan

i want to export my gridview to pdf document, i used iTextSharp library, everything is fine but the problem is that

pdf document did not take the GridView Syle like headerStyle, RowStyle, color, font...etc

and here is my code

Dim sw As New StringWriter()

Dim page As New Page

Dim GridStyle As String

'Set up the response

HttpContext.Current.Response.Charset = ""

HttpContext.Current.Response.ContentType = "application/pdf"

'Create pdf document

'Create pdf writer, output directly to OutputStream

'Create tempfile to hold the HTML:

'Dim tempFile As String = Path.GetTempFileName()

'Using tempwriter As New StreamWriter(tempFile, False)

' tempwriter.Write(GridStyle)

'End Using

'Parse the HTML into the document

'Cleanup

'Delete the tempfile:

'File.Delete(tempFile)

writer = Nothing

PdfDocument = Nothing

End Sub

can you help me or give me another solution

thanx

 Hi Ryan,

I am new to asp.net ,i have one requirement ,that is uploading the HTML page into the database and  displyng  through gridview.

 if you have any code plz give me,

how to do this ,plz help me.

Thanks in advance

Hello Ryan,

Thanks for the nice post, I have samll query, my webpage where the GridView has master page  and because of this I am getting an error syaing that place inside a webform with runat=server error.

Could you please hlep to resolve this? and also could you please send the code of clearcontrols function code in VB 

I had this same problem with IE being unable to find the file and it took me a couple of hours to figure out that I had disabled DDE in excel to prevent all my excel spreadsheets from opening up in the same window.  In Office 2007 click on Excel Options then under Advanced-->General there is an "Ignore other applications that use Dynamic Data Exchange (DDE)"  I had that option checked.  As soon as I unchecked it, the excel opened right up on the next web call.... Now to get to the formatting.