PHP 如何利用phpexcel导入数据库_PHP教程

废话不多说，直接上代码吧复制代码代码如下:php error_reporting(E_ALL); //开启错误set_time_limit(0); //脚本不超时date_default_timezone_set('Europe/London'); //设置时间/** Include path **/ set_include_path(get_include_path() . PATH_SEPARATOR . 'http://www.jb51.net/../Classes/');//设置环境变量/** PHPExcel_IOFactory */ include 'PHPExcel/IOFactory.php';//$inputFileType = 'Excel5';    //这个是读 xls的$inputFileType = 'Excel2007';//这个是计xlsx的//$inputFileName = './sampleData/example2.xls';$inputFileName = './sampleData/book.xlsx';echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'';$objReader = PHPExcel_IOFactory::createReader($inputFileType);$objPHPExcel = $objReader->load($inputFileName);/*$sheet = $objPHPExcel->getSheet(0);$highestRow = $sheet->getHighestRow(); //取得总行数$highestColumn = $sheet->getHighestColumn(); //取得总列*/$objWorksheet = $objPHPExcel->getActiveSheet();//取得总行数$highestRow = $objWorksheet->getHighestRow();//取得总列数echo 'highestRow='.$highestRow;echo "";$highestColumn = $objWorksheet->getHighestColumn();$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);//总列数echo 'highestColumnIndex='.$highestColumnIndex;echo "";$headtitle=array();for ($row = 1;$row         {$strs=array();//注意highestColumnIndex的列数索引从0开始for ($col = 0;$col             {$strs[$col] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();}$info = array('word1'=>"$strs[0]",'word2'=>"$strs[1]",'word3'=>"$strs[2]",'word4'=>"$strs[3]",);//在这儿，你可以连接，你的数据库，写入数据库了print_r($info);echo '';}?>http://www.bkjia.com/PHPjc/328157.html www.bkjia.com true http://www.bkjia.com/PHPjc/328157.html TechArticle废话不多说，直接上代码吧 复制代码 代码如下: ?php error_reporting(E_ALL); //开启错误 set_time_limit(0); //脚本不超时 date_default_timezone_set('Europe/Lo...