【宝马娱乐在线城】PHP读入EXCEL的
用本站上其他网友提供的Excel类导入数据后,在MYSQL中显示的都是श...等之类的代码,无法显示中文。我在使用过程中也是如此,为此我在网上查询很久,最终对两位网友提供的类进行了综合,解决了此类问题,请大家下载使用!
我们都是探讨,如果侵犯了原作者版权,请谅解!!!!
如果不同意,我就立即删除!
php导入到excel乱码是因为utf8编码在xp系统不支持所有utf8编码转码一下就完美解决了
utf-8编码案例 Php代码
对此类的运用方法如下:
复制代码 代码如下:
<?php
require "excel_class.php";
<?php
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=11.xls ");
header("Content-Transfer-Encoding: binary ");
?>
Read_Excel_File("Book1.xls",$return);
Php代码
for ($i=0;$i<count($return[Sheet1]);$i++)
{
for ($j=0;$j<count($return[Sheet1][$i]);$j++)
{
echo $return[Sheet1][$i][$j]."|";
}
echo "<br>";
}
?>
复制代码 代码如下:
<?
$filename="php导入到excel-utf-8编码";
$filename=iconv("utf-8", "gb2312", $filename);
echo $filename;
?>
gbk编码案例 Php代码
复制代码 代码如下:
<?php
header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=11.xls ");
header("Content-Transfer-Encoding: binary ");
?>
Php代码
复制代码 代码如下:
0.<?
0.$filename="php导入到excel-utf-8编码";
0.echo $filename;
0.?>
访问网站的时候就下载到excel里面
要弄单元格区别的话
用table表格做网页的就可以了
====================== 其他方法 =============================
1、制作简单 Excel
复制代码 代码如下:
0.<?php
0.header("Content-type:application/vnd.ms-excel");
0.header("Content-Disposition:filename=php2excel.xls");
0.
0.echo "A1/t B1/t C1/n";
0.echo "A2/t B2/t C2/n";
0.echo "A3/t B3/t C3/n";
0.echo "A4/t B4/t C4/n";
0.?>
2、制作简单 CSV
复制代码 代码如下:
<?php
$action =$_GET['action'];
if ($action=='make'){
$fp = fopen("demo_csv.csv","a"); //打开csv文件,如果不存在则创建
$title =
array("First_Name","Last_Name","Contact_Email","Telephone");
//第一行数据
$data_1 = array("42343","423432","4234","4234");
$data_2 = array("4234","Last_Name","Contact_Email","Telephone");
$title = implode(",",$title); //用 ' 分割成字符串
$data_1 = implode(",",$data_1); // 用 ' 分割成字符串
$data_2 = implode(",",$data_2); // 用 ' 分割成字符串
$data_str =$title."/r/n".$data_1."/r/n".$data_2."/r/n";
//加入换行符
fwrite($fp,$data_str); // 写入数据
fclose($fp); //关闭文件句柄
echo "生成成功";
}
echo "<br>";
echo "<a href='?action=make'>生成csv文件</a>";
?>
本文由宝马娱乐在线城发布于互联网络,转载请注明出处:【宝马娱乐在线城】PHP读入EXCEL的
关键词: