php phpexcel 创建excel

public function createExcel($result=[],$fileName=''){
    \think\Loader::import('extend.excel.PHPExcel',ROOT_PATH);
    import('Org.Util.Util');
    $Util = new \util\Util();
    $objExcel = new \PHPExcel();
    $objWriter = new \PHPExcel_Writer_Excel5($objExcel);     // 用于其他版本格式
    $objExcel->setActiveSheetIndex(0);
    $objActSheet = $objExcel->getActiveSheet();
    //设置当前活动sheet的名称
    $objActSheet->setTitle('sheet1');
    //设置标题
    $objActSheet->setCellValue('A1', 'name');
    $objActSheet->setCellValue('B1', 'sex');
    foreach($result as $key => $value){
        $number = $key+2;
        $objActSheet->setCellValue("A".$number,$value['name'] );  // 设置Excel中的内容  A2表示坐标
        $objActSheet->setCellValue("B".$number,$value['sex']);
    }
    //生成excel到文件
    $fileId=md5(time() + rand() * 100000);
    $filePath = getFilePath($fileId);
    $fileId = iconv('utf-8','gbk',$fileName);
    $filePath = '/home/examine/';
    if (!is_dir($filePath)) {
        @mkdir($filePath, 0777, true);
    }
    $fileName = $fileId.'.xls';
    $excelLocalPath = $filePath . $fileName;
    $objWriter->save($excelLocalPath);
    echo $excelLocalPath;
}

转载于:https://www.cnblogs.com/wenxinphp/p/11016949.html