Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP导出为excel文件时，身份证却以科学计数法显示，怎么正常显示

PHP导出为excel文件时，身份证却以科学计数法显示，怎么正常显示

WBOY
Release： 2016-06-13 13:38:56
Original
1153 people have browsed it

PHP导出为excel文件时，身份证却以科学计数法显示，如何正常显示
PHP在把数据库中的记录导出为excel文件时，生成的excel文件中的身份证一列，却以科学计数法显示的，
不知有什么法子，让其全部显示。代码如下：
  header("content=text/html; charset=gb2312");
header("Content-type:application/vnd.ms-excel");
date_default_timezone_set('PRC'); //解决时间少了8小时的问题；
header("Content-Disposition:attachment;filename=".date('Y_m_d_H_i_s').".xls");
echo "

";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
$i = $number;
while($rows = mysql_fetch_array($result)){
echo "";
echo "";
echo "";
echo "";
echo "";
$i--;  
}
echo "
学员信息表
序号学员姓名身份证号码
".$i."".$rows['app_name']."".$rows["app_id_card"]."
";
?>
需要说明的是：数据库中身份证的字段属性用的是：varchar

另外，如果在导出的时候，前面加一个 ' 

echo "'".$rows["app_id_card"]."";

在excel中身份证也会以全部显示，不过生成的号码前面会有一个 ',
双击这个单元格后，这个 ' 会在 左上角生成一个小三角。



------解决方案--------------------
以文本格式储存
------解决方案--------------------
echo " ".$rows["app_id_card"]."";

这样可以，无伤大雅
Related labels：
echo excel gt lt quot
source：php.cn
Previous article： 帮忙写个表格样式，不难的,该怎么解决 Next article： thinkphp 关于文件上传的时候出现的诡异有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template