exporting excel in asp.net

  • Thread starter Thread starter theheathergirl
  • Start date Start date
T

theheathergirl

I have a page that has a button and it exports fine on the laptop but
when I drop it on the server and hit it from a client machine on the
LAN (https) it gives me an explorer error that it cannot download the
page... The server has some certificates needs that my laptop does not,
not sure if that is it. Any help would be awesome. code below:

Protected Sub btnExcel_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnExcel.Click
Dim stringWrite
Dim htmlWrite

Response.Clear()
Response.AddHeader("content-disposition",
"inline;filename=EPRTracker.xls")
Response.Charset = ""


Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
stringWrite = New System.IO.StringWriter()
htmlWrite = New HtmlTextWriter(stringWrite)
Dim grdNew As New GridView()
'grdNew.AutoGenerateColumns = True
grdNew.DataSource =
EPRTrackerLibrary.EPRTrackerView.GetStaffMeetReportDR
grdNew.DataBind()

grdNew.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.End()


End Sub
 
Attempt to hit another SSL page (https) and see if you have a certificate
issue (server certificate). If so, correct it by trusting the root. This
will have to be done on EVERY client.

If, instead, you mean client side certs, that should not be a major deal.

Also, make sure you have the Excel MIME type registered. I doubt it is your
issue, but it WILL Cause issues of is own later.

Hope this helps.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
 
Back
Top