PHP Excel导入和导出

导入：

<?php
//获取excel内容
$str = file_get_contents('use.xls');
//去除字符串两边空格
$str = trim($str);
//通过回车把字符串分割成数组
$arr = explode("\n",$str);
//处理数组通过\t（制表符）
foreach($arr as $k=>$v){
	if($k!=0){
		$data[] = explode("\t",$v);	
	}
}
//连接数据库
$link = mysql_connect('127.0.0.1','root','root') or die('no');
mysql_select_db('test',$link) or die('yes');
//由于excel编码格式问题  必须设置为gbk
mysql_query('set names gbk');
//$sql = '';
foreach($data as $k=>$v){
	$sql = "insert into user(username,pwd) values('$v[1]','$v[2]')";
	$info = mysql_query($sql);
	//print_r($info);die;
}


?>

导出：

<?php
  header("content-type:text/html;charset=utf-8");
	//exit;
   $link=mysql_connect("127.0.0.1","root",'root');
   mysql_select_db($link,'test');
   mysql_query("set names utf8");
   $sql="select * from user";
   $res=mysql_query($sql);
   while($row=mysql_fetch_assoc($res)){
    $data[]=$row;
   }
   //var_dump($data);
    $str="编号\t姓名\t密码"."\n";
   foreach($data as $key=>$v){
     $str.=implode("\t",$v)."\n";
   }
   header("content-type:application/vnd.ms-excel");
   header("content-disposition:attachment;filename=use.xls");
   echo $str;