感謝兩位回文
給了我一些靈感
目前我的問題已經解決了
不必存實體檔案到server上頭也可以跳出 Excel 的畫面
以下程式碼大部分是 google 到的 但是很好用
Protected Sub LinkButton1_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles LinkButton1.Click
Dim gv As GridView = Me.GridView1
Dim blPaging As Boolean = gv.AllowPaging
gv.AllowPaging = False
gv.DataBind()
Dim tw As New IO.StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
Dim frm As HtmlForm = New HtmlForm()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition",
"attachment;filename=" & "ExportToExcel" & ".xls")
Response.Charset = ""
EnableViewState = False
Controls.Add(frm)
frm.Controls.Add(gv)
frm.RenderControl(hw)
Response.Write("<style> .TextToExcel { mso-number-format:\@; }
</style> ")
Response.Write(tw.ToString())
Response.End()
gv.AllowPaging = blPaging
gv.DataBind()
End Sub
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID"
SortExpression="ID">
<ItemStyle CssClass="TextToExcel" />
</asp:BoundField>
<asp:BoundField DataField="Name" HeaderText="Name"
SortExpression="Name" />
</Columns>
</asp:GridView>
另外我也在網路上搜尋到一些相關的文章
附上連結供大家參考
C# 詳解
http://gridviewguy.com/ArticleDetails.aspx?articleID=197
VB 解
http://www.123aspx.com/redir.aspx?res=33792
參考
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp2_dc11032006003657AM/exportxl_asp2_dc.aspx
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp22_dc04022007235740PM/exportxl_asp22_dc.aspx
http://www.codeproject.com/aspnet/Excel_CSV_export_button.asp
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/ExportASPNetDataGridToExcel11222005041447AM/ExportASPNetDataGridToExcel.aspx
感恩～
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.63.21.246
※ 編輯: commiserate 來自: 61.63.21.246 (05/17 19:30)