Hello I'm back again...When the page exports to excel I would like for the page to be set up as landscape rather than the user having to make that decision when they print the page. Is that possible?
Protected Sub BtnExportExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=Area.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
GridView1.HeaderRow.Attributes.Add("style", "font-size:10px")
GridView1.Caption = "T16 DI Area and District Pending Claims Listings"
For i As Integer = 0 To GridView1.Rows.Count - 1
Dim row As GridViewRow = GridView1.Rows(i)
'Change Color back to white
row.BackColor = System.Drawing.Color.White
'Apply text style to each Row
row.Attributes.Add("class", "textmode") Next
Me.RemoveControls(GridView1) Dim swriter As New StringWriter()
Dim hwriter As New HtmlTextWriter(swriter)
Dim frm As New HtmlForm() Me.GridView1.Parent.Controls.Add(frm)
frm.Attributes("runat") = "server" frm.Controls.Add(GridView1)
frm.RenderControl(hwriter) Response.Write(swriter.ToString())
Response.[End]() End Sub