By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,364 Members | 1,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,364 IT Pros & Developers. It's quick & easy.

exporting excel in asp.net

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.