php导入excel yii,phpexcel yii 导入

//关闭yii自动加载功能

spl_autoload_unregister(array('YiiBase','autoload'));

require_once './protected/extensions/phpexcel/PHPExcel.php';

$PHPExcel = new PHPExcel();

/* * 默认用excel2007读取excel，若格式不对，则用之前的版本进行读取 */

$PHPReader = new PHPExcel_Reader_Excel2007();

$filePath = "./aaa.xls";

if (!$PHPReader->canRead($filePath)) {

$PHPReader = new PHPExcel_Reader_Excel5();

if (!$PHPReader->canRead($filePath)) {

echo 'no Excel';

return;

}

}

$PHPExcel = $PHPReader->load($filePath);

/* * 读取excel文件中的第一个工作表 */

$currentSheet = $PHPExcel->getSheet(0);

/* * 取得最大的列号 */

$allColumn = $currentSheet->getHighestColumn();

/* * 取得一共有多少行 */

$allRow = $currentSheet->getHighestRow();

/* * 从第二行开始输出，因为excel表中第一行为列名 */

//for ($currentRow = 2; $currentRow <= $allRow; $currentRow++) {

// /* * 从第A列开始输出 */

// for ($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn++) {

// $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue(); /* * ord()将字符转为十进制数 */

// if ($currentColumn == 'A') {

// echo GetData($val) . "\t";

// } else {

// //echo $val;

// /* * 如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将gb2312编码转为utf-8编码输出 */

// echo iconv('utf-8','gb2312',$val) . "\t";

// }

// }

// echo "";

//}

//echo "\n";

for ($j = 2; $j <= $allRow; $j++) {

$a = $PHPExcel->getActiveSheet()->getCell("A" . $j)->getValue(); //获取A列的值

$b = $PHPExcel->getActiveSheet()->getCell("B" . $j)->getValue(); //获取B列的值

$c = $PHPExcel->getActiveSheet()->getCell("C" . $j)->getValue(); //获取B列的值

$d = $PHPExcel->getActiveSheet()->getCell("D" . $j)->getValue(); //获取B列的值

$e = $PHPExcel->getActiveSheet()->getCell("E" . $j)->getValue(); //获取B列的值

$f = $PHPExcel->getActiveSheet()->getCell("F" . $j)->getValue(); //获取B列的值

$g = $PHPExcel->getActiveSheet()->getCell("G" . $j)->getValue(); //获取B列的值

$h = $PHPExcel->getActiveSheet()->getCell("H" . $j)->getValue(); //获取B列的值

echo $sql = "INSERT INTO table VALUES(" . $a . "," . $b . "," . $c . "," . $d . "," . $e . "," . $f . "," . $g . "," . $h . ")" . "";

}

//恢复Yii自动加载功能

spl_autoload_register(array('YiiBase','autoload'));