MySQL-求助一个phpexcel 数据库导入的例子！

Question

求助一个phpexcel excel 数据库导入的例子！

phpexcel 使用最新版本

Answer 1

$objReader = PHPExcel_IOFactory::createReader ('Excel2007');
//$objReader = PHPExcel_IOFactory::createReader ('Excel5');//excel 2003
/*设置PHPExcel 基本参数*/
$objReader->setReadDataOnly (true);
$objPHPExcel = $objReader->load ( 'file name' );//加载excel文件
$objWorksheet = $objPHPExcel->getActiveSheet ();
$highestRow = $objWorksheet->getHighestRow (); //取得总行
$highestColumn = $objWorksheet->getHighestColumn (); //取得总列
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString ( $highestColumn );
$excelData = array ();
/*$row 为开始位置*/
for($row = 2; $row <= $highestRow; ++ $row) {
for($col = 0; $col <= $highestColumnIndex; ++ $col) {
$excelData [$row] [] = $objWorksheet->getCellByColumnAndRow ($col, $row )->getValue ();
}
}
print_r($excelData);exit;

上面是我去年写处理Excel的。
你看下吧~