Response.Write("Hello LOLOTA")

以下程式可以將GridView的內容轉成Excel，且中文不會亂碼，而Dim style As String...這一段程式則是處理數字(例如 00123，不會變成123)。

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim style As String = "<style> .text { mso-number-format:\@; } </script> " Response.AppendHeader("Content-Disposition", "attachment; filename=excel.xls") Response.ContentType = "application/vnd.ms-excel" Dim sw As New System.IO.StringWriter Dim hw As New System.Web.UI.HtmlTextWriter(sw) Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>") GridView1.RenderControl(hw) Response.Write(style) Response.Write(sw.ToString()) Response.End() End Sub Public Overrides Sub VerifyRenderingInServerForm(ByVal control As Control) '處理'GridView' 的控制項 'GridView' 必須置於有 runat=server 的表單標記之中 End Sub Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound e.Row.Cells(1).Attributes.Add("class", "text") End Sub

 

 

如果您有微軟技術開發的問題，可以到MSDN Forum發問。

如果您有微軟IT管理的問題，可以到TechNet Forum發問喔。