Hi Friends,

How are you all? Hope you all are doing well.

Now I am doing a project in ASP.NET, with C#. My web page is running on Windows 2000 Professional Server. There I have written a module to download data from DataGrid to an Excel file. The module is as follows.

private void create_excel()
{
    //export to excel
    Response.Clear();
    Response.Buffer= true;
    Response.ContentType = "application/vnd.ms-excel";
    Response.Charset = "";
    this.EnableViewState = false;
    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

    DataGridExcel.RenderControl(oHtmlTextWriter);
    Response.Write(oStringWriter.ToString());
    Response.End();
    DataGridExcel.Visible = false;
}

This module is working fine where at the client end OFFICE 2003 is loaded. But this code is not working properly where at the client end OFFICE 2002 is loaded.

The problem is as follows:

1) No save window is appearing before download the excel file.
2) The excel file is opening as a webpage which is not desired.

Hope you all understood the problem. Please help me to solve this problem.

Thanks,

Regards,

Swadhin.

Dear Friend
Actually what you were doing in the code is
You are rendering the Datagrid to HTML Code.
And you are posting the content on to Client browser as Excel file by changing the response headers.

Due to the advance features of Office 2002, it is displayed as HTML for the clients with Office 2002 which is not the case with prior versions of Excel.

To clear your details, you save and open file with notepad, you can find the HTML Content.

If you really want to export the content to Excel, you can do that by using Office web Components installed on the web server.




Regards,
SD