{"id":436,"date":"2015-12-27T15:18:35","date_gmt":"2015-12-27T07:18:35","guid":{"rendered":"http:\/\/writingbaby.com\/?p=20"},"modified":"2015-12-27T15:18:35","modified_gmt":"2015-12-27T07:18:35","slug":"php-duiphpexcel-de-yi-xie-jian-dan-de-li-jie","status":"publish","type":"post","link":"https:\/\/ihongchao.com\/post\/436\/","title":{"rendered":"\u3010php\u3011\u5bf9PHPExcel\u4e00\u4e9b\u7b80\u5355\u7684\u7406\u89e3"},"content":{"rendered":"

\u8fd9\u91cc\u6709\u5173\u4e8eexcel\u6587\u4ef6\u7684\u51e0\u4e2a\u6982\u5ff5\u9700\u8981\u8ddf\u5927\u5bb6\u8bf4\u660e\u4e00\u4e0b\uff0c\u8fd9\u51e0\u4e2a\u6982\u5ff5\u5bf9\u4e8e\u6211\u4eec\u7684\u540e\u7eed\u7f16\u7a0b\u662f\u5f88\u6709\u5e2e\u52a9\u7684\uff1a<\/span>
\n 1.\u5de5\u4f5c\u7c3f\uff1a\u5728excel\u73af\u5883\u4e2d\u7528\u6765\u5b58\u50a8\u6570\u636e\u5e76\u5904\u7406\u6570\u636e\u7684\u6587\u4ef6\uff0c\u53c8\u79f0\u4e3aexcel\u6587\u4ef6\u6216excel\u6587\u6863\uff0c<\/span>
\n \u5728\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u4e2d\uff0c\u53ef\u4ee5\u62e5\u6709\u591a\u5f20\u4e0d\u540c\u7c7b\u578b\u7684\u5de5\u4f5c\u8868\uff0c\u65e0\u8bba\u6709\u591a\u5c11\u5f20\u5de5\u4f5c\u8868\uff0c\u5728\u5c06\u5176\u4fdd\u5b58\u65f6\uff0c\u90fd\u5c06\u4f1a\u4fdd\u5b58\u5728\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\uff0c\u800c\u4e0d\u662f\u6309\u7167\u5de5\u4f5c\u8868\u7684\u4e2a\u6570\u6765\u4fdd\u5b58\u7684<\/span>
\n \u5728\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6bcf\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4f1a\u5305\u542b\u4e09\u4e2a\u5de5\u4f5c\u8868\u6587\u4ef6\uff1asheet1\uff0csheet2\uff0csheet3<\/span><\/p>\n

2.\u5de5\u4f5c\u8868\uff1a\u662f\u7531\u591a\u884c\u548c\u591a\u5217\u6240\u6784\u6210\u7684\u4e00\u4e2a\u4e8c\u7ef4\u8868\u683c\uff0c\u884c\u53f7\u7684\u7f16\u53f7\u662f\u81ea\u4e0a\u800c\u4e0b\u4ece1\u5f00\u59cb\uff0c\u5217\u53f7\u5219\u4ece\u5de6\u5230\u53f3\u91c7\u7528\u5b57\u6bcd\u7f16\u53f7\uff0c\u4eceA\u5f00\u59cb<\/span><\/p>\n

3.\u5355\u5143\u683c\uff1a\u884c\u5750\u6807\u548c\u5217\u5750\u6807\u505a\u6307\u5b9a\u7684\u4f4d\u7f6e\uff0c\u79f0\u4e3a\u5355\u5143\u683c\uff0c\u5217\u540d\u548c\u884c\u53f7\u505a\u7ec4\u6210\u7684\u540d\u79f0\u4e3a\u5355\u5143\u683c\u540d\u79f0<\/span><\/p>\n

\u5927\u5bb6\u597d\uff0c\u5229\u7528\u8fd9\u4e2a\u65f6\u95f4\uff0c\u5e26\u9886\u5927\u5bb6\u5b66\u4e60excel\u62a5\u8868\u6280\u672f\u5728\u4f01\u4e1a\u9879\u76ee\u4e2d\u7684\u4f7f\u7528\u3002<\/span><\/p>\n

\u5728\u7f51\u7ad9\u7684\u7ba1\u7406\u540e\u53f0\u7ecf\u5e38\u4f1a\u4f7f\u7528\u5230\u62a5\u8868\u7684\u751f\u6210\u548c\u8bfb\u53d6\uff0c\u5176\u4e2dExcel\u662f\u6700\u4e3a\u5e38\u89c1\u7684\u62a5\u8868\u683c\u5f0f\u4e4b\u4e00\uff0c\u4eca\u5929\u6211\u4eec\u5c31\u6765\u5b66\u4e60\u5728php\u4e2d\u7684\u5982\u4f55\u64cd\u4f5cExcel\u62a5\u8868\u3002<\/span><\/p>\n

\u5728\u6b63\u5f0f\u5b66\u4e60\u4e4b\u524d\uff0c\u6211\u4eec\u5148\u6765\u6f14\u793a\u4e00\u4e0bexcel\u62a5\u8868\u6280\u672f\u5728\u771f\u5b9e\u9879\u76ee\u4e2d\u7684\u4f7f\u7528\u6848\u4f8b\uff1f<\/span>
\n \u6848\u4f8b1\uff1aexcel\u62a5\u8868\u6280\u672f\u5728\u7535\u5b50\u7a0e\u52a1\u7cfb\u7edf\u4e2d\u7684\u4f7f\u7528<\/span>
\n \u2460\u7edf\u8ba1\u7eb3\u7a0e\u4eba\u6bcf\u4e00\u9879\u7a0e\u52a1\u7684\u7eb3\u7a0e\u60c5\u51b5:\u57ce\u5e02\u7ef4\u62a4\u5efa\u8bbe\u7a0e\uff0c\u4f01\u4e1a\u6240\u5f97\u7a0e\u7b49<\/span><\/p>\n

\u5728php\u4e2d\u751f\u6210excel\u62a5\u8868\u6587\u4ef6\uff0c\u4e3b\u8981\u662f\u901a\u8fc7header()\u5411\u6d4f\u89c8\u5668\u53d1\u9001\u5934\u4fe1\u606f\u6765\u5b8c\u6210\u7684<\/span><\/p>\n

php\u751f\u6210Excel\u62a5\u8868\u6587\u4ef6\u7684\u65b9\u5f0f\u6709\u5982\u4e0b\u51e0\u79cd\uff1a<\/span><\/p>\n

\u597d\uff0c\u73b0\u5728\u6211\u4eec\u5c31\u901a\u8fc7php\u7a0b\u5e8f\u6765\u751f\u6210\u4e00\u4e2a\u7b80\u5355excel\u6587\u4ef6<\/span><\/p>\n

\u6848\u4f8b\uff1a<\/span><\/p>\n

 \/\/\u9996\u5148\uff0c\u5728php\u6587\u4ef6\u7684\u5f00\u5934\uff0c\u901a\u8fc7header()\u5b9a\u4e49\u8f93\u51fa\u7684\u6587\u4ef6\u7c7b\u578b\u4e3aexcel\u6587\u4ef6\n \/\/\u5b9a\u4e49\u8f93\u51fa\u7684\u6587\u4ef6\u7c7b\u578b\uff0c\u8868\u793a\u8f93\u51fa\u7684\u662f\u4e00\u4e2aexcel\u6587\u4ef6\n header(\"Content-type:application\/vnd.ms-excel\");\n \/\/\u5b9a\u4e49\u8f93\u51fa\u7684\u6587\u4ef6\u540d\uff0c\u8868\u793a\u8f93\u51fa\u7684\u6587\u4ef6\u540d\u4e3atest.xls,\u5982\u679c\u6587\u4ef6\u540d\u4e3a\u4e2d\u6587\uff0c\u7528iconv\u51fd\u6570\u8fdb\u884c\u8f6c\u7801\n header(\"Content-Disposition:filename=test.xls\");<\/span><\/pre>\n
\/\/\u4e3a\u4ec0\u4e48\u8981\u52a0\\t\u548c\\n\u5462\uff1f\u4e3b\u8981\u662f\u901a\u8fc7\u7a0b\u5e8f\u7684\u624b\u6bb5\u6765\u6a21\u62dftable\u952e\u548c\u56de\u8f66\u952e\n echo \"test1\\t\";\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/\u00a0 \\t:table\u952e \uff0c\u901a\u8fc7\u7a0b\u5e8f\u7684\u624b\u6bb5\u6765\u6a21\u62dftable\u952e\u548c\u56de\u8f66\u952e\u7684\u6309\u4e0b\n echo \"test2\\t\\n\";\u00a0\u00a0 \u00a0\/\/\u00a0\u00a0 \u00a0\\t\\n:table\u952e\u5e76\u6362\u884c<\/span><\/pre>\n
echo \"test1\\t\";\n echo \"test2\\t\\n\";<\/span><\/pre>\n
echo \"test1\\t\";\n echo \"test2\\t\\n\";<\/span><\/pre>\n
echo \"test1\\t\";\n echo \"test2\\t\\n\";<\/span><\/pre>\n
echo \"test1\\t\";\n echo \"test2\\t\\n\";<\/span><\/pre>\n
echo \"test1\\t\";\n echo \"test2\\t\\n\";<\/span><\/pre>\n
\/\/\u5176\u5b9e\u5728\u5927\u90e8\u5206\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u5c06\u6570\u636e\u4ece\u6570\u636e\u5e93\u4e2d\u53d6\u51fa\uff0c\u7136\u540e\u6309\u7167\u6bcf\u4e00\u5217\u6570\u636e\u7ed3\u675f\u540e\u52a0\\t,\u6bcf\u4e00\u884c\u6570\u636e\u7ed3\u675f\u540e\u52a0\\n\u7684\u65b9\u6cd5echo\u51fa\u6765<\/span><\/pre>\n
\/\/\u7ed9excel\u8868\u683c\u7684\u6bcf\u4e00\u5217\u6dfb\u52a0\u4e00\u4e2a\u6807\u9898\n echo \"ID\\t\";\n echo \"\u5ba2\u6237\u7b80\u79f0\\t\";\n echo \"\u5ba2\u6237\u5168\u540d\\t\";\n echo \"\u8054\u7cfb\u4eba\\t\";\n echo \"\u8054\u7cfb\u7535\u8bdd\\t\";\n echo \"\u4f20\u771f\\t\";\n echo \"\u5730\u5740\\t\\n\";<\/span><\/pre>\n
mysql_connect(\"localhost\",\"root\",\"\");\n mysql_select_db(\"jxc2008\");\n mysql_query(\"set names 'utf8'\");\n $sql=\"select * from kehu order by id desc\";\n $rec=mysql_query($sql);\/\/\u8fd4\u56de\u4e00\u4e2a\u7ed3\u679c\u96c6\n $row_num=mysql_num_rows($rec);\/\/\u7ed3\u679c\u96c6\u4e2d\u7684\u884c\u6570\n $col_num=mysql_num_fields($rec);\/\/\u7ed3\u679c\u96c6\u4e2d\u7684\u5217\u6570<\/span><\/pre>\n
while($row=mysql_fetch_array($rec)){\/\/\u4ece\u7ed3\u679c\u96c6\u4e2d\u9010\u884c\u83b7\u53d6\u8bb0\u5f55\n \u00a0\u00a0 \u00a0for($col=0;$col<$col_num;$col++){ \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if($col==($col_num-1)){\/\/excel\u6587\u4ef6\u4e2d\u5217\u7684\u6570\u5b57\u7f16\u53f7\u4ece0\u5f00\u59cb\uff0c\u603b\u5217\u6570-1 \u5bf9\u5e94excel\u6587\u4ef6\u4e2d\u6700\u5927\u5217\u7684\u7f16\u53f7 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo $row[$col].\"\\t\\n\";\/\/\u5982\u679c\u662f\u6700\u540e\u4e00\u5217\uff0c\u52a0\u4e0a \\n \u6765\u6a21\u62df\u56de\u8f66\u952e \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}else{ \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo $row[$col].\"\\t\";\/\/\u6bcf\u4e00\u884c\u6570\u636e\u9010\u5217\u8f93\u51fa\u5230excel\u6587\u4ef6\u5355\u5143\u683c\u4e2d\uff0c\u4e0d\u662f\u6700\u540e\u4e00\u5217\u65f6\uff0c\u52a0\u4e0a \\t \u6765\u6a21\u62dftab\u952e \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0} \u00a0\u00a0 \u00a0} } ?><\/span><\/pre>\n
\u901a\u8fc7\u8fd0\u884c\u5982\u4e0b\u7a0b\u5e8f\uff0c\u5c31\u751f\u6210\u4e86\u4e00\u4e2a\u7b80\u5355\u7684excel\u6587\u4ef6\u3002\u901a\u8fc7\u8fd9\u79cd\u65b9\u5f0f\u6765\u751f\u6210excel\u6587\u4ef6\u5462\uff0c\u6709\u4ed6\u7684\u4f18\u70b9\uff0c\u4e5f\u6709\u4ed6\u7684\u7f3a\u70b9\uff1a<\/span>
\n \u4f18\u70b9\uff1a\u4e0a\u9762\u8fd9\u79cd\u683c\u5f0f\uff0c\u76f8\u5bf9\u6bd4\u8f83\u7b80\u5355\uff0c\u56e0\u4e3a\u6bd4\u8f83\u5355\u4e00<\/span>
\n \u7f3a\u70b9\uff1a\u5bf9\u4e8e\u63a7\u5236\u751f\u6210\u7684excel\u8868\u683c\u6837\u5f0f\u5f88\u4e0d\u65b9\u4fbf\uff0c\u8bfb\u53d6excel\u6587\u4ef6\u548c\u4e0d\u65b9\u4fbf<\/span>
\n \u6848\u4f8b\uff1a\u901a\u8fc7<\/span><\/p>\n
\u8868\u683c\u7684\u65b9\u5f0f\u6765\u751f\u6210\u4e00\u4e2aexcel\u6587\u4ef6\uff1a\u7701\u7565<\/span><\/p>\n
\u7f3a\u70b9\uff1a\u66f4\u590d\u6742\u70b9\u7684\u62a5\u8868\u5c31\u8981\u9ebb\u70e6\u70b9\u4e86\uff0c\u8981\u5728\u6a21\u677f\u4e2d\u4e00\u4e2a\u4e2a\u5355\u5143\u683c\u81ea\u5df1\u53bb\u653e\u7f6e StyleID \u503c<\/span><\/p>\n
\u95ee\u9898\uff1a\u867d\u7136\u4f7f\u7528php\u7684header()\u53ef\u4ee5\u76f4\u63a5\u751f\u6210excel\uff0c\u4f46\u662f\u5bf9\u4e8e\u63a7\u5236\u751f\u6210\u7684excel\u6837\u5f0f\uff08\u5982\uff1a\u5c45\u4e2d\u5bf9\u9f50\uff0c\u80cc\u5f71\u989c\u8272\u7b49\uff09\u662f\u5f88\u4e0d\u65b9\u4fbf\u7684\uff0c\u6240\u4ee5\u8fd9\u91cc\u63a8\u8350\u4e00\u4e2a\u6700\u4e3a\u6d41\u884c\u7684Excel\u7c7b\u5e93-PHPExcel<\/span><\/p>\n
PHPExcel\u7c7b\u5e93\u662f\u4e00\u4e2a\u975e\u5e38\u5f3a\u5927\u7684php\u7c7b\u5e93\uff0c\u57fa\u672c\u4e0a\u80fd\u89e3\u51b3\u4e00\u5207\u7684excel\u95ee\u9898,\u4f01\u4e1a\u4e2d\u5bf9excel\u62a5\u8868\u7684\u5904\u7406\u5927\u591a\u662f\u91c7\u7528\u6b64\u7c7b\u5e93\u6765\u5b8c\u6210\u7684<\/span><\/p>\n
\u6b64\u7c7b\u5e93\u53ef\u5230\u5176\u5b98\u7f51 http:\/\/www.codeplex.com\/PHPExcel \u53bb\u4e0b\u8f7d\uff0c\u76ee\u524d\u6700\u65b0\u7248\u672c\u4e3a1.7.7\uff0c\u6211\u8fd9\u91cc\u5df2\u7ecf\u5c06\u5176\u4e0b\u8f7d\u4e0b\u6765\u4e86\uff0c<\/span><\/p>\n
\u5c06\u5176\u89e3\u538b\u5230\u6211\u7684web\u5e94\u7528\u4e2d\uff0c\u89e3\u538b\u540e\u53d1\u73b0\u91cc\u9762\u6709\u4e09\u4e2a\u6587\u4ef6\u5939\uff1a<\/span>
\n classess\uff1a\u6b64\u6587\u4ef6\u5939\u4e2d\u662fPHPExcel\u6838\u5fc3\u7c7b\u5e93\u6587\u4ef6\uff0c\u6211\u4eec\u5bf9excel\u62a5\u8868\u7684\u5904\u7406\u90fd\u662f\u901a\u8fc7\u6b64\u6587\u4ef6\u5939\u4e2d\u7684\u7c7b\u6587\u4ef6\u6765\u5b8c\u6210\u7684\uff0c\u6ce8\u610f\uff1a\u6240\u6709\u7684\u7c7b\u540d\u90fd\u662f\u4ee5PHPExcel_*\u5f00\u5934\u7684<\/span>
\n \u7279\u70b9\uff1a\u6240\u6709\u7684\u6587\u4ef6\u90fd\u662f\u4e00\u4e2a\u7c7b<\/span>
\n \u6240\u6709\u7684\u7c7b\u540d\u90fd\u662f\u4ee5PHPExcel_*\u5f00\u5934<\/span>
\n Documentation\uff1a\u8fd9\u4e2a\u6587\u4ef6\u5939\u4e2d\u5b58\u653e\u7684\u662fPHPExcel\u7c7b\u5e93\u7684\u82f1\u6587\u8bf4\u660e\u6587\u6863<\/span>
\n Tests\uff1a\u662f\u4e00\u4e9b\u5c0f\u7684\u6d4b\u8bd5\u6848\u4f8b\uff0c\u8fd9\u4e9b\u5c0f\u6848\u4f8b\u5bf9\u4e8e\u6211\u4eec\u5165\u95e8\u662f\u975e\u5e38\u6709\u5e2e\u52a9\u7684<\/span><\/p>\n
\u9996\u5148\uff0c\u6211\u4eec\u6253\u5f00\u4e00\u4e2a\u6d4b\u8bd5\u6587\u4ef6\u6765\u5feb\u901f\u4f53\u9a8c\u4e00\u628a\u3002\u6267\u884c\u6d4b\u8bd5\u6587\u4ef6\u540e\u3002\u4f1a\u63d0\u793a\u6211\u4eec\u8fdb\u884c\u4e0b\u8f7d<\/span><\/p>\n
\u8fd9\u91cc\u6709\u5173\u4e8eexcel\u6587\u6863\u7684\u4e24\u4e2a\u6982\u5ff5\u9700\u8981\u8ddf\u5927\u5bb6\u89e3\u91ca\u4e00\u4e0b\uff1a<\/span>
\n \u5de5\u4f5c\u7c3f\uff1a\u5305\u542b\u591a\u4e2a\u5de5\u4f5c\u8868\u7684excel\u6587\u6863\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u5de5\u4f5c\u7c3f==excel\u6587\u6863\uff0c\u6211\u4eec\u6240\u5efa\u7acb\u7684excel\u6587\u6863\u7684\u540d\u79f0\u5c31\u662f\u5de5\u4f5c\u7c3f\u7684\u540d\u79f0<\/span>
\n \u5de5\u4f5c\u8868\uff1a\u6709\u884c\u6709\u5217\u7684\u4e8c\u7ef4\u8868\uff0c\u591a\u4e2a\u5de5\u4f5c\u8868\u7ec4\u6210\u4e86\u4e00\u4e2a\u5de5\u4f5c\u7c3f<\/span><\/p>\n
\u597d\uff0c\u77e5\u9053\u4e86\u8fd9\u4e9b\u5462\uff0c\u6211\u4eec\u5c31\u6765\u89e3\u8bfb\u4e00\u4e0b\u8fd9\u4e2aphp\u6d4b\u8bd5\u6587\u4ef6<\/span><\/p>\n
PHPExcel\u5b9e\u73b0\u4e86autoloader\u81ea\u52a8\u52a0\u8f7d\u673a\u5236\uff0c\u8fd9\u610f\u5473\u7740\u6211\u4eec\u4e0d\u9700\u8981\u5f15\u5165PHPExcel\u6587\u4ef6\u5939\u4e0b\u7684\u6bcf\u4e2a\u7c7b\u5e93\u6587\u4ef6\uff0c\u53ea\u9700\u8981\u5728\u6587\u4ef6\u4e2d\u5f15\u5165PHPExcel\u521d\u59cb\u5316\u7c7b\u5e93\u6587\u4ef6\u5c31\u53ef\u4ee5\u4e86\uff0c\u81ea\u52a8\u52a0\u8f7d\u7c7b\uff0c\u5c06\u81ea\u52a8\u5f15\u5165\u5176\u5b83\u9700\u8981\u7684\u7c7b\u5e93\u6587\u4ef6<\/span><\/p>\n
\u4e3a\u4e86\u7b80\u5316PHPExcel\u7c7b\u7684\u6982\u5ff5\uff0cPHPExcel\u7c7b\u4ee3\u8868\u4f60\u7684\u5de5\u4f5c\u7c3f<\/span><\/p>\n
\u5bf9\u4e8e\u5e38\u89c1\u7684excel\u62a5\u8868\u64cd\u4f5c\uff0c\u6211\u4eec\u9700\u8981\u638c\u63e1\u5982\u4e0b\u51e0\u4e2a\u7c7b\u5e93\u5c31\u53ef\u4ee5\u4e86\uff1a<\/span>
\n 1.\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u7c7b\uff1aPHPExcel<\/span>
\n 2.\u5de5\u4f5c\u8868\u5bf9\u8c61\u7c7b\uff1aPHPExcel_WorkSheet<\/span>
\n 3.\u6837\u5f0f\u5bf9\u8c61\u7c7b:PHPExcel_Style<\/span>
\n 4.\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61\u7c7b:PHPExcel_Style_Alignment<\/span>
\n 5.\u5b57\u4f53\u5bf9\u8c61\u7c7b:PHPExcel_Style_Font<\/span>
\n 6.\u989c\u8272\u5bf9\u8c61\u7c7b:PHPExcel_Style_Color<\/span>
\n 7.\u5355\u5143\u683c\u7c7b:PHPExcel_Cell<\/span>
\n 8.\u8bfb\u5199\u6587\u4ef6\u7684\u7c7b:PHPExcel_IOFactory<\/span>
\n 9.\u8bfb\u6587\u4ef6\u7684\u7c7b:PHPExcel_Reader_Excel5<\/span>
\n 10.\u5199\u6587\u4ef6\u7684\u7c7b:PHPExcel_Writer_Excel5<\/span><\/p>\n
\u5927\u5bb6\u53ef\u4ee5\u770b\u7684\u51fa\u6765\uff0c\u6211\u5199\u7684\u6709\u4e00\u5b9a\u7684\u5c42\u7ea7\u5173\u7cfb\uff0c\u4e3a\u4ec0\u4e48\u8fd9\u4e48\u5199\u5462\uff1f\u662f\u56e0\u4e3a\u5728\u5f88\u591a\u60c5\u51b5\u4e0b\u4f4e\u5c42\u7ea7\u7684\u7c7b\u4f9d\u8d56\u4e8e\u5176\u4e0a\u4e00\u5c42\u7ea7\u7684\u7c7b<\/span><\/p>\n
\u5bf9\u4e8e\u5e38\u89c1\u7684excel\u62a5\u8868\u64cd\u4f5c\uff0c\u6211\u4eec\u9700\u8981\u638c\u63e1\u5982\u4e0b\u51e0\u4e2a\u7c7b\u5e93\u5c31\u53ef\u4ee5\u4e86\uff1a<\/span><\/p>\n
\uff081\uff09PHPExcel\uff1a\u5de5\u4f5c\u7c3f\u5bf9\u8c61<\/span><\/p>\n
excel\u6587\u6863\u5904\u7406\u5bf9\u8c61\u4e3b\u8981\u7528\u6765\u7ba1\u7406\u6211\u4eec\u7684excel\u6587\u6863\uff0c\u600e\u4e48\u6765\u7ba1\u7406\uff08\u901a\u8fc7\u5c5e\u6027\u548c\u65b9\u6cd5\u6765\u7ba1\u7406\uff09\uff1f\u5927\u5bb6\u77e5\u9053\uff0c\u7c7b\u4e3b\u8981\u662f\u7531\u5c5e\u6027\u548c\u65b9\u6cd5\u6765\u7ec4\u6210\uff0c\u901a\u8fc7php\u7a0b\u5e8f\u7684\u624b\u6bb5\u6765\u7ba1\u7406excel\u6587\u6863\uff0c\u5176\u5b9e\u5c31\u662f\u901a\u8fc7\u672c\u5bf9\u8c61\u7684\u5c5e\u6027\u548c\u65b9\u6cd5\u6765\u7ba1\u7406\uff0c\u4e0b\u9762\u6211\u4eec\u5c31\u6765\u770b\u4e00\u4e0bPHPExcel\u7c7b\u4e2d\u90fd\u6709\u90a3\u4e9b\u5c5e\u6027\u548c\u65b9\u6cd5\uff0c\u8fd9\u4e9b\u5c5e\u6027\u548c\u65b9\u6cd5\u4e3b\u8981\u7528\u6765\u7ba1\u7406excel\u6587\u6863\u7684\u90a3\u4e9b\u65b9\u9762<\/span><\/p>\n
getProperties()\uff1a\u83b7\u5f97\u5f53\u524d\u6d3b\u52a8\u72b6\u6001\u5de5\u4f5c\u8868\u7684\u5c5e\u6027\u5bf9\u8c61\uff0c\u8fd4\u56de\u5c5e\u6027\u5bf9\u8c61<\/span>
\n getActiveSheet()\uff1a\u83b7\u5f97\u5f53\u524d\u6d3b\u52a8\u72b6\u6001\u7684\u5de5\u4f5c\u8868\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n getActiveSheetIndex()\uff1a\u83b7\u5f97\u5f53\u524d\u6d3b\u52a8\u72b6\u6001\u5de5\u4f5c\u8868\u7684\u7d22\u5f15\u503c\uff0c\u8fd4\u56deint<\/span>
\n setActiveSheetIndex()\uff1a\u8bbe\u7f6e\u5f53\u524d\u6d3b\u52a8\u72b6\u6001\u5de5\u4f5c\u8868\u7684\u7d22\u5f15\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n getSheetByName()\uff1a\u901a\u8fc7\u5de5\u4f5c\u8868\u540d\u79f0\u5f97\u5230\u5f53\u524d\u5de5\u4f5c\u8868\u5bf9\u8c61\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n getDefaultStyle()\uff1a\u83b7\u5f97excel\u6587\u6863\u9ed8\u8ba4\u7684\u6837\u5f0f\uff08\u6240\u6709\u5de5\u4f5c\u8868\u7684\u6837\u5f0f\uff09\uff0c\u8fd4\u56de\u6837\u5f0f\u5bf9\u8c61<\/span>
\n createSheet():\u5728\u5f53\u524d\u6d3b\u52a8\u5de5\u4f5c\u8868\u540e\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5de5\u4f5c\u8868<\/span>
\n getSheetCount()\uff1a\u83b7\u5f97excel\u6587\u6863\u4e2d\u5de5\u4f5c\u8868\u7684\u6570\u91cf\uff0c\u8fd4\u56deint<\/span>
\n getSheetNames()\uff1a\u83b7\u5f97excel\u6587\u6863\u4e2d\u6240\u6709\u5de5\u4f5c\u8868\u540d\u79f0\u7ec4\u6210\u7684\u6570\u7ec4<\/span><\/p>\n
\uff082\uff09PHPExcel_Worksheet\uff1a\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span><\/p>\n
\u5de5\u4f5c\u8868\u5bf9\u8c61\uff0c\u4e3b\u8981\u7528\u6765\u7ba1\u7406\u6211\u4eec\u7684\u5de5\u4f5c\u8868\uff0c\u600e\u4e48\u7ba1\u7406\uff1f\u4e5f\u662f\u901a\u8fc7\u5c5e\u6027\u548c\u65b9\u6cd5\u6765\u7ba1\u7406\uff0c\u4f46\u662f\u5de5\u4f5c\u8868\u5bf9\u8c61\u5927\u90e8\u5206\u60c5\u51b5\u4e0b\u53ef\u901a\u8fc7excel\u6587\u6863\u5bf9\u8c61\u6765\u83b7\u53d6<\/span><\/p>\n
toArray()\uff1a\u628a\u5de5\u4f5c\u8868\u4e2d\u7684\u6570\u636e\u8f6c\u6362\u6210\u6570\u7ec4<\/span>
\n fromArray():\u4ece\u6570\u7ec4\u4e2d\u83b7\u53d6\u6570\u636e\u586b\u5145\u5230\u5de5\u4f5c\u8868\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n getCell()\uff1a\u83b7\u5f97\u5355\u5143\u683c\u5bf9\u8c61<\/span>
\n getCellByColumnAndRow()\uff1a\u901a\u8fc7\u5217\u7d22\u5f15\u548c\u884c\u7d22\u5f15\u83b7\u5f97\u6307\u5b9a\u5355\u5143\u683c\uff0c\u8fd4\u56de\u5355\u5143\u683c\u5bf9\u8c61<\/span>
\n getDefaultStyle()\uff1a\u83b7\u5f97\u5de5\u4f5c\u8868\u9ed8\u8ba4\u7684\u6837\u5f0f\uff0c\u8fd4\u56de\u6837\u5f0f\u5bf9\u8c61<\/span>
\n getHighestColumn()\uff1a\u83b7\u5f97\u5de5\u4f5c\u8868\u7684\u6700\u5927\u5217\uff0c\u8fd4\u56de\u5217\u7684\u540d\u79f0<\/span>
\n getColumnDimension():\u83b7\u5f97\u5f53\u524d\u5217<\/span>
\n getStyle():\u83b7\u5f97\u6307\u5b9a\u5355\u5143\u683c\u7684\u6837\u5f0f\uff0c\u8fd4\u56de\u6837\u5f0f\u5bf9\u8c61<\/span>
\n getParent()\uff1a\u83b7\u5f97\u7236\u7c7b\u5bf9\u8c61\uff0c\u8fd4\u56deexcel\u6587\u6863\u5bf9\u8c61<\/span>
\n getTitle()\uff1a\u83b7\u5f97\u5de5\u4f5c\u8868\u7684\u6807\u9898\u6216\u540d\u79f0\uff0c\u8fd4\u56de\u5b57\u7b26\u4e32\u7c7b\u578b<\/span>
\n setCellValue():\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u503c\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61\u6216\u5355\u5143\u683c\u5bf9\u8c61\uff0c\u5b8c\u5168\u53d6\u51b3\u4e8e\u53c2\u6570\u7684\u503c<\/span>
\n setCellValueByColumnAndRow()\uff1a\u901a\u8fc7\u5217\u7d22\u5f15\u548c\u884c\u7d22\u5f15\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u503c\uff0c\u8fd4\u56de\u7c7b\u578b\u540c\u4e0a<\/span>
\n setCellValueExplicit()\uff1a\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u503c\uff0c\u5e76\u663e\u793a\u6307\u5b9a\u6570\u636e\u7c7b\u578b\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n setCellValueExplicitByColumnAndRow()\uff1a\u901a\u8fc7\u5217\u548c\u884c\u7d22\u5f15\u8bbe\u7f6e\u5355\u5143\u683c\u503c<\/span>
\n setTitle():\u8bbe\u7f6e\u5de5\u4f5c\u8868\u6807\u9898<\/span><\/p>\n
\uff083\uff09PHPExcel_Cell:\u5355\u5143\u683c\u5bf9\u8c61<\/span><\/p>\n
\uff083\uff09PHPExcel_Style\uff1a\u6837\u5f0f\u5bf9\u8c61\uff0c\u4e3b\u8981\u7528\u6765\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u6837\u5f0f\uff1a\u5bf9\u9f50\u65b9\u5f0f\u3001\u5b57\u4f53\u3001\u8fb9\u6846\u3001\u586b\u5145\u7b49\uff0c\u8ddf\u6211\u4eec\u4e4b\u524d\u5b66\u8fc7\u7684css\u6837\u5f0f\u5dee\u4e0d\u591a\uff0c\u5728\u8fd9\u91cc\u5982\u679c\u60f3\u8981\u8bbe\u7f6e\u5bf9\u9f50\u65b9\u5f0f\u3001\u5b57\u4f53\u5927\u5c0f\u3001\u8fb9\u6846\u989c\u8272\u3001\u7b49\u7b49\u90fd\u662f\u901a\u8fc7\u6837\u5f0f\u5bf9\u8c61\u6765\u5b8c\u6210\u7684<\/span><\/p>\n
getActiveCell()\uff1a\u83b7\u5f97\u5f53\u524d\u6d3b\u52a8\u7684\u5355\u5143\u683c\u7684\u540d\u79f0\uff0c\u8fd4\u56destring\uff1b\u5982\uff0cA1<\/span>
\n getActiveSheet()\uff1a\u83b7\u5f97\u5f53\u524d\u6d3b\u52a8\u7684\u5de5\u4f5c\u8868\uff0c\u8fd4\u56de\u5de5\u4f5c\u8868\u5bf9\u8c61<\/span>
\n getAlignment()\uff1a\u83b7\u5f97\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61\uff0c\u8fd4\u56de\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61<\/span>
\n getBorders()\uff1a\u83b7\u5f97\u8fb9\u6846\u5bf9\u8c61\uff0c\u8fd4\u56de\u8fb9\u6846\u5bf9\u8c61<\/span>
\n getFill()\uff1a\u83b7\u5f97\u586b\u5145\u5bf9\u8c61<\/span>
\n getFont()\uff1a\u83b7\u5f97\u5b57\u4f53\u5bf9\u8c61<\/span>
\n setFont()\uff1a\u8bbe\u7f6e\u5b57\u4f53\uff0c\u8fd4\u56de\u6837\u5f0f\u5bf9\u8c61<\/span><\/p>\n
\uff083\uff09PHPExcel_Style_Alignment\uff1a\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61<\/span><\/p>\n
getHorizontal()\uff1a\u83b7\u5f97\u6c34\u5e73\u5c45\u4e2d\u65b9\u5f0f<\/span>
\n getVertical()\uff1a\u83b7\u5f97\u5782\u76f4\u5c45\u4e2d\u65b9\u5f0f<\/span>
\n setHorizontal()\uff1a\u8bbe\u7f6e\u6c34\u5e73\u5c45\u4e2d\u65b9\u5f0f\uff0c\u8fd4\u56de\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61<\/span>
\n setVertical()\uff1a\u8bbe\u7f6e\u5782\u76f4\u5c45\u4e2d\u65b9\u5f0f\uff0c\u8fd4\u56de\u5bf9\u9f50\u65b9\u5f0f\u5bf9\u8c61<\/span><\/p>\n
\u5c45\u4e2d\u65b9\u5f0f\uff1a<\/span>
\n HORIZONTAL_CENTER<\/span>
\n HORIZONTAL_CENTER_CONTINUOUS<\/span>
\n HORIZONTAL_GENERAL<\/span>
\n HORIZONTAL_JUSTIFY<\/span>
\n HORIZONTAL_LEFT<\/span>
\n HORIZONTAL_RIGHT<\/span>
\n VERTICAL_BOTTOM<\/span>
\n VERTICAL_CENTER<\/span>
\n VERTICAL_JUSTIFY<\/span>
\n VERTICAL_TOP<\/span><\/p>\n
\uff083\uff09PHPExcel_Style_Font\uff1a\u5b57\u4f53\u5bf9\u8c61<\/span><\/p>\n
setBold\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u52a0\u7c97<\/span>
\n setColor\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u989c\u8272<\/span>
\n setItalic\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u503e\u659c<\/span>
\n setName\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u540d<\/span>
\n setSize\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u5927\u5c0f<\/span>
\n setUnderline\uff08\uff09\uff1a\u8bbe\u7f6e\u5b57\u4f53\u4e0b\u5212\u7ebf<\/span><\/p>\n
\uff084\uff09PHPExcel_Writer_Excel5\uff1a\u5199\u64cd\u4f5c\u5bf9\u8c61\uff0c\u4e3b\u8981\u7528\u6765\u8f93\u51faxls\u6587\u4ef6<\/span><\/p>\n
save(\u5de5\u4f5c\u7c3f\u6587\u4ef6\u540d)\uff1a\u5c06\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u4e2d\u7684\u6570\u636e\u4fdd\u5b58\u5230\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d<\/span><\/p>\n
\uff084\uff09PHPExcel_Writer_Excel2007\uff1a\u5199\u64cd\u4f5c\u5bf9\u8c61\uff0c\u4e3b\u8981\u7528\u4e8e\u8f93\u51faxlsx\u6587\u4ef6<\/span><\/p>\n
save(\u5de5\u4f5c\u7c3f\u6587\u4ef6\u540d)\uff1a\u5c06\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u4e2d\u7684\u6570\u636e\u4fdd\u5b58\u5230\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d<\/span><\/p>\n
\uff085\uff09PHPExcel_Reader_Excel5\uff1a\u8bfb\u64cd\u4f5c\u5bf9\u8c61\uff0c\u4e3b\u8981\u7528\u4e8e\u8f93\u5165xls\u6587\u4ef6<\/span><\/p>\n
canRead():\u5f53\u524dreader\u5bf9\u8c61\u662f\u5426\u80fd\u591f\u8bfb\u5de5\u4f5c\u7c3f\u6587\u4ef6<\/span>
\n load():\u4ece\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\u52a0\u8f7d\u5de5\u4f5c\u7c3f\u5bf9\u8c61\uff0c\u4e5f\u5c31\u662f\u5c06\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u52a0\u8f7d\u5230\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u4e2d\u6765\u7ba1\u7406<\/span><\/p>\n
\uff086\uff09PHPExcel_IOFactory\uff1a\u8bfb\u5199\u64cd\u4f5c\u5bf9\u8c61<\/span><\/p>\n
createReader()\uff1a\u6839\u636e\u53c2\u6570\u7684\u4e0d\u540c\uff0c\u521b\u5efa\u4e0d\u540c\u7684\u8bfb\u5bf9\u8c61\uff1a\u4e3b\u8981\u4f5c\u7528\u662f\u8bfb\u53d6\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\u7684\u6570\u636e<\/span><\/p>\n
createWriter()\uff1a\u6839\u636e\u53c2\u6570\u7684\u4e0d\u540c\uff0c\u8fd4\u56de\u4e0d\u540c\u7684\u5199\u5bf9\u8c61\uff1a\u4e3b\u8981\u4f5c\u7528\u662f\u5c06PHPExcel\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u4e2d\u7684\u6570\u636e\u5199\u5165\u5230\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d<\/span><\/p>\n
load():\u4ece\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\u52a0\u8f7dPHPExcel\u5de5\u4f5c\u7c3f\u5bf9\u8c61\uff0c\u5373\uff1a\u5c06\u5de5\u4f5c\u7c3f\u6587\u4ef6\u4e2d\u6570\u636e\u52a0\u8f7d\u5230PHPExcel\u5de5\u4f5c\u7c3f\u5bf9\u8c61\u4e2d\u6765\u7ba1\u7406<\/span><\/p>\n
PHPExcel\u5bf9\u8c61\uff1a\u662f\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u5bf9\u8c61<\/span><\/p>\n
include_once \"PHPExcel\/Writer\/Excel5.php\";\/\/\u4e3b\u8981\u7528\u4e8e\u5176\u5b83\u4f4e\u7248\u672c\uff0c\u4e14\u6587\u4ef6\u540d\u540e\u7f00\u4e3axls\u7684\u6587\u4ef6\uff0c\u5982\u679c\u6211\u4eec\u5e0c\u671b\u751f\u6210\u540e\u7f00\u540d\u4e3axls\u683c\u5f0f\u7684excel\u6587\u4ef6\uff0c\u5efa\u8bae\u5f15\u5165\u6b64\u7c7b\u5e93<\/span><\/pre>\n
include_once \"PHPExcel\/Writer\/Excel2007.php\";\/\/\u4e3b\u8981\u7528\u4e8eexcel2007\u683c\u5f0f\uff0c\u6587\u4ef6\u540d\u540e\u7f00\u4e3axlsx\u7684excel\u6587\u4ef6\uff0c\u5982\u679c\u6211\u4eec\u5e0c\u671b\u751f\u6210\u540e\u7f00\u540d\u4e3axlsx\u683c\u5f0f\u7684excel\u6587\u4ef6\uff0c\u5efa\u8bae\u5f15\u5165\u6b64\u7c7b\u5e93<\/span><\/pre>\n
$objWriter\u00a0=\u00a0new\u00a0PHPExcel_Writer_Excel5($objExcel);\/\/\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\u683c\u5f0f\u5199\u5165\u5bf9\u8c61\u5b9e\u4f8b\uff0c\u6b64\u5bf9\u8c61\u4e3b\u8981\u7528\u6765\u5199\u5165\u5185\u5bb9\u5230\u6307\u5b9a\u683c\u5f0f\u7684\u6587\u4ef6\uff0c\u5982\uff0c\u5199\u5165\u5185\u5bb9\u5230\u540e\u7f00\u540d\u4e3axls\u683c\u5f0f\u7684excel\u6587\u4ef6\u7b49\uff0c\u7528\u4e8e\u5176\u5b83\u677f\u5f0f\u7684\u683c\u5f0f<\/span><\/pre>\n
$objWriter\u00a0=\u00a0new\u00a0PHPExcel_Writer_Excel2007($objExcel);\/\/\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\u683c\u5f0f\u5199\u5165\u5bf9\u8c61\u5b9e\u4f8b\uff0c\u6b64\u5bf9\u8c61\u4e3b\u8981\u7528\u6765\u5199\u5165\u5185\u5bb9\u5230\u6307\u5b9a\u683c\u5f0f\u7684\u6587\u4ef6\uff0c\u5982\uff0c\u5199\u5165\u5185\u5bb9\u5230\u540e\u7f00\u540d\u4e3axls\u683c\u5f0f\u7684excel\u6587\u4ef6\u7b49\uff0c\u7528\u4e8eexcel2007\u683c\u5f0f\n $objWriter->setOffice2003Compatibility(true);\/\/\u517c\u5bb9office2003<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u6587\u6863\u57fa\u672c\u5c5e\u6027\n $objProps\u00a0=\u00a0$objExcel->getProperties();\u00a0\u00a0\/\/\u5f97\u5230PHPExcel_document\u6587\u6863\u5bf9\u8c61\n $objProps->setCreator(\"Zeal\u00a0Li\");\u00a0 \u00a0\u00a0 \u00a0 \/\/\u8bbe\u7f6e\u4f5c\u8005\n $objProps->setLastModifiedBy(\"Zeal\u00a0Li\");\u00a0\/\/\u8bbe\u7f6e\u6700\u540e\u4fee\u6539\u65f6\u95f4\n $objProps->setTitle(\"Office\u00a0XLS\u00a0Test\u00a0Document\");\u00a0\/\/\u8bbe\u7f6e\u6807\u9898\n $objProps->setSubject(\"Office\u00a0XLS\u00a0Test\u00a0Document,\u00a0Demo\");\/\/\u8bbe\u7f6e\u4e3b\u9898\n $objProps->setDescription(\"Test\u00a0document,\u00a0generated\u00a0by\u00a0PHPExcel.\");\/\/\u63cf\n $objProps->setKeywords(\"office\u00a0excel\u00a0PHPExcel\");\u00a0\/\/\u5173\u952e\u5b57\n $objProps->setCategory(\"Test\");\u00a0\/\/\u5206\u7c7b<\/span><\/pre>\n
$objExcel->setActiveSheetIndex(0);\/\/\u8bbe\u7f6e\u7528\u6237\u6253\u5f00excel\u6587\u4ef6\u65f6\uff0c\u770b\u5230\u7684\u9996\u5f20sheet\uff0c\u5982\u679c\u6ca1\u6709\u8bbe\u7f6e\uff0c\u9ed8\u8ba4\u4e3a\u6700\u540e\u4e00\u6b21\u64cd\u4f5c\u7684sheet<\/span><\/pre>\n
$objActSheet->setTitle('\u6d4b\u8bd5Sheet');\/\/\u8bbe\u7f6e\u5f53\u524d\u6d3b\u52a8\u7684\u5de5\u4f5c\u7c3f\u540d\u79f0<\/span><\/pre>\n
\/\/\u6839\u636e\u5355\u5143\u683c\u540d\u79f0\u8bbe\u7f6e\u5355\u5143\u683c\u5185\u5bb9\uff0c\u7531PHPExcel\u6839\u636e\u4f20\u5165\u7684\u5185\u5bb9\u81ea\u52a8\u5224\u65ad\u5355\u5143\u683c\u7684\u5185\u5bb9\u7c7b\u578b\n $objActSheet->setCellValue('A1',\u00a0'\u5b57\u7b26\u4e32\u5185\u5bb9');\u00a0\u00a0\/\/\u00a0\u5b57\u7b26\u4e32\u5185\u5bb9\n $objActSheet->setCellValue('A2',\u00a026);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u00a0\u6570\u503c\n $objActSheet->setCellValue('A3',\u00a0true);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/\u00a0\u5e03\u5c14\u503c\n $objActSheet->setCellValue('A4',\u00a0'=SUM(A2:A2)');\u00a0\/\/\u00a0\u516c\u5f0f<\/span><\/pre>\n
\/\u663e\u5f0f\u6307\u5b9a\u5355\u5143\u683c\u7684\u5185\u5bb9\u7c7b\u578b\u4e3a\u5b57\u7b26\u4e32\u7c7b\u578b\n $objActSheet->setCellValueExplicit('A5','847475847857487584',PHPExcel_Cell_DataType::TYPE_STRING);<\/span><\/pre>\n
\/\/\u5408\u5e76\u5355\u5143\u683c\n $objActSheet->mergeCells('B1:C22');<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5217\u7684\u5bbd\u5ea6\n $objActSheet->getColumnDimension('B')->setAutoSize(true);\n $objActSheet->getColumnDimension('A')->setWidth(30);<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u884c\u7684\u9ad8\u5ea6\n $objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(11.5);<\/span><\/pre>\n
\/\/\u683c\u5f0f\uff1a\u4e3b\u8981\u7528\u6765\u5bf9\u5355\u5143\u683c\u8fdb\u884c\u64cd\u4f5c\uff0c\u5982\uff0c\u8bbe\u7f6e\u5b57\u4f53\u3001\u8bbe\u7f6e\u5bf9\u9f50\u65b9\u5f0f\u3001\u8bbe\u7f6e\u8fb9\u6846\u7b49\n $objStyleA5\u00a0=\u00a0$objActSheet->getStyle('A5');\/\/\u83b7\u53d6A5\u5355\u5143\u683c\u7684\u6837\u5f0f<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u5b57\u4f53\n $objFontA5\u00a0=\u00a0$objStyleA5->getFont();\u00a0\/\/\u83b7\u5f97\u5b57\u4f53\n $objFontA5->setName('\u5b8b\u4f53');\/\/\u8bbe\u7f6e\u5b57\u4f53\u540d\u79f0\n $objFontA5->setSize(10);\u00a0\u00a0\/\/\u8bbe\u7f6e\u5b57\u4f53\u5927\u5c0f\n $objFontA5->setBold(true);\/\/\u8bbe\u7f6e\u5b57\u4f53\u52a0\u7c97\n $objFontA5->getColor()->setARGB('FF999999');\/\/\u8bbe\u7f6e\u5b57\u4f53\u989c\u8272<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u5bf9\u9f50\u65b9\u5f0f\n $objAlignA5\u00a0=\u00a0$objStyleA5->getAlignment();\/\/\u83b7\u5f97\u5bf9\u9f50\u65b9\u5f0f\n $objAlignA5->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);\/\/\u6c34\u5e73\u5c45\u53f3\n $objAlignA5->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);\/\/\u5782\u76f4\u5c45\u4e2d<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u8fb9\u6846\n $objBorderA5\u00a0=\u00a0$objStyleA5->getBorders();\/\/\u83b7\u53d6\u8fb9\u6846\n $objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);\/\/\u8fb9\u6846\u6837\u5f0f\n $objBorderA5->getTop()->getColor()->setARGB('FFFF0000');\/\/\u9876\u90e8\u8fb9\u6846\u7684\u989c\u8272\n $objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);\n $objBorderA5->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);\/\/\u5de6\u6837\u5f0f\n $objBorderA5->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);\/\/\u53f3\u6837\u5f0f<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u586b\u5145\u8272\n $objFillA5\u00a0=\u00a0$objStyleA5->getFill();\/\/\u586b\u5145\n $objFillA5->setFillType(PHPExcel_Style_Fill::FILL_SOLID);\/\/\u586b\u5145\u7c7b\u578b\n $objFillA5->getStartColor()->setARGB('FFEEEEEE');<\/span><\/pre>\n
\/\/\u8ba1\u7b97\u5355\u5143\u683c\u7684\u503c\n $objPHPExcel->getActiveSheet()->setCellValue('B7', '=SUM(B5:C5)');\n $objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue();\n \/\/\u5982\u679c\u8981\u83b7\u53d6\u5355\u5143\u683c\u7684\u4e00\u4e2a\u503c,\u9996\u5148\u9700\u8981\u901a\u8fc7\u5de5\u4f5c\u8868\u7684getCell\u65b9\u6cd5\u83b7\u53d6\u5230\u4e00\u4e2a\u5355\u5143\u683c\u5bf9\u8c61\uff0c\u7136\u540e\u518d\u901a\u8fc7\u5355\u5143\u683c\u5bf9\u8c61\u7684getValue\u65b9\u6cd5\u5f97\u5230\u5355\u5143\u683c\u7684\u503c\uff0c\u5982\u679c\u5355\u5143\u683c\u7684\u503c\u662f\u901a\u8fc7\u8ba1\u7b97\u5f97\u5230\u7684\uff0c\u5219\u9700\u8981\u4f7f\u7528getCalculatedValue\u65b9\u6cd5\u83b7\u53d6\u5355\u5143\u683c\u7684\u503c\uff0c\u8bbe\u7f6e\u5355\u5143\u683c\u7684\u503c\uff0c\u6211\u4eec\u53ea\u9700\u8981\u901a\u8fc7\u5de5\u4f5c\u8868\u7684setCellValue\u65b9\u6cd5\u6765\u8bbe\u7f6e\u5373\u53ef<\/span><\/pre>\n
\/\/$dateTimeNow=time();\n $objPHPExcel->getActiveSheet()->setCellValue('C10', PHPExcel_Shared_Date::PHPToExcel( $dateTimeNow ));\/\/41105.75<\/span><\/pre>\n
$objPHPExcel->getActiveSheet()->getStyle('C10')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4);\/\/18:00:54,\u53ea\u662f\u6362\u4e86\u4e00\u79cd\u663e\u793a\u65b9\u5f0f\uff0c\u5e76\u4e0d\u4f1a\u6539\u53d8\u539f\u6765\u503c\u7684\u7c7b\u578b<\/span><\/pre>\n
echo gettype($objPHPExcel->getActiveSheet()->getCell('C10')->getValue());\/\/double\n echo $objPHPExcel->getActiveSheet()->getCell('C10')->getValue();\/\/41105.75<\/span><\/pre>\n
\/\/'2010-10-21'\u4e00\u5b9a\u8981\u653e\u5728\u5f15\u53f7\u4e2d\uff0c\u5426\u5219\u663e\u793a\u7684\u503c\u4e3a\uff0c1979\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6587\u672c\uff08\u63a8\u8350\uff09\n $objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit(\"D1\", '2010-10-21', PHPExcel_Cell_DataType::TYPE_STRING); \/\/\u7279\u5f81\uff1a\u5b57\u7b26\u4e32\u7c7b\u578b\u90fd\u662f\u5c45\u5de6\u663e\u793a<\/span><\/pre>\n
\/\/\u6dfb\u52a0\u4e00\u4e2a\u65b0\u7684worksheet\n $objExcel->createSheet();\/\/\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5de5\u4f5c\u8868\n $objExcel->getSheet(1)->setTitle('\u6d4b\u8bd52');\/\/\u8bbe\u7f6e\u5f53\u524d\u5de5\u4f5c\u8868\u7684\u6807\u9898<\/span><\/pre>\n
\/\/\u4fdd\u62a4\u5355\u5143\u683c\n $objExcel->getSheet(1)->getProtection()->setSheet(true);\n $objExcel->getSheet(1)->protectCells('A1:C22',\u00a0'PHPExcel');<\/span><\/pre>\n
\/\/\u8f93\u51fa\u5185\u5bb9\u5230excel\u6587\u4ef6\uff0c\u5e76\u5c06\u6587\u4ef6\u4fdd\u5b58\u5728\u670d\u52a1\u5668\u4e0a\n $objWriter->save(\"test.xls\");<\/span><\/pre>\n
\/\/\u5f3a\u5236\u8f93\u51fa\u5185\u5bb9\u5230\u6d4f\u89c8\u5668\u4e0b\u8f7d\n header(\"Content-Type:\u00a0application\/force-download\");\n header(\"Content-Type:\u00a0application\/octet-stream\");\n header(\"Content-Type:\u00a0application\/download\");\n header('Content-Disposition:inline;filename=\"'.$outputFileName.'\"');\n header(\"Content-Transfer-Encoding:\u00a0binary\");\n header(\"Expires:\u00a0Mon,\u00a026\u00a0Jul\u00a01997\u00a005:00:00\u00a0GMT\");\n header(\"Last-Modified:\u00a0\"\u00a0.\u00a0gmdate(\"D,\u00a0d\u00a0M\u00a0Y\u00a0H:i:s\")\u00a0.\u00a0\"\u00a0GMT\");\n header(\"Cache-Control:\u00a0must-revalidate,\u00a0post-check=0,\u00a0pre-check=0\");\n header(\"Pragma:\u00a0no-cache\");<\/span><\/pre>\n
$objWriter->save('php:\/\/output');\/\/\u53c2\u6570-\u8868\u793a\u76f4\u63a5\u8f93\u51fa\u5230\u6d4f\u89c8\u5668\uff0c\u4f9b\u5ba2\u6237\u7aef\u4e0b\u8f7d<\/span><\/pre>\n
\/\/excel\u8bfb\u53d6\u5bf9\u8c61\n $PHPReader = new PHPExcel_Reader_Excel5();\/\/\u521b\u5efa\u4e00\u4e2aexcel\u6587\u4ef6\u7684\u8bfb\u53d6\u5bf9\u8c61\n $PHPExcel = $PHPReader->load($filePath);\/\/\u8bfb\u53d6\u4e00\u5f20excel\u8868\uff0c\u8fd4\u56deexcel\u6587\u4ef6\u5bf9\u8c61\n $currentSheet = $PHPExcel->getSheet(0);\/\/\u8bfb\u53d6excel\u6587\u4ef6\u4e2d\u7684\u7b2c\u4e00\u5f20\u5de5\u4f5c\u8868\n $allColumn = $currentSheet->getHighestColumn();\/\/\u53d6\u5f97\u5f53\u524d\u5de5\u4f5c\u8868\u6700\u5927\u7684\u5217\u53f7,\u5982\uff0cE\n $allRow = $currentSheet->getHighestRow();\/\/\u53d6\u5f97\u5f53\u524d\u5de5\u4f5c\u8868\u4e00\u5171\u6709\u591a\u5c11\u884c<\/span><\/pre>\n
\/\/\u8bbe\u7f6e\u5de5\u4f5c\u7c3f\u9ed8\u8ba4\u7684\u6837\u5f0f\n $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');\n $objPHPExcel->getDefaultStyle()->getFont()->setSize(8);<\/span><\/pre>\n
\/\/\u5408\u5e76\u5355\u5143\u683c\n $objPHPExcel->getActiveSheet()->mergeCells('A18:E22');<\/span><\/pre>\n
\u6848\u4f8b1\uff1a\u4f7f\u7528\u8fed\u4ee3\u5668\u5faa\u73af\u6240\u6709\u7684\u5355\u5143\u683c\uff1b\u8bfb\u53d6\u5de5\u4f5c\u8868\u4e2d\u6240\u6709\u5355\u5143\u683c\u7684\u503c\uff0c\u663e\u793a\u5230\u4e00\u4e2atable\u8868\u683c\u4e2d<\/span><\/pre>\n
 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$objPHPExcel = $objReader->load(\"test.xlsx\");\n $objWorksheet = $objPHPExcel->getActiveSheet();\/\/\u83b7\u53d6\u5f53\u524d\u6d3b\u52a8\u5de5\u4f5c\u8868\n echo '<\/span><\/pre>\n
' . \"\\n\";<\/span><\/pre>\n
foreach ($objWorksheet->getRowIterator() as $row) {\n echo '\n ' . \"\\n\"; \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 $cellIterator = $row->getCellIterator(); \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 $cellIterator->setIterateOnlyExistingCells(false); \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 foreach ($cellIterator as $cell) { \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0echo '' . $cell->getValue() . '<\/span><\/pre>\n
' . \"\\n\";\n }\n echo '<\/span><\/pre>\n
' . \"\\n\";<\/span><\/pre>\n
}\n echo '<\/span><\/pre>\n
' . \"\\n\";<\/span><\/pre>\n
?><\/span><\/pre>\n
\u6848\u4f8b2\uff1a\u4f7f\u7528\u7d22\u5f15\u5faa\u73af\u6240\u6709\u5355\u5143\u683c<\/span><\/pre>\n
 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$objPHPExcel = $objReader->load(\"test.xlsx\");\n $objWorksheet = $objPHPExcel->getActiveSheet();\n $highestRow = $objWorksheet->getHighestRow(); \/\/ e.g. 10\n $highestColumn = $objWorksheet->getHighestColumn(); \/\/ e.g 'F'\n $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); \/\/ 5\n echo '<\/span><\/pre>\n
'.\"\\n\";<\/span><\/pre>\n
for ($row = 1; $row <= $highestRow; ++$row) {\n echo '\n ' . \"\\n\";<\/span><\/pre>\n
for ($col = 0; $col <= $highestColumnIndex; ++$col) {\n echo '' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue().'<\/span><\/pre>\n
'.\"\\n\";\n }\n echo '<\/span><\/pre>\n
'.\"\\n\";<\/span><\/pre>\n
}\n echo '<\/span><\/pre>\n
'.\"\\n\";<\/span><\/pre>\n
?><\/span><\/pre>\n
\u6ce8\u610f\uff1a\u80af\u80fd\u540e\u8fb9\u4f1a\u5b66\u5230\u4e00\u4e2a\u7ef4\u5ea6\u7c7b\uff08Dimensions\uff09\uff0c\u5176\u5b9e\u7ef4\u5ea6\u6307\u7684\u5c31\u662f\u957f*\u5bbd<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
\u8fd9\u91cc\u6709\u5173\u4e8eexcel\u6587\u4ef6\u7684\u51e0\u4e2a\u6982\u5ff5\u9700\u8981\u8ddf\u5927\u5bb6\u8bf4\u660e\u4e00\u4e0b\uff0c\u8fd9\u51e0\u4e2a\u6982\u5ff5\u5bf9\u4e8e\u6211\u4eec\u7684\u540e\u7eed\u7f16\u7a0b\u662f\u5f88\u6709\u5e2e\u52a9\u7684\uff1a 1.\u5de5\u4f5c\u7c3f\uff1a … \u7ee7\u7eed\u9605\u8bfb\u3010php\u3011\u5bf9PHPExcel\u4e00\u4e9b\u7b80\u5355\u7684\u7406\u89e3<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"_links":{"self":[{"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/posts\/436"}],"collection":[{"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/comments?post=436"}],"version-history":[{"count":0,"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/posts\/436\/revisions"}],"wp:attachment":[{"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/media?parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/categories?post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihongchao.com\/wp-json\/wp\/v2\/tags?post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}