{"id":209,"date":"2015-05-14T16:36:27","date_gmt":"2015-05-14T08:36:27","guid":{"rendered":"http:\/\/www.uut8.com\/?p=209"},"modified":"2015-05-14T16:36:27","modified_gmt":"2015-05-14T08:36:27","slug":"phpexcel%e8%af%bb%e5%8f%96excel%e6%96%87%e4%bb%b6%e7%a4%ba%e4%be%8b","status":"publish","type":"post","link":"https:\/\/www.uut8.com\/?p=209","title":{"rendered":"PHPExcel\u8bfb\u53d6excel\u6587\u4ef6\u793a\u4f8b"},"content":{"rendered":"<p>PHPExcel\u662f\u4e00\u4e2a\u975e\u5e38\u65b9\u4fbf\u751f\u6210Excel\u683c\u5f0f\u6587\u4ef6\u7684\u7c7b,\u5b98\u65b9\u4e0b\u8f7d\u5305\u4e2d\u5e26\u6709\u5927\u91cf\u5982\u4f55\u751f\u6210\u5404\u79cd\u6837\u5f0fexcel\u6587\u4ef6\u7684\u793a\u4f8b,\u4f46\u6ca1\u6709\u4e00\u4e2a\u8bfb\u53d6Excel\u6587\u4ef6\u7684\u5b8c\u6574\u4f8b\u5b50.Xiaoqiang\u6839\u636e\u7f51\u4e0a\u7684\u8d44\u6599,\u6574\u7406\u4e86\u4e00\u4efd\u7b80\u5355\u8bfb\u53d6Excel\u6587\u4ef6\u7684\u4f8b\u5b50.<br \/>\n\u4f20\u7edf\u65b9\u6cd5:<\/p>\n<div>\n<pre class=\"io-enlighter-pre\"><code class=\"code\" data-enlighter-language=\"php\" data-enlighter-linenumbers=\"true\" data-enlighter-lineoffset=\"\" data-enlighter-highlight=\"\">\/**\n *\n * @copyright 2007-2012 Xiaoqiang.\n * @authorXiaoqiang.Wu &lt;jamblues@gmail.com&gt;\n * @version 1.01\n *\/\n \nerror_reporting(E_ALL);\n \ndate_default_timezone_set('Asia\/ShangHai');\n \n\/** PHPExcel_IOFactory *\/\nrequire_once '..\/Classes\/PHPExcel\/IOFactory.php';\n \n \n\/\/ Check prerequisites\nif (!file_exists(\"31excel5.xls\")) {\n    exit(\"not found 31excel5.xls.\\n\");\n}\n \n$reader = PHPExcel_IOFactory::createReader('Excel5'); \/\/\u8bbe\u7f6e\u4ee5Excel5\u683c\u5f0f(Excel97-2003\u5de5\u4f5c\u7c3f)\n$PHPExcel = $reader-&gt;load(\"31excel5.xls\"); \/\/ \u8f7d\u5165excel\u6587\u4ef6\n$sheet = $PHPExcel-&gt;getSheet(0); \/\/ \u8bfb\u53d6\u7b2c\u4e00\u500b\u5de5\u4f5c\u8868\n$highestRow = $sheet-&gt;getHighestRow(); \/\/ \u53d6\u5f97\u603b\u884c\u6570\n$highestColumm = $sheet-&gt;getHighestColumn(); \/\/ \u53d6\u5f97\u603b\u5217\u6570\n$highestColumm= PHPExcel_Cell::columnIndexFromString($colsNum); \/\/\u5b57\u6bcd\u5217\u8f6c\u6362\u4e3a\u6570\u5b57\u5217 \u5982:AA\u53d8\u4e3a27\n \n\/** \u5faa\u73af\u8bfb\u53d6\u6bcf\u4e2a\u5355\u5143\u683c\u7684\u6570\u636e *\/\nfor ($row = 1; $row &lt;= $highestRow; $row++){\/\/\u884c\u6570\u662f\u4ee5\u7b2c1\u884c\u5f00\u59cb\n    for ($column = 0; $column &lt; $highestColumm; $column++) {\/\/\u5217\u6570\u662f\u4ee5\u7b2c0\u5217\u5f00\u59cb\n        $columnName = PHPExcel_Cell::stringFromColumnIndex($column);\n        echo $columnName.$row.\":\".$sheet-&gt;getCellByColumnAndRow($column, $row)-&gt;getValue().\"&lt;br \/&gt;\";\n    }\n}\n \n\n\n\u7cbe\u7b80\u65b9\u6cd5:\n\n\/**\n *\n * @copyright 2007-2012 Xiaoqiang.\n * @author Xiaoqiang.Wu &lt;jamblues@gmail.com&gt;\n * @version 1.01\n *\/\n \nerror_reporting(E_ALL);\n \ndate_default_timezone_set('Asia\/ShangHai');\n \n\/** PHPExcel_IOFactory *\/\nrequire_once '..\/Classes\/PHPExcel\/IOFactory.php';\n \n \n\/\/ Check prerequisites\nif (!file_exists(\"31excel5.xls\")) {\n    exit(\"not found 31excel5.xls.\\n\");\n}\n \n$reader = PHPExcel_IOFactory::createReader('Excel5'); \/\/\u8bbe\u7f6e\u4ee5Excel5\u683c\u5f0f(Excel97-2003\u5de5\u4f5c\u7c3f)\n$PHPExcel = $reader-&gt;load(\"31excel5.xls\"); \/\/ \u8f7d\u5165excel\u6587\u4ef6\n$sheet = $PHPExcel-&gt;getSheet(0); \/\/ \u8bfb\u53d6\u7b2c\u4e00\u500b\u5de5\u4f5c\u8868\n$highestRow = $sheet-&gt;getHighestRow(); \/\/ \u53d6\u5f97\u603b\u884c\u6570\n$highestColumm = $sheet-&gt;getHighestColumn(); \/\/ \u53d6\u5f97\u603b\u5217\u6570\n \n\/** \u5faa\u73af\u8bfb\u53d6\u6bcf\u4e2a\u5355\u5143\u683c\u7684\u6570\u636e *\/\nfor ($row = 1; $row &lt;= $highestRow; $row++){\/\/\u884c\u6570\u662f\u4ee5\u7b2c1\u884c\u5f00\u59cb\n    for ($column = 'A'; $column &lt;= $highestColumm; $column++) {\/\/\u5217\u6570\u662f\u4ee5A\u5217\u5f00\u59cb\n        $dataset[] = $sheet-&gt;getCell($column.$row)-&gt;getValue();\n        echo $column.$row.\":\".$sheet-&gt;getCell($column.$row)-&gt;getValue().\"&lt;br \/&gt;\";\n    }\n}<\/code><\/pre>\n<p>\u8fd9\u8fb9\u6587\u7ae0\u662f\u8f6c\u8fc7\u6765\u7684 \u539f\u6587\u5730\u5740http:\/\/www.imhdr.com\/1332\/<br \/>\n\u5b57\u6bcd\u5217\u8f6c\u6362\u4e3a\u6570\u5b57\u5217\u8fd9\u4e2a\u65b9\u6cd5\u5c31\u662f\u6211\u5f53\u65f6\u9047\u5230\u7684\u95ee\u9898\u3002<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>PHPExcel\u662f\u4e00\u4e2a\u975e\u5e38\u65b9\u4fbf\u751f\u6210Excel\u683c\u5f0f\u6587\u4ef6\u7684\u7c7b,\u5b98&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.uut8.com\/index.php?rest_route=\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.uut8.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uut8.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uut8.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uut8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=209"}],"version-history":[{"count":0,"href":"https:\/\/www.uut8.com\/index.php?rest_route=\/wp\/v2\/posts\/209\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.uut8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uut8.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uut8.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}