無限的可能: ASP.NET中將DataTable匯出為Excel檔

ASP.NET中將DataTable匯出為Excel檔

------------------測試可用方法------------------------

Protected Sub ButtonToExcel_Click(sender As Object, e As System.EventArgs) Handles ButtonToExcel.Click

        Dim style As String = "<style> .text { mso-number-format:\@; } </script> "
        Dim sw As New System.IO.StringWriter
        Dim hw As New System.Web.UI.HtmlTextWriter(sw)
        Response.AppendHeader("Content-Disposition", "attachment; filename=DormInfo_" & Format(Now, "yyyymmdd_HHmm") & ".xls")
        Response.ContentType = "application/vnd.ms-excel"
        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

<%@ Page Language="VB"  CodeFile="searchname.aspx.vb" Inherits="searchname" AutoEventWireup="true" EnableEventValidation="false" MaintainScrollPositionOnPostback="true"%>

----------------------以下是參考文件---------------------

http://fecbob.pixnet.net/blog/post/38113893-asp.net%E4%B8%AD%E5%B0%87datatable%E5%8C%AF%E5%87%BA%E7%82%BAexcel%E6%AA%94

http://www.dotblogs.com.tw/mis2000lab/Tags/Excel/default.aspx

https://www.google.com/search?q=excel+site:http://www.dotblogs.com.tw/mis2000lab/&domains=http://www.dotblogs.com.tw/mis2000lab/&hl=zh-TW&qscrl=1&source=lnt&tbs=qdr:y&sa=X&ei=-JRPU6uSN4SolAXV1YDoBw&ved=0CBoQpwUoBQ&biw=1920&bih=963

https://tw.knowledge.yahoo.com/question/question?qid=1008112903102

相關問題（ASP.NET與Excel）我也曾遇見過，所以蒐集了一些資料，放在我的BLOG與大家共享：

http://www.google.com/search?q=excel&ie=UTF8&oe=UTF8&hl=zh-TW&btnG=Search&domains=http://www.dotblogs.com.tw/mis2000lab/&sitesearch=http://www.dotblogs.com.tw/mis2000lab/

[NPOI 2.0] ASP.NET 輸出 Excel (.xlsx檔 2007格式) -- ASP.NET Export to Excel (.xlsx)
http://www.dotblogs.com.tw/mis2000lab/archive/2014/07/02/npoi-20-for-aspnet_20140703.aspx

-----------------------------------------------------------------------

1. 如果Excel欄位與資料庫完全相同，

那就簡單了，也有更好的工作去完成這種資料匯入的動作。

甚至不需要自己寫程式。