468,736 Members | 2,058 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,736 developers. It's quick & easy.

exporting excel in asp.net

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.No Cache)
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.GetStaffMeetRepor tDR
grdNew.DataBind()

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

Aug 31 '06 #1
1 1178
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!
*************************************************
<th************@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
>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.No Cache)
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.GetStaffMeetRepor tDR
grdNew.DataBind()

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

Aug 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Neil | last post: by
2 posts views Thread by Mustufa Baig | last post: by
1 post views Thread by Mustufa Baig | last post: by
4 posts views Thread by Tom | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.