php write excel

/**
 * 写excel方法
 */
function writeExcel($tabArr, $dataArr,$path) {
    require_once CODE_BASE2 . '/util/phpexcel/PHPExcel.php';

    $objPHPExcel = new PHPExcel();
    $objSheet = $objPHPExcel->setActiveSheetIndex(0);

    //写表头
    $index = 'A';
    foreach ($tabArr as  $value) {
        $objSheet->setCellValue($index .'1', $value);
        $index++;
    }

    //写数据
    $i = 2;
    foreach ($dataArr as $key => $line) {
        $index = 'A';
        foreach($line as $val){
            $objSheet->setCellValue($index.$i, $val);
            $index++;
        }
        $i++;
    }

    $objWriter = PHPExcel_IOFactory:: createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save($path);
}

//php 读取excel
function readExcel($path){
    require_once CODE_BASE2 . '/util/phpexcel/PHPExcel.php';

    $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)
    $PHPExcel = $reader->load($path); // 载入excel文件
    $sheet = $PHPExcel->getSheet(0); // 读取第一個工作表
    $highestRow = $sheet->getHighestRow(); // 取得总行数
    $highestColumm = $sheet->getHighestColumn(); // 取得总列数

    $res=array();
    /** 循环读取每个单元格的数据 */
    for ($row = 1; $row <= $highestRow; $row++){//行数是以第1行开始
        for ($column = 'A'; $column <= $highestColumm; $column++) {//列数是以A列开始
            $res[$row-1][] = $sheet->getCell($column.$row)->getValue();
        }
    }
    return $res;
}

 

转载于:https://www.cnblogs.com/zhudongchang/p/5063987.html