«

Hi,
I have surfed through several posting about exporting gridview to excel and
it works great. using the following code...
response.Clear()
response.ContentType = "application/vnd.ms-excel"
response.Charset = ""
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)

Dim dg As New GridView()

dg.GridLines = GridLines.None
dg.HeaderStyle.Font.Bold = True
dg.Datasource = myDataTable
dg.DataBind()
'tell the datagrid to render itself to our htmltextwriter
dg.RenderControl(htmlWrite)
'output the html
response.Write(stringWrite.ToString)
response.End()


However when response comes to the client it opens excel using Microsoft
Excel Application instead of inside the Browser. I have following questions...
1. How do I make it open inside the browser instead of using MS Excel
application?
2. Is there any way to explicitly instruct the browser to either open inside
browser or using MS Excel application?

Any sort of guidance on this is greatly appreciated.
Thanks
--Mike

Response.AddHeader("Content-Disposition", "filename=""report.xls""")

if this does not work check out Response.ContentType and check the mime types.

the first line should work for you, although I have used it in conjunction
with Response.BinaryWrite.

Anyways goodluck

"mike" wrote:

> Hi,
> I have surfed through several posting about exporting gridview to excel and
> it works great. using the following code...
> response.Clear()
> response.ContentType = "application/vnd.ms-excel"
> response.Charset = ""
> Dim stringWrite As New System.IO.StringWriter()
> Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
>
> Dim dg As New GridView()
>
> dg.GridLines = GridLines.None
> dg.HeaderStyle.Font.Bold = True
> dg.Datasource = myDataTable
> dg.DataBind()
> 'tell the datagrid to render itself to our htmltextwriter
> dg.RenderControl(htmlWrite)
> 'output the html
> response.Write(stringWrite.ToString)
> response.End()
>
>
> However when response comes to the client it opens excel using Microsoft
> Excel Application instead of inside the Browser. I have following questions...
> 1. How do I make it open inside the browser instead of using MS Excel
> application?
> 2. Is there any way to explicitly instruct the browser to either open inside
> browser or using MS Excel application?
>
> Any sort of guidance on this is greatly appreciated.
> Thanks
> --Mike

Hi Mach II,
I already tried that it does not work.
I remember somebody telling me sometime that it is client side setting that
makes a file either open in Browser or using a specific application. But
unfortunately I do not remember what exactly that is?
Thanks
--Mike


"MACH II" wrote:

> Response.AddHeader("Content-Disposition", "filename=""report.xls""")
>
> if this does not work check out Response.ContentType and check the mime types.
>
> the first line should work for you, although I have used it in conjunction
> with Response.BinaryWrite.
>
> Anyways goodluck
>
> "mike" wrote:
>
> > Hi,
> > I have surfed through several posting about exporting gridview to excel and
> > it works great. using the following code...
> > response.Clear()
> > response.ContentType = "application/vnd.ms-excel"
> > response.Charset = ""
> > Dim stringWrite As New System.IO.StringWriter()
> > Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
> >
> > Dim dg As New GridView()
> >
> > dg.GridLines = GridLines.None
> > dg.HeaderStyle.Font.Bold = True
> > dg.Datasource = myDataTable
> > dg.DataBind()
> > 'tell the datagrid to render itself to our htmltextwriter
> > dg.RenderControl(htmlWrite)
> > 'output the html
> > response.Write(stringWrite.ToString)
> > response.End()
> >
> >
> > However when response comes to the client it opens excel using Microsoft
> > Excel Application instead of inside the Browser. I have following questions...
> > 1. How do I make it open inside the browser instead of using MS Excel
> > application?
> > 2. Is there any way to explicitly instruct the browser to either open inside
> > browser or using MS Excel application?
> >
> > Any sort of guidance on this is greatly appreciated.
> > Thanks
> > --Mike

[malilla_man]

Hello my friend,

here is the code that are you looking for:

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);
//this.ClearControls(DataList1);
DataList1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();