phpexcel导入导出利用PHPExcel类用法

php利用PHPExcel类导出导入Excel用法来源：时间：2013-09-0519:26:56阅读数：PHPExcelphpexcelPHPExcelexcel(PHPExcelExcelPHPExcelphpexcelPHPExcel类来导入与导出excel表格的应用方法，有需要了解的朋友不防参考参考(PHPExcelset_include_path('.'.PATH_SEPARATOR.Yii::app()->basePath.'/lib/PHPExcel'.PATH_SEPARATOR.//注：在yii//引入PHPExcel相关文件require_once"PHPExcel.php";require_once'PHPExcel/IOFactory.php';//$resultPHPExcel$resultPHPExcel=new'''$i=foreach($dataas$i}$outputFileName='total$xlsWriter=new//ob_start();header("Content-Type:application/ header("Content-Type:application/octet-stream");header("Content-Type:application/download");header("Content-Transfer-Encoding:binary");header("Expires:Mon,26Jul199705:00:00GMT");header("Last-Modified:".gmdate("D,dMYH:i:s")."GMT");header("Cache-Control:must-revalidate,post-check=0,pre-check=0");header("Pragma:no-cache");默认$xlsWriter->save("php://output"$finalFileName$finalFileName=(Yii::app()->basePath.'/runtime/'.time().'echofile_get_contents($finalFileName);//file_get_contents()file()是file_get_contents()把文if($_POST['leadExcel']=={$filename=$tmp_name=$msg=uploadFile($filename,$tmp_name);echo$msg;}//导入Excelfunction{$filePath=$str=//下面的路径按照你PHPExcelrequire_once'../PHPExcel/PHPExcel.php';require_once'../PHPExcel/PHPExcel/IOFactory.php';$extend=strrchr//move_uploaded_file()truefalse //echoif($result)如果上传文件成功，就执行导入excel{include$objReader=PHPExcel_IOFactory::createReader('Excel5');//useexcel2007for2007$objPHPExcel=$objReader-$sheet=$objPHPExcel-$highestRow$sheet $highestColumn$sheet->getHighestColumn();/* //循 excel文件 { //从A 数{实测在excel }//echo$str;$strs=$sql="INSERTINTOte(`1`,`2`,`3`,`4`,`5`)VALUES({returnecho'sql语句有误}$str=}unlink($uploadfile);删除上传的excel$msg/*第二种方法$objWorksheet=$objPHPExcel-$highestRow=$objWorksheet->getHighestRow();echo'highestRow='.$highestRow;echo$highestColumnIndexPHPExcel_Cell::columnIndexFromString($highestColumn);//总列数echo'highestColumnIndex='.$highestColumnIndex;echofor($row=1;$row<={//注意highestColumnIndex0for($col=0;$col<{}$sql="INSERTINTOte(`1`,`2`,`3`,`4`,`5`)VALUES({}}}{

returnecho'sql语句有误$msg}return}<inputtype="hidden"