<?php

     /**

      * 使用PHPExcel插件在excel文件中利用其中的数据建立折线图

      * */

     $dir = dirname(__FILE__);

     require $dir."/db.php";

     require $dir."/PHPExcel/PHPExcel.php";

     $db = new db($phpexcel);//实例化的db类 连接mysql数据库

     $objPHPExcel = new PHPExcel();//新建一个PHPEXcel对象

     $objSheet = $objPHPExcel -> getActiveSheet();

     //填充数据

     $array = array(

             array("","一班","二班","三班"),

             array("不及格",20,30,40),

             array("良好",30,50,55),

             array("优秀",15,17,20)

     );//准备数据

     $objSheet -> fromArray($array);//直接加载数组

     //开始图表代码练习

     $labels = array(

             new PHPExcel_Chart_DataSeriesValues('String','Worksheet!$B$1',null,1),

             new PHPExcel_Chart_DataSeriesValues('String','Worksheet!$C$1',null,1),

             new PHPExcel_Chart_DataSeriesValues('String','Worksheet!$D$1',null,1),

     );//先取得绘制图表的标签

     $xlabels = array(

             new PHPExcel_Chart_DataSeriesValues('String','Worksheet!$A2:$A$4',null,3)//取得图像x轴的刻度

     );

     $datas = array(

             new PHPExcel_Chart_DataSeriesValues('Number','Worksheet!$B2:$B$4',null,3),

             new PHPExcel_Chart_DataSeriesValues('Number','Worksheet!$C2:$C$4',null,3),

             new PHPExcel_Chart_DataSeriesValues('Number','Worksheet!$D2:$D$4',null,3)

     );//取得绘图所需的数据

     $series = array(

             new PHPExcel_Chart_DataSeries(

                     PHPExcel_Chart_DataSeries::TYPE_LINECHART,

                     PHPExcel_Chart_DataSeries::GROUPING_STANDARD,

                     range(0, count($labels) - 1),

                     $labels,

                     $xlabels,

                     $datas

             )

     );//根据取得的东西做出一个图表的框架

     $layout = new PHPExcel_Chart_Layout();

     $layout -> setShowVal(true);

     $ytitle = new PHPExcel_Chart_Title("value(人数)");

     $areas = new PHPExcel_Chart_PlotArea($layout,$series);

     $legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT,null,false);

     $title = new PHPExcel_Chart_Title("高一学生成绩分布");

     $chart = new PHPExcel_Chart(

         'line_chart',

         $title,

         $legend,

         $areas,

         true,

         false,

         null,

         $ytitle

     );//生成图表

     $chart -> setTopLeftPosition("A7") -> setBottomRightPosition("K25");//给定图表在表格中的位置

     $objSheet -> addChart($chart);//将chart添加到表格中

     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");//生成excel文件

     $objWriter -> setIncludeCharts(true);

     $objWriter -> save($dir."/export_chart.xlsx");//保存到当前目录下面

     //将Excel文件以浏览器下载的方式输出到浏览器

     browser_export('Excel2007', 'browser_excel03.xlsx');

     $objWriter -> save("php://output");//输出到浏览器

     //输出到浏览器的函数

     function browser_export($type,$filename){

         if("Excel5" == $type){

             header('Content-Type: application/vnd.ms-excel');//告诉浏览器将要输出Excel03文件

         }else{

             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');//告诉浏览器将要输出Excel07文件

         }

         header('Content-Disposition: attachment;filename="'.$filename.'"');//告诉浏览器将要输出文件的名称

         header('Cache-Control: max-age=0');//禁止缓存

     }