{"id":810,"date":"2015-12-25T17:09:11","date_gmt":"2015-12-25T09:09:11","guid":{"rendered":"http:\/\/www.zyuns.com\/?p=810"},"modified":"2015-12-25T17:09:11","modified_gmt":"2015-12-25T09:09:11","slug":"phpexcel%e4%b8%ad%e6%96%87%e5%b8%ae%e5%8a%a9%e6%89%8b%e5%86%8c%e4%b9%8b%e5%b8%b8%e7%94%a8%e5%8a%9f%e8%83%bd%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/www.siediyer.cn\/?p=810","title":{"rendered":"phpExcel\u4e2d\u6587\u5e2e\u52a9\u624b\u518c\u4e4b\u5e38\u7528\u529f\u80fd\u6307\u5357"},"content":{"rendered":"<p>PHPExcel\u57fa\u672c\u64cd\u4f5c\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n\u5b9a\u4e49EXCEL\u5b9e\u4f53<br \/>\n \u5373\u5b9a\u4e49\u4e00\u4e2aPHPEXCEL\u5bf9\u8c61\uff0c\u5e76\u8bbe\u7f6eEXCEL\u5bf9\u8c61\u5185\u663e\u793a\u5185\u5bb9<\/p>\n<pre class=\"lang:default decode:true \">\/\/ Excel\u5f00\u59cb\r\n\/\/ \u51c6\u5907EXCEL\u7684\u5305\u62ec\u6587\u4ef6\r\n\/\/ Error reporting \r\nerror_reporting(0);\r\n\/\/ PHPExcel \r\nrequire_once dirname(__FILE__) . 'PHPExcel.php';\r\n\/\/ \u751f\u6210\u65b0\u7684excel\u5bf9\u8c61\r\n$objPHPExcel = new PHPExcel();\r\n\/\/ \u8bbe\u7f6eexcel\u6587\u6863\u7684\u5c5e\u6027\r\n$objPHPExcel-&gt;getProperties()-&gt;setCreator(\"Sam.c\")\r\n             -&gt;setLastModifiedBy(\"Sam.c Test\")\r\n             -&gt;setTitle(\"Microsoft Office Excel Document\")\r\n             -&gt;setSubject(\"Test\")\r\n             -&gt;setDescription(\"Test\")\r\n             -&gt;setKeywords(\"Test\")\r\n             -&gt;setCategory(\"Test result file\");\r\n\/\/ \u5f00\u59cb\u64cd\u4f5cexcel\u8868\r\n\/\/ \u64cd\u4f5c\u7b2c\u4e00\u4e2a\u5de5\u4f5c\u8868\r\n$objPHPExcel-&gt;setActiveSheetIndex(0);\r\n\/\/ \u8bbe\u7f6e\u5de5\u4f5c\u8584\u540d\u79f0\r\n$objPHPExcel-&gt;getActiveSheet()-&gt;setTitle(iconv('gbk', 'utf-8', 'phpexcel\u6d4b\u8bd5'));\r\n\/\/ \u8bbe\u7f6e\u9ed8\u8ba4\u5b57\u4f53\u548c\u5927\u5c0f\r\n$objPHPExcel-&gt;getDefaultStyle()-&gt;getFont()-&gt;setName(iconv('gbk', 'utf-8', '\u5b8b\u4f53'));\r\n$objPHPExcel-&gt;getDefaultStyle()-&gt;getFont()-&gt;setSize(10);\r\n<\/pre>\n<p>\u4e09\u3001\u8f93\u51fa\u6587\u4ef6<\/p>\n<pre class=\"lang:default decode:true \">\/\/ \u5982\u679c\u9700\u8981\u8f93\u51faEXCEL\u683c\u5f0f\r\nif($m_exportType==\"excel\"){   \r\n    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');\r\n    \/\/ \u4ece\u6d4f\u89c8\u5668\u76f4\u63a5\u8f93\u51fa$filename\r\n    header(\"Pragma: public\");\r\n    header(\"Expires: 0\");\r\n    header(\"Cache-Control:must-revalidate, post-check=0, pre-check=0\");\r\n    header(\"Content-Type:application\/force-download\");\r\n    header(\"Content-Type: application\/vnd.ms-excel;\");\r\n    header(\"Content-Type:application\/octet-stream\");\r\n    header(\"Content-Type:application\/download\");\r\n    header(\"Content-Disposition:attachment;filename=\".$filename);\r\n    header(\"Content-Transfer-Encoding:binary\");\r\n    $objWriter-&gt;save(\"php:\/\/output\"); \r\n}\r\n\/\/ \u5982\u679c\u9700\u8981\u8f93\u51faPDF\u683c\u5f0f\r\nif($m_exportType==\"pdf\"){\r\n    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');\r\n    $objWriter-&gt;setSheetIndex(0);\r\n    header(\"Pragma: public\");\r\n    header(\"Expires: 0\");\r\n    header(\"Cache-Control:must-revalidate, post-check=0, pre-check=0\");\r\n    header(\"Content-Type:application\/force-download\");\r\n    header(\"Content-Type: application\/pdf\");\r\n    header(\"Content-Type:application\/octet-stream\");\r\n    header(\"Content-Type:application\/download\");\r\n    header(\"Content-Disposition:attachment;filename=\".$m_strOutputPdfFileName);\r\n    header(\"Content-Transfer-Encoding:binary\");\r\n    $objWriter-&gt;save(\"php:\/\/output\"); \r\n}\r\n<\/pre>\n<p>\u8bbe\u7f6e\u4e00\u5217\u7684\u5bbd\u5ea6\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension('A')-&gt;setWidth(15);\r\n<\/pre>\n<p>\u8bbe\u7f6e\u4e00\u884c\u7684\u9ad8\u5ea6\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;getRowDimension('6')-&gt;setRowHeight(30);\r\n<\/pre>\n<p>\u5408\u5e76\u5355\u5143\u683c\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;mergeCells('A1:P1');\r\n<\/pre>\n<p>\u8bbe\u7f6eA1\u5355\u5143\u683c\u52a0\u7c97\uff0c\u5c45\u4e2d\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true\">$styleArray1 = array(\r\n  'font' =&gt; array(\r\n    'bold' =&gt; true,\r\n    'size'=&gt;12,\r\n    'color'=&gt;array(\r\n      'argb' =&gt; '00000000',\r\n    ),\r\n  ),\r\n  'alignment' =&gt; array(\r\n    'horizontal' =&gt; PHPExcel_Style_Alignment::HORIZONTAL_CENTER,\r\n  ),\r\n);\r\n\/\/ \u5c06A1\u5355\u5143\u683c\u8bbe\u7f6e\u4e3a\u52a0\u7c97\uff0c\u5c45\u4e2d\r\n$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A1')-&gt;applyFromArray($styleArray1);\r\n \r\n$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('B1')-&gt;getFont()-&gt;setBold(true);\r\n<\/pre>\n<p>\u7ed9\u7279\u5b9a\u5355\u5143\u683c\u4e2d\u5199\u5165\u5185\u5bb9\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;setCellValue('A1', 'Hello Baby');\r\n<\/pre>\n<p>\u8bbe\u7f6e\u5355\u5143\u683c\u6837\u5f0f\uff08\u6c34\u5e73\/\u5782\u76f4\u5c45\u4e2d\uff09\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true\">$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A1')-&gt;getAlignment()-&gt;setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);\r\n$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A1')-&gt;getAlignment()-&gt;setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);\r\n<\/pre>\n<p>\u8bbe\u7f6e\u5355\u5143\u683c\u6837\u5f0f\uff08\u9ed1\u8272\u5b57\u4f53\uff09\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('H5')-&gt;getFont()-&gt;getColor()-&gt;setARGB(PHPExcel_Style_Color::COLOR_BLACK); \/\/ \u9ed1\u8272<\/pre>\n<p>\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\uff08\u80cc\u666f\uff09\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('H5')-&gt;getFill()-&gt;getStartColor()-&gt;setARGB('00ff99cc'); \/\/ \u5c06\u80cc\u666f\u8bbe\u7f6e\u4e3a\u6d45\u7c89\u8272<\/pre>\n<p>\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\uff08\u6570\u5b57\u683c\u5f0f\uff09\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('F'.$iLineNumber)-&gt;getNumberFormat()-&gt;setFormatCode('0.000');<\/pre>\n<p>\u7ed9\u5355\u5143\u683c\u4e2d\u653e\u5165\u56fe\u7247\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">\/\/ \u5c06\u6570\u636e\u4e2d\u5fc3\u56fe\u7247\u653e\u5728J1\u5355\u5143\u683c\u5185\r\n$objDrawing = new PHPExcel_Worksheet_Drawing();\r\n$objDrawing-&gt;setName('Logo');\r\n$objDrawing-&gt;setDescription('Logo');\r\n$objDrawing-&gt;setPath('test.jpg');\r\n$objDrawing-&gt;setWidth(400);\r\n$objDrawing-&gt;setHeight(123);\r\n$objDrawing-&gt;setCoordinates('J1');\r\n$objDrawing-&gt;setWorksheet($objPHPExcel-&gt;getActiveSheet());<\/pre>\n<p>\u5728\u5355\u5143\u683c\u4e2d\u8bbe\u7f6e\u8d85\u94fe\u63a5\uff1a<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$objPHPExcel-&gt;getActiveSheet()-&gt;setCellValue('H8', iconv('gbk', 'utf-8', '\u71d5\u5357\u5929'));\r\n$objPHPExcel-&gt;getActiveSheet()-&gt;getCell('H8')-&gt;getHyperlink()-&gt;setUrl('http:\/\/www.jb51.net\/');<\/pre>\n<p>\u8bbe\u7f6e\u5355\u5143\u683c\u8fb9\u6846<br \/>\n<script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<div id=\"head\">\n<div id=\"contents\">\n<div class=\"main clearfix\">\n<div class=\"w690 fl\">\n<div class=\"article-content border\">\n<div id=\"content\">\n<pre class=\"lang:default decode:true \">$styleThinBlackBorderOutline = array(\r\n    'borders' =&gt; array (\r\n       'outline' =&gt; array (\r\n          'style' =&gt; PHPExcel_Style_Border::BORDER_THIN,  \/\/\u8bbe\u7f6eborder\u6837\u5f0f\r\n          \/\/'style' =&gt; PHPExcel_Style_Border::BORDER_THICK, \u53e6\u4e00\u79cd\u6837\u5f0f\r\n          'color' =&gt; array ('argb' =&gt; 'FF000000'),     \/\/\u8bbe\u7f6eborder\u989c\u8272\r\n      ),\r\n   ),\r\n);\r\n$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle( 'A4:E10')-&gt;applyFromArray($styleThinBlackBorderOutline);\r\n \r\n\/\/\u6dfb\u52a0\u4e00\u4e2a\u65b0\u7684worksheet \r\n          $objExcel-&gt;createSheet(); \r\n          $objActSheet = $objExcel-&gt;getSheet($s); \r\n          $objActSheet-&gt;setTitle('\u8868'.$GSheet);<\/pre>\n<p>&nbsp;\n<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><script src=\"http:\/\/assets.changyan.sohu.com\/upload\/changyan.js?conf=prod_1dc5dc80970106099d43fe242b7465fc&amp;appid=cyrHH3dwi\" type=\"mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-mce-text\/javascript\" charset=\"utf-8\"><\/script><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>PHPExcel\u57fa\u672c\u64cd\u4f5c\uff1a \u5b9a\u4e49EXCEL\u5b9e\u4f53 \u5373\u5b9a\u4e49\u4e00\u4e2aPHPEXCEL\u5bf9\u8c61\uff0c\u5e76\u8bbe\u7f6eEXCEL\u5bf9\u8c61\u5185\u663e\u793a\u5185\u5bb9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[37],"class_list":["post-810","post","type-post","status-publish","format-standard","hentry","category-php","tag-phpexcel"],"_links":{"self":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=810"}],"version-history":[{"count":1,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions"}],"predecessor-version":[{"id":811,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions\/811"}],"wp:attachment":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}