<thead id="jxdzp"><address id="jxdzp"><pre id="jxdzp"></pre></address></thead>

<em id="jxdzp"><span id="jxdzp"></span></em>

    <listing id="jxdzp"><nobr id="jxdzp"><meter id="jxdzp"></meter></nobr></listing>

      <address id="jxdzp"></address>
      <noframes id="jxdzp"><form id="jxdzp"><th id="jxdzp"></th></form>
      <noframes id="jxdzp"><form id="jxdzp"><th id="jxdzp"></th></form>

          訂閱本欄目 RSS您所在的位置: 深山工作室 > ASP > 正文

          ASP導出WORD或Excel文檔(比較另類,而且超級強的。)

          網絡 2009/8/18 10:17:12 深山行者 字體: 瀏覽 30618
          ASP導出WORD或Excel文檔(比較另類,而且超級強的。)

          <%
          Response.Buffer  = True
          Response.ContentType = "文檔類型"
          Response.AddHeader "content-disposition", "inline; filename = 保存的名稱.格式"
          %>

          可以使用ASP將一些數據導出為Word或者Excel文檔,其實很簡單,導出的資料即為網頁中顯示的資料。只需在網頁的頭部加入以下代碼即可

          只需更改文檔類型和保存的名稱.格式即可。


          該方法經本人測試,還是不錯的,唯一不好的地方就是:在保存文件名時,不能自定義文件名,而是與當前文件的名稱一樣比如:(index.asp里面放生成代碼,結果就是index.doc),我暈呼了。不過不要急,我又想出了另外的一個辦法,比較另類,就是利FSO生成,反正我是弄出word來了,不知道你們行不行。

           
          文檔類型有以下幾種:

          以下是引用片段:

          ".*"="application/octet-stream"
          ".001"="application/x-001"
          ".301"="application/x-301"
          ".323"="text/h323"
          ".906"="application/x-906"
          ".907"="drawing/907"
          ".a11"="application/x-a11"
          ".acp"="audio/x-mei-aac"
          ".ai"="application/postscript"
          ".aif"="audio/aiff"
          ".aifc"="audio/aiff"
          ".aiff"="audio/aiff"
          ".anv"="application/x-anv"
          ".asa"="text/asa"
          ".asf"="video/x-ms-asf"
          ".asp"="text/asp"
          ".asx"="video/x-ms-asf"
          ".au"="audio/basic"
          ".avi"="video/avi"
          ".awf"="application/vnd.adobe.workflow"
          ".biz"="text/xml"
          ".bmp"="application/x-bmp"
          ".bot"="application/x-bot"
          ".c4t"="application/x-c4t"
          ".c90"="application/x-c90"
          ".cal"="application/x-cals"
          ".cat"="application/vnd.ms-pki.seccat"
          ".cdf"="application/x-netcdf"
          ".cdr"="application/x-cdr"
          ".cel"="application/x-cel"
          ".cer"="application/x-x509-ca-cert"
          ".cg4"="application/x-g4"
          ".cgm"="application/x-cgm"
          ".cit"="application/x-cit"
          ".class"="java/*"
          ".cml"="text/xml"
          ".cmp"="application/x-cmp"
          ".cmx"="application/x-cmx"
          ".cot"="application/x-cot"
          ".crl"="application/pkix-crl"
          ".crt"="application/x-x509-ca-cert"
          ".csi"="application/x-csi"
          ".css"="text/css"
          ".cut"="application/x-cut"
          ".dbf"="application/x-dbf"
          ".dbm"="application/x-dbm"
          ".dbx"="application/x-dbx"
          ".dcd"="text/xml"
          ".dcx"="application/x-dcx"
          ".der"="application/x-x509-ca-cert"
          ".dgn"="application/x-dgn"
          ".dib"="application/x-dib"
          ".dll"="application/x-msdownload"
          ".doc"="application/msword"
          ".dot"="application/msword"
          ".drw"="application/x-drw"
          ".dtd"="text/xml"
          ".dwf"="Model/vnd.dwf"
          ".dwf"="application/x-dwf"
          ".dwg"="application/x-dwg"
          ".dxb"="application/x-dxb"
          ".dxf"="application/x-dxf"
          ".edn"="application/vnd.adobe.edn"
          ".emf"="application/x-emf"
          ".eml"="message/rfc822"
          ".ent"="text/xml"
          ".epi"="application/x-epi"
          ".eps"="application/x-ps"
          ".eps"="application/postscript"
          ".etd"="application/x-ebx"
          ".exe"="application/x-msdownload"
          ".fax"="image/fax"
          ".fdf"="application/vnd.fdf"
          ".fif"="application/fractals"
          ".fo"="text/xml"
          ".frm"="application/x-frm"
          ".g4"="application/x-g4"
          ".gbr"="application/x-gbr"
          ".gcd"="application/x-gcd"
          ".gif"="image/gif"
          ".gl2"="application/x-gl2"
          ".gp4"="application/x-gp4"
          ".hgl"="application/x-hgl"
          ".hmr"="application/x-hmr"
          ".hpg"="application/x-hpgl"
          ".hpl"="application/x-hpl"
          ".hqx"="application/mac-binhex40"
          ".hrf"="application/x-hrf"
          ".hta"="application/hta"
          ".htc"="text/x-component"
          ".htm"="text/html"
          ".html"="text/html"
          ".htt"="text/webviewhtml"
          ".htx"="text/html"
          ".icb"="application/x-icb"
          ".ico"="image/x-icon"
          ".ico"="application/x-ico"
          ".iff"="application/x-iff"
          ".ig4"="application/x-g4"
          ".igs"="application/x-igs"
          ".iii"="application/x-iphone"
          ".img"="application/x-img"
          ".ins"="application/x-internet-signup"
          ".isp"="application/x-internet-signup"
          ".IVF"="video/x-ivf"
          ".java"="java/*"
          ".jfif"="image/jpeg"
          ".jpe"="image/jpeg"
          ".jpe"="application/x-jpe"
          ".jpeg"="image/jpeg"
          ".jpg"="image/jpeg"
          ".jpg"="application/x-jpg"
          ".js"="application/x-javascript"
          ".jsp"="text/html"
          ".la1"="audio/x-liquid-file"
          ".lar"="application/x-laplayer-reg"
          ".latex"="application/x-latex"
          ".lavs"="audio/x-liquid-secure"
          ".lbm"="application/x-lbm"
          ".lmsff"="audio/x-la-lms"
          ".ls"="application/x-javascript"
          ".ltr"="application/x-ltr"
          ".m1v"="video/x-mpeg"
          ".m2v"="video/x-mpeg"
          ".m3u"="audio/mpegurl"
          ".m4e"="video/mpeg4"
          ".mac"="application/x-mac"
          ".man"="application/x-troff-man"
          ".math"="text/xml"
          ".mdb"="application/msaccess"
          ".mdb"="application/x-mdb"
          ".mfp"="application/x-shockwave-flash"
          ".mht"="message/rfc822"
          ".mhtml"="message/rfc822"
          ".mi"="application/x-mi"
          ".mid"="audio/mid"
          ".midi"="audio/mid"
          ".mil"="application/x-mil"
          ".mml"="text/xml"
          ".mnd"="audio/x-musicnet-download"
          ".mns"="audio/x-musicnet-stream"
          ".mocha"="application/x-javascript"
          ".movie"="video/x-sgi-movie"
          ".mp1"="audio/mp1"
          ".mp2"="audio/mp2"
          ".mp2v"="video/mpeg"
          ".mp3"="audio/mp3"
          ".mp4"="video/mpeg4"
          ".mpa"="video/x-mpg"
          ".mpd"="application/vnd.ms-project"
          ".mpe"="video/x-mpeg"
          ".mpeg"="video/mpg"
          ".mpg"="video/mpg"
          ".mpga"="audio/rn-mpeg"
          ".mpp"="application/vnd.ms-project"
          ".mps"="video/x-mpeg"
          ".mpt"="application/vnd.ms-project"
          ".mpv"="video/mpg"
          ".mpv2"="video/mpeg"
          ".mpw"="application/vnd.ms-project"
          ".mpx"="application/vnd.ms-project"
          ".mtx"="text/xml"
          ".mxp"="application/x-mmxp"
          ".net"="image/pnetvue"
          ".nrf"="application/x-nrf"
          ".nws"="message/rfc822"
          ".odc"="text/x-ms-odc"
          ".out"="application/x-out"
          ".p10"="application/pkcs10"
          ".p12"="application/x-pkcs12"
          ".p7b"="application/x-pkcs7-certificates"
          ".p7c"="application/pkcs7-mime"
          ".p7m"="application/pkcs7-mime"
          ".p7r"="application/x-pkcs7-certreqresp"
          ".p7s"="application/pkcs7-signature"
          ".pc5"="application/x-pc5"
          ".pci"="application/x-pci"
          ".pcl"="application/x-pcl"
          ".pcx"="application/x-pcx"
          ".pdf"="application/pdf"
          ".pdf"="application/pdf"
          ".pdx"="application/vnd.adobe.pdx"
          ".pfx"="application/x-pkcs12"
          ".pgl"="application/x-pgl"
          ".pic"="application/x-pic"
          ".pko"="application/vnd.ms-pki.pko"
          ".pl"="application/x-perl"
          ".plg"="text/html"
          ".pls"="audio/scpls"
          ".plt"="application/x-plt"
          ".png"="image/png"
          ".png"="application/x-png"
          ".pot"="application/vnd.ms-powerpoint"
          ".ppa"="application/vnd.ms-powerpoint"
          ".ppm"="application/x-ppm"
          ".pps"="application/vnd.ms-powerpoint"
          ".ppt"="application/vnd.ms-powerpoint"
          ".ppt"="application/x-ppt"
          ".pr"="application/x-pr"
          ".prf"="application/pics-rules"
          ".prn"="application/x-prn"
          ".prt"="application/x-prt"
          ".ps"="application/x-ps"
          ".ps"="application/postscript"
          ".ptn"="application/x-ptn"
          ".pwz"="application/vnd.ms-powerpoint"
          ".r3t"="text/vnd.rn-realtext3d"
          ".ra"="audio/vnd.rn-realaudio"
          ".ram"="audio/x-pn-realaudio"
          ".ras"="application/x-ras"
          ".rat"="application/rat-file"
          ".rdf"="text/xml"
          ".rec"="application/vnd.rn-recording"
          ".red"="application/x-red"
          ".rgb"="application/x-rgb"
          ".rjs"="application/vnd.rn-realsystem-rjs"
          ".rjt"="application/vnd.rn-realsystem-rjt"
          ".rlc"="application/x-rlc"
          ".rle"="application/x-rle"
          ".rm"="application/vnd.rn-realmedia"
          ".rmf"="application/vnd.adobe.rmf"
          ".rmi"="audio/mid"
          ".rmj"="application/vnd.rn-realsystem-rmj"
          ".rmm"="audio/x-pn-realaudio"
          ".rmp"="application/vnd.rn-rn_music_package"
          ".rms"="application/vnd.rn-realmedia-secure"
          ".rmvb"="application/vnd.rn-realmedia-vbr"
          ".rmx"="application/vnd.rn-realsystem-rmx"
          ".rnx"="application/vnd.rn-realplayer"
          ".rp"="image/vnd.rn-realpix"
          ".rpm"="audio/x-pn-realaudio-plugin"
          ".rsml"="application/vnd.rn-rsml"
          ".rt"="text/vnd.rn-realtext"
          ".rtf"="application/msword"
          ".rtf"="application/x-rtf"
          ".rv"="video/vnd.rn-realvideo"
          ".sam"="application/x-sam"
          ".sat"="application/x-sat"
          ".sdp"="application/sdp"
          ".sdw"="application/x-sdw"
          ".sit"="application/x-stuffit"
          ".slb"="application/x-slb"
          ".sld"="application/x-sld"
          ".slk"="drawing/x-slk"
          ".smi"="application/smil"
          ".smil"="application/smil"
          ".smk"="application/x-smk"
          ".snd"="audio/basic"
          ".sol"="text/plain"
          ".sor"="text/plain"
          ".spc"="application/x-pkcs7-certificates"
          ".spl"="application/futuresplash"
          ".spp"="text/xml"
          ".ssm"="application/streamingmedia"
          ".sst"="application/vnd.ms-pki.certstore"
          ".stl"="application/vnd.ms-pki.stl"
          ".stm"="text/html"
          ".sty"="application/x-sty"
          ".svg"="text/xml"
          ".swf"="application/x-shockwave-flash"
          ".tdf"="application/x-tdf"
          ".tg4"="application/x-tg4"
          ".tga"="application/x-tga"
          ".tif"="image/tiff"
          ".tif"="application/x-tif"
          ".tiff"="image/tiff"
          ".tld"="text/xml"
          ".top"="drawing/x-top"
          ".torrent"="application/x-bittorrent"
          ".tsd"="text/xml"
          ".txt"="text/plain"
          ".uin"="application/x-icq"
          ".uls"="text/iuls"
          ".vcf"="text/x-vcard"
          ".vda"="application/x-vda"
          ".vdx"="application/vnd.visio"
          ".vml"="text/xml"
          ".vpg"="application/x-vpeg005"
          ".vsd"="application/vnd.visio"
          ".vsd"="application/x-vsd"
          ".vss"="application/vnd.visio"
          ".vst"="application/vnd.visio"
          ".vst"="application/x-vst"
          ".vsw"="application/vnd.visio"
          ".vsx"="application/vnd.visio"
          ".vtx"="application/vnd.visio"
          ".vxml"="text/xml"
          ".wav"="audio/wav"
          ".wax"="audio/x-ms-wax"
          ".wb1"="application/x-wb1"
          ".wb2"="application/x-wb2"
          ".wb3"="application/x-wb3"
          ".wbmp"="image/vnd.wap.wbmp"
          ".wiz"="application/msword"
          ".wk3"="application/x-wk3"
          ".wk4"="application/x-wk4"
          ".wkq"="application/x-wkq"
          ".wks"="application/x-wks"
          ".wm"="video/x-ms-wm"
          ".wma"="audio/x-ms-wma"
          ".wmd"="application/x-ms-wmd"
          ".wmf"="application/x-wmf"
          ".wml"="text/vnd.wap.wml"
          ".wmv"="video/x-ms-wmv"
          ".wmx"="video/x-ms-wmx"
          ".wmz"="application/x-ms-wmz"
          ".wp6"="application/x-wp6"
          ".wpd"="application/x-wpd"
          ".wpg"="application/x-wpg"
          ".wpl"="application/vnd.ms-wpl"
          ".wq1"="application/x-wq1"
          ".wr1"="application/x-wr1"
          ".wri"="application/x-wri"
          ".wrk"="application/x-wrk"
          ".ws"="application/x-ws"
          ".ws2"="application/x-ws"
          ".wsc"="text/scriptlet"
          ".wsdl"="text/xml"
          ".wvx"="video/x-ms-wvx"
          ".xdp"="application/vnd.adobe.xdp"
          ".xdr"="text/xml"
          ".xfd"="application/vnd.adobe.xfd"
          ".xfdf"="application/vnd.adobe.xfdf"
          ".xhtml"="text/html"
          ".xls"="application/vnd.ms-excel"
          ".xls"="application/x-xls"
          ".xlw"="application/x-xlw"
          ".xml"="text/xml"
          ".xpl"="audio/scpls"
          ".xq"="text/xml"
          ".xql"="text/xml"
          ".xquery"="text/xml"
          ".xsd"="text/xml"
          ".xsl"="text/xml"
          ".xslt"="text/xml"
          ".xwd"="application/x-xwd"
          ".x_b"="application/x-x_b"
          ".x_t"="application/x-x_t"

           

          相關閱讀
          實時輸入數字自動轉換為貨幣形式并計算
          optgroup 標簽
          利用CSS樣式美化Button或submit按鈕
          旅行社網站模板11
          網站首頁head區代碼規范
          asp實現獲得當前文章的上一篇信息與下一篇信息功能及代碼
          用ASP對網頁進行限制性的訪問
          吉林省觀光國際旅行社
          共有0條關于《ASP導出WORD或Excel文檔(比較另類,而且超級強的。)》的評論
          發表評論
          正在加載評論......
          返回頂部發表評論
          呢 稱:
          表 情:
          內 容:
          評論內容:不能超過 1000 字,需審核,請自覺遵守互聯網相關政策法規。
          驗證碼: 驗證碼 
          網友評論聲明,請自覺遵守互聯網相關政策法規。

          您發布的評論即表示同意遵守以下條款:
          一、不得利用本站危害國家安全、泄露國家秘密,不得侵犯國家、社會、集體和公民的合法權益;
          二、不得發布國家法律、法規明令禁止的內容;互相尊重,對自己在本站的言論和行為負責;
          三、本站對您所發布內容擁有處置權。

          更多信息>>欄目類別選擇
          百度小程序開發
          微信小程序開發
          微信公眾號開發
          uni-app
          asp函數庫
          ASP
          DIV+CSS
          HTML
          python
          更多>>同類信息
          ASP中Utf-8與Gb2312編碼轉換亂碼問題的解決方法頁面編碼聲明
          asp顯示隨機密碼
          通過阿里云服務接口獲得ip地址詳細信息
          iis點開后任務欄上有顯示,但是窗口看不到的解決辦法
          RSA加密解密插件
          微軟Encoder加密解密函數
          更多>>最新添加文章
          dw里面查找替換使用正則刪除sqlserver里面的CONSTRAINT
          Android移動端自動化測試:使用UIAutomatorViewer與Selenium定位元素
          抖音直播音掛載小雪花 懂車帝小程序
          javascript獲取瀏覽器指紋可以用來做投票
          火狐Mozilla Firefox出現:無法載入您的Firefox配置文件 它可能已經丟失 或是無法訪問 問題解決集合處理辦法
          在Android、iOS、Windows、MacOS中微信小程序的文件存放路徑
          python通過代碼修改pip下載源讓下載庫飛起
          python里面requests.post返回的res.text還有其它的嗎
          更多>>隨機抽取信息
          連云港旅游網
          CSS初級教程 邊框
          微信公眾號用客服接口推送菜單消息
          深山行者留言系統V3.2
          Photoshop中精典實用技巧
          CSS的優化與技巧
          88国产精品视频一区二区三区