phpexcel 上传

<?php

require_once(ROOTPATH . "inc/PHPExcel/PHPExcel.class.php");//PHPExcel//获取数据


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

$objSheet = $objPHPExcel->getActiveSheet();//获得当前活动sheet的活动对象

$objSheet->setTitle("****表");//设置当前活动Sheet名称

$objSheet->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置excel文件默认水平垂直方向居中

$cellKey = array(

    'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',

    'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z',

    'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM',

    'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ'

);

//手动填充表头信息

$i = 0;

$condition[]='缴费类型';

$condition[]='缴费人姓名';

$condition[]='缴费金额';

$condition[]='缴费有效期开始日期';

$condition[]='缴费有效期结束日期';

$condition[]='提醒';

foreach ($condition as $key => $val) {

    $width = strlen($val) < 15 ? 15 : (strlen($val) + 5);

    $objPHPExcel->getActiveSheet()->getColumnDimension($cellKey[$i])->setWidth($width);

    $objSheet->setCellValue($cellKey[$i++] . '1', $val);

}

//填充数据

#行数

$js=1;

for ($i = 1; $i < count($data) + 1; $i++) {

    $x = 0;

    #是否有缴费记录

    $cz=0;

    foreach ($data[$i - 1] as $key => $value) {

        //当有物业费记录时 换到下一行填充数据

        if($key=='wyf'){

            $cz=1;

            $js++;

            $sum1=0;

            foreach ($value as $k =>$v){

                $width = strlen($v) < 15 ? 15 : (strlen($v) + 5);

                $objPHPExcel->getActiveSheet()->getColumnDimension($cellKey[$i])->setWidth($width);

                $objSheet->setCellValue($cellKey[$sum1++] . $js, $v);

            }

        //当有停车费记录时 换到下一行填充数据

        }else if($key=='tcf'){

            $cz=1;

            $js++;

            $sum1=0;

            foreach ($value as $k =>$v){

                $width = strlen($v) < 15 ? 15 : (strlen($v) + 5);

                $objPHPExcel->getActiveSheet()->getColumnDimension($cellKey[$i])->setWidth($width);

                $objSheet->setCellValue($cellKey[$sum1++] . $js, $v);

            }

        } else{

            if($_POST['chooice']==1){

                if($data[$i - 1]['wyf'] || $data[$i - 1]['tcf']){

                    $js++;

                    $width = strlen($value) < 15 ? 15 : (strlen($value) + 5);

                    $objPHPExcel->getActiveSheet()->getColumnDimension($cellKey[$i])->setWidth($width);

                    $objSheet->setCellValue($cellKey[$x++] . $js, $value);

                    $objSheet->mergeCells($cellKey[0] . $js.":".$cellKey[5] . $js);//合并A1-E1之间的单元格

                }

            }else{

                $js++;

                $width = strlen($value) < 15 ? 15 : (strlen($value) + 5);

                $objSheet->setCellValue($cellKey[$x++] . $js, $value);

                $objSheet->mergeCells($cellKey[0] . $js.":".$cellKey[5] . $js);//合并A1-E1之间的单元格

            }

        }

    }

}

$objPHPExcel->createSheet();  //创建一个WorkSheet

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

browser_export('Excel2007', '物业管理缴费表.xlsx');//输出到浏览器 设置游览器保存文件名

$objWriter->save("php://output");

function browser_export($type, $filename)

{

    if ($type == "Excel5") {

        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');//禁止缓存

}

/***

 * @param $fromTime

 * @param $toTime

 * @return string

 * 计算相差时间

 */

function calcTime($fromTime, $toTime){

    //转时间戳

    $fromTime = strtotime($fromTime);

    $toTime = strtotime($toTime);

    //计算时间差

    $newTime = $toTime - $fromTime;

    return round($newTime / 86400);

}

?>

phpexcel 上传的相关教程结束。