Laravel Excel表格倒入导出

导入:

 header("content-type:text/html;charset=utf-8");
 $dataa = DB::table('users')->get();
$data = json_decode(json_encode($dataa),true);　　//转为json数组


 $str="编号\t权限\账号\t姓名\t密码\t邮箱\t电话\性别\ip\建立时间\修改时间\删除时间"."\n";
 foreach($data as $key=>$v){
     $str.=implode("\t",$v)."\n";
 }

 header("content-type:application/vnd.ms-excel");
 header("content-disposition:attachment;filename=users.xls");
 echo $str;

 

原生导出:

<?php
  header("content-type:text/html;charset=utf-8");
    //echo phpinfo();
    //exit;
   $link=mysql_connect("localhost:3306","root",'root');
   mysql_query("set names utf8");
   mysql_query("use yuekao");
   $sql="select * from user";
   $res=mysql_query($sql);
   while($row=mysql_fetch_assoc($res)){
    $data[]=$row;
   }
   //var_dump($data);
    $str="编号\t姓名\t密码\t邮箱\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;

 

 

原生导入:

<?php
   //从文件里面读取内容
   header('content-type:text/html;charset=utf-8');
   $str=trim(file_get_contents("use.xls"));
   //echo $str;exit;
   $data=explode("\n",$str);
   //var_dump($data);
   foreach($data as $key=>$v){
      $arr[]=explode("\t",$v);
      //var_dump($v);
     unset($arr[0]);
     //unset($arr[1]);
     //unset($arr[2]);
   }
  //var_dump($arr);exit;
   mysql_connect("localhost:3306","root",'root');
   mysql_query("set names gbk");
   mysql_query("use yuekao");
    $sql='';
   foreach($arr as $v){
     $sql="insert into user1 values('$v[0]','$v[1]','$v[2]','$v[3]','$v[4]','$v[5]');";
     //echo $sql;
     mysql_query($sql);
     //var_dump($res);
   }
  //echo $sql;