$objPHPExcel->getActiveSheet()->setCellValue('C'.$i , $cardid);
上面代码导出excel,身份证格式会转成科学计数,添加转义符 “\t”,如下
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i , $cardid."\t");
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i , $cardid);
上面代码导出excel,身份证格式会转成科学计数,添加转义符 “\t”,如下
$objPHPExcel->getActiveSheet()->setCellValue('C'.$i , $cardid."\t");