{"id":319,"date":"2010-07-12T15:46:11","date_gmt":"2010-07-12T07:46:11","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/index.php\/2010\/07\/12\/delphi%e5%af%ab%e5%85%a5excel%e6%99%82%ef%bc%8c%e5%af%ab%e5%85%a5%e9%80%9f%e5%ba%a6%e7%b7%a9%e6%85%a2%e5%95%8f%e9%a1%8c\/"},"modified":"2011-04-07T10:54:56","modified_gmt":"2011-04-07T02:54:56","slug":"delphi%e5%af%ab%e5%85%a5excel%e6%99%82%ef%bc%8c%e5%af%ab%e5%85%a5%e9%80%9f%e5%ba%a6%e7%b7%a9%e6%85%a2%e5%95%8f%e9%a1%8c","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=319","title":{"rendered":"DELPHI\u5beb\u5165EXCEL\u6642\uff0c\u5beb\u5165\u901f\u5ea6\u7de9\u6162\u554f\u984c"},"content":{"rendered":"<p>\u6700\u8fd1\u5728\u4fee\u6539\u4f7f\u7528\u8005\u63d0\u51fa EXCEL \u5831\u8868\u6b04\u4f4d\uff0c\u767c\u73fe\u6709\u5e7e\u652f procedure \u8f49\u51fa EXCEL \u7684\u901f\u5ea6\u975e\u5e38\u9f9c\uff0c\u800c\u9019\u5e7e\u652f procedure \u662f\u524d\u8f29\u6240\u7559\u4e0b\u7684\u7522\u7269\uff0c\u8ddf\u81ea\u5df1\u6700\u8fd1\u5beb\u7684\u8f49 EXCEL \u5831\u8868\u901f\u5ea6\u4e0a\u5dee\u5f88\u591a\uff0c\u4ee5\u70ba\u662f\u5361\u5728SQL\u67e5\u8a62\uff0c\u5982\u679c\u67e5\u8a62\u689d\u4ef6KEY\u503c\u7d66\u4e0d\u9f4a\u5168\uff0c\u6709\u53ef\u80fd\u56e0\u70ba\u8cc7\u6599\u904e\u591a\uff0c\u67e5\u8a62\u8b8a\u5f88\u6162\uff0c\u4f46\u662f\u6e2c\u8a66\u5f8c\u61c9\u8a72\u4e0d\u662fSQL\u67e5\u8a62\u7684\u554f\u984c\uff0c\u518d\u5c0d\u7167\u524d\u8f29\u8207\u81ea\u5df1\u7684\u7a0b\u5f0f\uff0c\u611f\u89ba\u4e0d\u51fa\u5dee\u7570\uff0c\u6700\u5f8c\u770b\u5230 DELPHI \u5167\u8a2d\u5b9aEXCEL\u6642\u524d\u9762\u901a\u5e38\u6703\u6709\u4e00\u4e9b\u57fa\u672c\u8a2d\u5b9a\uff0c\u767c\u73fe\u4e86\u9019\u5e7e\u652f\u7a0b\u5f0f\u90fd\u6709\u8a2d\u5b9a\u5217\u5370\u7bc4\u570d\uff0c\u59d1\u4e14\u8a3b\u89e3\u6389\u8a66\u8a66\u770b\uff0c\u679c\u7136&#8230;&#8230;&#8230;&#8230;&#8230;\u5147\u624b\u5c31\u662f\u5b83\uff01<\/p>\n<p>PageSetup.PrintArea := &#8216;A:R&#8217;;&#160; \/\/\u8a2d\u5b9a\u5217\u5370\u7bc4\u570d<\/p>\n<p>\u5efa\u8b70\u628a\u5b83\u79fb\u5230\u8cc7\u6599\u8f49\u5b8c\u5f8c\uff0c\u6700\u5f8c\u5728\u7d66\u4e0a\u9019\u500b\u53c3\u6578\u5c31\u597d\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u5728\u4fee\u6539\u4f7f\u7528\u8005\u63d0\u51fa EXCEL \u5831\u8868\u6b04\u4f4d\uff0c\u767c\u73fe\u6709\u5e7e\u652f procedure \u8f49\u51fa EXCEL \u7684\u901f\u5ea6\u975e\u5e38\u9f9c\uff0c\u800c\u9019\u5e7e\u652f procedure \u662f\u524d\u8f29\u6240\u7559\u4e0b\u7684\u7522\u7269\uff0c\u8ddf\u81ea\u5df1\u6700\u8fd1\u5beb\u7684\u8f49 EXCEL \u5831\u8868\u901f\u5ea6\u4e0a\u5dee\u5f88\u591a\uff0c\u4ee5\u70ba\u662f\u5361\u5728SQL\u67e5\u8a62\uff0c\u5982\u679c\u67e5\u8a62\u689d\u4ef6KEY\u503c\u7d66\u4e0d\u9f4a\u5168\uff0c\u6709\u53ef\u80fd\u56e0\u70ba\u8cc7\u6599\u904e\u591a\uff0c\u67e5\u8a62\u8b8a\u5f88\u6162\uff0c\u4f46\u662f\u6e2c\u8a66\u5f8c\u61c9\u8a72\u4e0d\u662fSQL\u67e5\u8a62\u7684\u554f\u984c\uff0c\u518d\u5c0d\u7167\u524d\u8f29\u8207\u81ea\u5df1\u7684\u7a0b\u5f0f\uff0c\u611f\u89ba\u4e0d\u51fa\u5dee\u7570\uff0c\u6700\u5f8c\u770b\u5230 DELPHI \u5167\u8a2d\u5b9aEXCEL\u6642\u524d\u9762\u901a\u5e38\u6703\u6709\u4e00\u4e9b\u57fa\u672c\u8a2d\u5b9a\uff0c\u767c\u73fe\u4e86\u9019\u5e7e\u652f\u7a0b\u5f0f\u90fd\u6709\u8a2d\u5b9a\u5217\u5370\u7bc4\u570d\uff0c\u59d1\u4e14\u8a3b\u89e3\u6389\u8a66\u8a66\u770b\uff0c\u679c\u7136&#8230;&#8230;&#8230;&#8230;&#8230;\u5147\u624b\u5c31\u662f\u5b83\uff01<\/p>\n<p>PageSetup.PrintArea := &#8216;A:R&#8217;;&#160; \/\/\u8a2d\u5b9a\u5217\u5370\u7bc4\u570d<\/p>\n<p>\u5efa\u8b70\u628a\u5b83\u79fb\u5230\u8cc7\u6599\u8f49\u5b8c\u5f8c\uff0c\u6700\u5f8c\u5728\u7d66\u4e0a\u9019\u500b\u53c3\u6578\u5c31\u597d\u4e86\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,73],"tags":[303],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/319"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=319"}],"version-history":[{"count":2,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":563,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/319\/revisions\/563"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}