{"id":171,"date":"2015-06-25T14:41:41","date_gmt":"2015-06-25T06:41:41","guid":{"rendered":"https:\/\/www.webteach.tw\/?p=171"},"modified":"2015-06-25T14:41:41","modified_gmt":"2015-06-25T06:41:41","slug":"php-%e5%88%a9%e7%94%a8phpexcel%e8%ae%80%e5%8f%96excel%e8%b3%87%e6%96%99","status":"publish","type":"post","link":"https:\/\/www.webteach.tw\/?p=171","title":{"rendered":"[ PHP ] &#8211; \u5229\u7528PHPEXCEL\u8b80\u53d6EXCEL\u8cc7\u6599"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5229\u7528PHPEXCEL\u8b80\u53d6EXCEL\u8cc7\u6599<\/p>\n\n\n<pre class=\"wp-block-code\"><code>\n&lt;?php\ninclude('Classes\/PHPExcel.php');\ninclude('Classes\/PHPExcel\/Writer\/Excel2007.php');\nrequire_once('Classes\/PHPExcel\/IOFactory.php');\n$reader = PHPExcel_IOFactory::createReader('Excel2007'); \/\/ \u8b80\u53d62007 excel \u6a94\u6848\n$PHPExcel = $reader->load(\"member.xlsx\"); \/\/ \u6a94\u6848\u540d\u7a31 \u9700\u5df2\u7d93\u4e0a\u50b3\u5230\u4e3b\u6a5f\u4e0a\n$sheet = $PHPExcel->getSheet(0); \/\/ \u8b80\u53d6\u7b2c\u4e00\u500b\u5de5\u4f5c\u8868(\u7de8\u865f\u5f9e 0 \u958b\u59cb)\n$highestRow = $sheet->getHighestRow(); \/\/ \u53d6\u5f97\u7e3d\u5217\u6578\necho '\u7e3d\u5171 '.$highestRow.' \u5217';\n\/\/ \u4e00\u6b21\u8b80\u53d6\u4e00\u5217\nfor ($row = 0; $row &lt;= $highestRow; $row++) {\nfor ($column = 0; $column &lt;= 12; $column++) {\/\/\u770b\u4f60\u6709\u5e7e\u500b\u6b04\u4f4d \u6b64\u7bc4\u4f8b\u70ba 13 \u500b\u4f4d\n$val = $sheet->getCellByColumnAndRow($column, $row)->getValue();\necho $val.' ';\n}\necho \"&lt;br \/>\";\n}\n?><\/code><\/pre>\n\n\n<p class=\"wp-block-paragraph\">phpexcel \u5b98\u7db2\uff1a<a href=\"https:\/\/phpexcel.codeplex.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/phpexcel.codeplex.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5229\u7528PHPEXCEL\u8b80\u53d6EXCEL\u8cc7\u6599 phpex&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[452,1190],"class_list":["post-171","post","type-post","status-publish","format-standard","hentry","category-phpexcel","tag-phpexcel","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=171"}],"version-history":[{"count":0,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/171\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}