Rumah >pembangunan bahagian belakang >tutorial php >  php两种导出excel的方法

  php两种导出excel的方法

WBOY
WBOYasal
2016-06-20 12:45:261252semak imbas

所需要的:jquery库,phpexcel插件,页面导出excel效果测试文件explode.php,excel导出功能实现文件exp.php和explode_excel.php,文件相关内容在此文下面:

explode.php:测试页面内容:访问此页面后单击explode1与explode2能导出两种不同效果的excel,代码如下:

<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><meta http-equiv='Content-Type' content='text/html; charset=utf-8' /><script src='jquery.js'></script><title></title><style>td{    text-align:center;    font-size:12px;    font-family:Arial, Helvetica, sans-serif;    border:#1C7A80 1px solid;    color:#152122;    width:100px;}table,tr{    border-style:none;}.title{    background:#7DDCF0;    color:#FFFFFF;    font-weight:bold;}</style></head><body><script>    $(document).ready(function(){        $('#explode1').click(function(){                window.location.href='exp.php';        });         $('#explode2').click(function(){                window.location.href='explode_excel.php';        });    })</script><table width="800" border="1">  <tr>    <td class='title'>Date</td>    <td class='title' colspan="5" style='width:500px;text-align:center;'>CSAT Score</td>    <td class='title'>Grand Total</td>    <td class='title'>CSAT</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr></table><br /><input type='button' id='explode1' value='Explode' style='margin-left:620px;background-color:#10899E;color:white;padding:3px;font-weight:bold;'><input type='button' id='explode2' value='Explode2' style='background-color:#10899E;color:white;padding:3px;font-weight:bold;margin-left:24px;'></body></html>

第一种,用phpexcel插件导出excel,即exp.php文件中的内容:

<?phpheader("content-type:text/html;charset=utf-8");/** Error reporting */error_reporting(E_ALL);/** PHPExcel */include_once 'PHPExcel.php'; /** PHPExcel_Writer_Excel2003用于创建xls文件 */include_once 'PHPExcel/Writer/Excel5.php'; // Create new PHPExcel object$objPHPExcel = new PHPExcel(); // Set properties$objPHPExcel->getProperties()->setCreator("李汉团");$objPHPExcel->getProperties()->setLastModifiedBy("李汉团");$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes."); // Add some data$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Date');//合并单元格:$objPHPExcel->getActiveSheet()->mergeCells('B1:F1');$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'CSAT Score');$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Grand Total');$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'CSAT');$objPHPExcel->getActiveSheet()->SetCellValue('A2', '08/01/11');$objPHPExcel->getActiveSheet()->SetCellValue('B2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('C2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('D2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('E2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('F2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('G2', '0');$objPHPExcel->getActiveSheet()->SetCellValue('H2', '0%');$objPHPExcel->getActiveSheet()->SetCellValue('A3', '08/01/11');$objPHPExcel->getActiveSheet()->SetCellValue('B3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('C3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('D3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('E3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('F3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('G3', '0');$objPHPExcel->getActiveSheet()->SetCellValue('H3', '0%');$objPHPExcel->getActiveSheet()->SetCellValue('A4', '08/01/11');$objPHPExcel->getActiveSheet()->SetCellValue('B4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('C4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('D4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('E4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('F4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('G4', '0');$objPHPExcel->getActiveSheet()->SetCellValue('H4', '0%'); // Rename sheet$objPHPExcel->getActiveSheet()->setTitle('Csat');    // Save Excel 2007 file//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);   $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); $objWriter->save(str_replace('.php', '.xls', __FILE__)); header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); header("Content-Disposition:attachment;filename=csat.xls"); header("Content-Transfer-Encoding:binary"); $objWriter->save("php://output");?>

第二种,直接用header导出html,指定样式的excel,即explode_excel.php中的内容,如下:

<?phpheader ( "Content-type:application/vnd.ms-excel" );header ( "Content-Disposition:filename=csat.xls" );    echo "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><meta http-equiv='Content-Type' content='text/html; charset=UTF-8' /><title>无标题文档</title><style>td{    text-align:center;    font-size:12px;    font-family:Arial, Helvetica, sans-serif;    border:#1C7A80 1px solid;    color:#152122;    width:100px;}table,tr{    border-style:none;}.title{    background:#7DDCF0;    color:#FFFFFF;    font-weight:bold;}</style></head> <body><table width='800' border='1'>  <tr>    <td class='title'>Date</td>    <td class='title' colspan='5' style='width:500px;text-align:center;'>CSAT Score</td>    <td class='title'>Grand Total</td>    <td class='title'>CSAT</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>测试内容!!</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr>  <tr>    <td>08/01/11</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0</td>    <td>0%</td>  </tr></table></body></html>";?>


Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn