phpexcel導(dǎo)入導(dǎo)出利用PHPExcel類(lèi)用法

php利用PHPExcel類(lèi)導(dǎo)出導(dǎo)入Excel用法來(lái)源：時(shí)間：2013-09-0519:26:56閱讀數(shù)：PHPExcelphpexcelPHPExcelexcel(PHPExcelExcelPHPExcelphpexcelPHPExcel類(lèi)來(lái)導(dǎo)入與導(dǎo)出excel表格的應(yīng)用方法，有需要了解的朋友不防參考參考(PHPExcelset_include_path('.'.PATH_SEPARATOR.Yii::app()->basePath.'/lib/PHPExcel'.PATH_SEPARATOR.//注：在yii//引入PHPExcel相關(guān)文件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");默認(rèn)$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;}//導(dǎo)入Excelfunction{$filePath=$str=//下面的路徑按照你PHPExcelrequire_once'../PHPExcel/PHPExcel.php';require_once'../PHPExcel/PHPExcel/IOFactory.php';$extend=strrchr//move_uploaded_file()truefalse //echoif($result)如果上傳文件成功，就執(zhí)行導(dǎo)入excel{include$objReader=PHPExcel_IOFactory::createReader('Excel5');//useexcel2007for2007$objPHPExcel=$objReader-$sheet=$objPHPExcel-$highestRow$sheet $highestColumn$sheet->getHighestColumn();/* //循 excel文件 { //從A 數(shù){實(shí)測(cè)在excel }//echo$str;$strs=$sql="INSERTINTOte(`1`,`2`,`3`,`4`,`5`)VALUES({returnecho'sql語(yǔ)句有誤}$str=}unlink($uploadfile);刪除上傳的excel$msg/*第二種方法$objWorksheet=$objPHPExcel-$highestRow=$objWorksheet->getHighestRow();echo'highestRow='.$highestRow;echo$highestColumnIndexPHPExcel_Cell::columnIndexFromString($highestColumn);//總列數(shù)echo'highestColumnIndex='.$highestColumnIndex;echofor($row=1;$row<={//注意highestColumnIndex0for($col=0;$col<{}$sql="INSERTINTOte(`1`,`2`,`3`,`4`,`5`)VALUES({}}}{

returnecho'sql語(yǔ)句有誤$msg}return}<inputtype="hidden"