{"id":2995,"date":"2012-05-02T12:25:17","date_gmt":"2012-05-02T04:25:17","guid":{"rendered":"http:\/\/www.rockfu.net\/blog\/?p=2995"},"modified":"2012-05-20T23:04:23","modified_gmt":"2012-05-20T15:04:23","slug":"phpexcel-%e4%ba%82%e7%a2%bc-%e8%bc%b8%e5%87%ba%e8%a7%a3%e6%b1%ba%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.rockfu.net\/blog\/2012\/05\/website\/php\/phpexcel-%e4%ba%82%e7%a2%bc-%e8%bc%b8%e5%87%ba%e8%a7%a3%e6%b1%ba%e6%96%b9%e6%b3%95\/","title":{"rendered":"phpexcel \u4e82\u78bc \u8f38\u51fa\u89e3\u6c7a\u65b9\u6cd5"},"content":{"rendered":"<p>phpexcel \u5f88\u5e38\u7528\uff0c\u56e0\u70ba\u53ef\u4ee5\u7528\u4f86\u8b80\u53d6excel\uff0c\u53c8\u53ef\u4ee5\u8f38\u51fa\uff0c\u4e4b\u524d\u5728\u7528\u6642\u5c31\u9047\u5230\u4e00\u500b\u554f\u984c\uff0c\u8f38\u51fa\u4e0b\u8f09\u6642\u51fa\u73fe\u4e82\u78bc\uff0c\u4e4b\u524d\u7531\u65bc\u8d95\u6642\u9593\uff0c\u5c31\u6c92\u6709\u7528\u700f\u89bd\u5668\u76f4\u63a5\u4e0b\u8f09\uff0c\u800c\u662f\u63d0\u4f9b\u4e0b\u8f09\u93c8\u63a5\uff0c\u56e0\u70ba\u6709\u4e9b\u4e0d\u540c\uff1b<\/p><div class=\"rockf-content\" id=\"rockf-427093666\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-5237544886808594\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-5237544886808594\" \ndata-ad-slot=\"6353985797\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<p>$objWriter-&gt;save(&#8216;php:\/\/output&#8217;);<\/p>\n<p>\u4e0a\u9762\u662f\u76f4\u63a5\u8df3\u51fa\u4e0b\u8f09\u63d0\u793a\uff0c\u4e0d\u6703\u5b58\u5728\u4f3a\u670d\u5668<\/p>\n<p>$objWriter-&gt;save($file);<\/p>\n<p>\u9019\u500b\u5c31\u6703\u5b58\u4e00\u4efd\u5728\u4f3a\u670d\u5668\u4e2d\uff0c$file\u5c31\u662f\u4f60\u5b9a\u7fa9\u7684\u540d\u5b57\uff0c\u8def\u5f91\u7b49\u3002<\/p>\n<p>\u90a3\u9ebc\u76f4\u63a5\u4e0b\u8f09\u4e82\u78bc\u5982\u4f55\u89e3\u6c7a\uff0c\u7b46\u8005\u770b\u4e86\u5f88\u591a\u8cc7\u6599\uff0cgoogle\u4e86\u4e0d\u5c11\uff0c\u7d42\u65bc\u89e3\u6c7a\u4e86\uff0c\u5728\u6b64\u7e3d\u7d50\u3002<\/p>\n<p>\u56e0\u70ba\u7a0b\u5e8f\u7528\u4e86smarty\uff0c\u56e0\u6b64\u9700\u8981\u8003\u616e\u9019\u554f\u984c\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u9996\u5148\u662fheader()\u554f\u984c\uff0c\u9019\u4e9bheader \u662f\u63d0\u4f9b\u4fe1\u606f\u7d66\u700f\u89bd\u5668\u770b\uff0c\u56e0\u6b64\u9019\u4e9b\u4fe1\u606f\u6700\u597d\u653e\u5728&lt;?php \u4e0b\u4e00\u884c\uff0c\u56e0\u70baheader\u524d\u4e0d\u80fd\u6709\u7a7a\u884c\uff0c\u4e0d\u7136\u6703\u6709\u932f\u8aa4\u3002header \u932f\u8aa4\u53ef\u80fd\u6703\u5c0e\u81f4\u4e0d\u6703popup \u63d0\u793a\u4e0b\u8f09\u986f\u793a\u932f\u8aa4\uff0c\u89e3\u6c7a\u4e86\u5c31\u6703\u63d0\u793a\u4e0b\u8f09\u3002<\/p>\n<p>\u9664\u4e86\u9019\u500b\uff0c\u9084\u6703\u6709\u4e82\u78bc\u554f\u984c\uff0c\u9019\u500b\u53c8\u662f\u95dc\u65bc\u6587\u4ef6dom \u554f\u984c\uff0c\u96d6\u7136\u5f88\u591a\u4eba\u5728\u7db2\u4e0a\u8aaa\u4e0d\u80fd\u6709\u7a7a\u884c\uff0c\u4e0d\u904e\u4e00\u500b\u6587\u4ef6include \u4e86\u5f88\u591a\u6587\u4ef6\uff0c\u7a76\u7adf\u5982\u4f55\u8ffd\u67e5\uff1f\u592a\u7b28\u4e86\u5427\uff0c\u6211\u5148\u7528\u4e86\u9019\u7b28\u7684\u65b9\u6cd5\uff0c\u628a\u6587\u4ef6\u8f49\u6210UTF-8\uff0c\u7136\u5f8c\u53c8\u79fb\u9664DOM\uff0c\u7d50\u679c\u6c92\u7528\u3002\u6700\u5f8c\u5728\u5b98\u65b9\u90a3\u627e\u5230\u597d\u7528\u7684\u6771\u897f\uff0c\u5728header()\u524d\u52a0\u4e0a<\/p>\n<p>ob_end_clean();<\/p>\n<p>\u5c31\u9019\u9ebc\u4e00\u53e5\uff0c\u4e82\u78bc\u89e3\u6c7a\u4e86\uff01<\/p>\n<p>\u5c31\u9019\u9ebc\u7c21\u55ae\uff0c\u4f46\u82b1\u4e86\u5e7e\u500b\u5c0f\u6642\u5617\u8a66\uff0c\u7b97\u662f\u5f97\u76ca\u3002<\/p>\n<div class=\"rockf-after\" id=\"rockf-23409063\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-5237544886808594\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-5237544886808594\" \ndata-ad-slot=\"6353985797\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>phpexcel \u5f88\u5e38\u7528\uff0c\u56e0\u70ba\u53ef\u4ee5\u7528\u4f86\u8b80\u53d6excel\uff0c\u53c8\u53ef\u4ee5\u8f38\u51fa\uff0c\u4e4b\u524d\u5728\u7528\u6642\u5c31\u9047\u5230\u4e00\u500b\u554f\u984c\uff0c\u8f38\u51fa\u4e0b\u8f09\u6642\u51fa\u73fe\u4e82\u78bc &hellip; <a href=\"https:\/\/www.rockfu.net\/blog\/2012\/05\/website\/php\/phpexcel-%e4%ba%82%e7%a2%bc-%e8%bc%b8%e5%87%ba%e8%a7%a3%e6%b1%ba%e6%96%b9%e6%b3%95\/\" class=\"more-link\">\u7e7c\u7e8c\u95b1\u8b80<span class=\"screen-reader-text\"> &#8220;phpexcel \u4e82\u78bc \u8f38\u51fa\u89e3\u6c7a\u65b9\u6cd5&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":3019,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[273],"tags":[756,566,340],"class_list":["post-2995","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-php","tag-phpexcel","tag-340"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.rockfu.net\/blog\/wp-content\/uploads\/2012\/05\/php_vers_excel.jpg?fit=300%2C200&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/prNEE-Mj","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/posts\/2995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/comments?post=2995"}],"version-history":[{"count":6,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/posts\/2995\/revisions"}],"predecessor-version":[{"id":3018,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/posts\/2995\/revisions\/3018"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/media\/3019"}],"wp:attachment":[{"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/media?parent=2995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/categories?post=2995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rockfu.net\/blog\/wp-json\/wp\/v2\/tags?post=2995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}