分享一下PHP操作excel表,至于用途,除了导入导出,剩下的自己想象吧
第一步:上传excel 附件
form表单上传,这个就不用说的了,不会的百度下
PHP保存附件,简单DEOM
/*获取提交的数据*/$tmp_name=$_FILES['dataxls']['tmp_name'];$t=time();$srcdir="upload/files/".date("Ymd",$t)."/";$src="upload/files/".date("Ymd",$t)."/f".$t.".xls";/*文件夹不存在就创建*/if(!is_dir($srcdir)){mkdir($srcdir,0777,true);}/*保存文件*/move_uploaded_file($tmp_name,$src);
第二步:读取excel内容
/*引入phpexcel*/require_once'./PHPExcel/PHPExcel.php';require_once'./PHPExcel/PHPExcel/IOFactory.php';require_once'./PHPExcel/PHPExcel/Reader/Excel.php';$readstr="";$readarr=array();/*声明excel版本版*/$objReader=PHPExcel_IOFactory::createReader('Excel');/*加载上传的附件*/$objPHPExcel=PHPExcel_IOFactory::load($src);/*读取第一个工作博的内容*/$sheet=$objPHPExcel->getSheet(0);$highestRow=$sheet->getHighestRow();//取得总行数$highestColumn=$sheet->getHighestColumn();//取得总列数/*循环获取数据*/for($j=2;$j<=$highestRow;$j++){for($k='A';$k<=$highestColumn;$k++){$readstr.=$objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().'|';//读取单元格}$readstr=substr($readstr,0,strlen($readstr)-1);$readstrnull=str_replace("|","",$readstr);if(!empty($readstrnull)){/*将数据赋值给临时数组*/$readarr[]=explode("|",$readstr);}$readstr="";}/*打印数组*/print_r($readarr);
原文链接:http://www.webstr.top/post/18