Export to Excel

[Amirallia]

Hello,

Here is my code to export a datagrid to Excel :
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Dim monStringWriter As StringWriter = New StringWriter
Dim monHtmlTextWriter As HtmlTextWriter = New
HtmlTextWriter(monStringWriter)
monDG.RenderControl(monHtmlTextWriter)
Response.Write(monStringWriter.ToString())
Response.End()

All is ok with Excel 2003, the browser ask me to open, save or cancel
the Excel file. And if I choice to open it, the Excel file opens on a
another page.
But on my Laptop (Excel 2000), I'haven't the possibility to Open, Save
or cancel, it directly opens it on the same page !!!!!

Any idea

 

[Edwin Knoppert]

Try:

application/force-download

instead of application/vnd.ms-excel