<?php
/**
 * Created by PhpStorm.
 * User: admin
 * Date: 2019/3/16
 * Time: 9:41
 */
//利用excel导出插件PHPExcel
// 引入phpexcel核心类文件
require_once 'PHPExcel.php';

// 实例化excel类
$objPHPExcel = new PHPExcel();

// 操作第一个工作表
$objPHPExcel->setActiveSheetIndex(0);
// 设置sheet名
$objPHPExcel->getActiveSheet()->setTitle('xx列表');

// 设置表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(5);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);


// 列名表头文字加粗
$objPHPExcel->getActiveSheet()->getStyle('A1:J1')->getFont()->setBold(true);
// 列表头文字居中
$objPHPExcel->getActiveSheet()->getStyle('A1:J1')->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

// 列名赋值
$objPHPExcel->getActiveSheet()->setCellValue('A1', '编号');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '姓名');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '电话');
$objPHPExcel->getActiveSheet()->setCellValue('D1', '擅长');
$objPHPExcel->getActiveSheet()->setCellValue('E1', '创建日期');
$objPHPExcel->getActiveSheet()->setCellValue('F1', '审核');
$objPHPExcel->getActiveSheet()->setCellValue('G1', '审核时间');

// 数据起始行
$row_num = 2;
// 向每行单元格插入数据
//foreach ($res as $value) {
    // 设置所有垂直居中
    $objPHPExcel->getActiveSheet()->getStyle('A' . $row_num . ':' . 'J' . $row_num)->getAlignment()
        ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    // 设置价格为数字格式
    $objPHPExcel->getActiveSheet()->getStyle('D' . $row_num)->getNumberFormat()
        ->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00);
    // 居中
    $objPHPExcel->getActiveSheet()->getStyle('E' . $row_num . ':' . 'H' . $row_num)->getAlignment()
        ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

    // 设置单元格数值
    $objPHPExcel->getActiveSheet()->setCellValue('A' . $row_num, 50);
    $objPHPExcel->getActiveSheet()->setCellValue('B' . $row_num, 'nihao');
    $objPHPExcel->getActiveSheet()->setCellValue('C' . $row_num, 'sssss');
    $objPHPExcel->getActiveSheet()->setCellValue('D' . $row_num, 'sssss');
    $objPHPExcel->getActiveSheet()->setCellValue('E' . $row_num, 'ssssss');
    $objPHPExcel->getActiveSheet()->setCellValue('F' . $row_num, 'ssssssssss');
    $objPHPExcel->getActiveSheet()->setCellValue('G' . $row_num, 'ssssssss');
    $row_num++;
//}

$outputFileName = 'teacher_' . time() . '.xls';
$xlsWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: