標籤：set sans 理解 order highlight add table ati otto
php匯出ExcelphpphpExcel匯出excel這些天在使用PHPExcel匯出資料時，5000條資料竟然掛了。後來跟同事聊聊，有些明悟，PHPExcel做了很多處理，我在這裡理解為渲染，就會暫用過多的空間，‘膨脹’的空間導致記憶體暫用過大，就掛了。其實只要我們只是簡單的匯出操作，沒有必要使用PHPExcel。大牛給了我這個程式，還沒搞清楚原理（如果有小夥伴知道，請不吝賜教哦！）,貼出代碼：
//處理Excel匯出public function excelData($datas,$titlename,$title,$filename){ $str = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40\">\r\n<head>\r\n<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>"; $str .="<table border=1><head>".$titlename."</head>"; $str .= $title; foreach ($datas as $key=> $rt ) { $str .= "<tr>"; foreach ( $rt as $k => $v ) { $str .= "<td>{$v}</td>"; } $str .= "</tr>\n"; } $str .= "</table></body></html>"; header( "Content-Type: application/vnd.ms-excel; name=‘excel‘" ); header( "Content-type: application/octet-stream" ); header( "Content-Disposition: attachment; filename=".$filename ); header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); exit( $str );}加油各位，加油自己，天行健！
php匯出Excel
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
