phpexcel导入导出

导入获取不同格式的数值
for ($col = 0; $col < $highestColumnIndex; ++$col) {
　　//普通数值
    $cell = $objWorksheet->getCellByColumnAndRow($col, $row);
    $value = $cell->getValue();
    //判断是否是时间格式/富文本
    if(in_array($col,[3,4,5,6]) && $cell->getDataType()==\PHPExcel_Cell_DataType::TYPE_NUMERIC){
        $value = date('Y年m月d日',\PHPExcel_Shared_Date::ExcelToPHP($value));
    }elseif($value instanceof \PHPExcel_RichText){
        $value = $value->getPlainText();
    }
    if($value && $table[$col]){
        $oneData[$table[$col]]= trim($value);
    }
}
导出：强制输出字符串

$objPHPExcel->getActiveSheet()->setCellValueExplicit($head[$j] . ($i+2), $modellist[$i][$name], \PHPExcel_Cell_DataType::TYPE_STRING);