1.使用PHPexcel自带的函数,如:
1)
$objActSheet = Excel::getActiveSheet();
$objActSheet->getStyle('AX')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
或者
$sheet->setColumnFormat(array('AX','@'));
2.封装函数
function Num2Str($num){
if (stripos($num,'e')===false) return $num;
$num = trim(preg_replace('/[=\'"]/','',$num,1),'"');//出现科学计数法,还原成字符串
$result = "";
while ($num > 0){
$v = $num - floor($num / 10)*10;
$num = floor($num / 10);
$result = $v . $result;
}
return $result;
}
3.在需要转换的字段后面加空格或者在前面加空格,如:
$val['id_card'] = ' ' .$id_card;
$val['id_card'] = $id_card . ' ';