set_time_limit(0); // 脚本不超时
//以下三步加载phpExcel的类
require_once 'PHPExcel.php';
require_once 'PHPExcel/IOFactory.php';
require_once 'PHPExcel/Reader/Excel5.php';
//use excel2007 for 2007 format
$objReader = PHPExcel_IOFactory::createReader('Excel5');
//指定的文件
$filename = './2.xls';
//载入xls文件,$filename可以是上传的文件,或者是指定的文件
$objPHPExcel = $objReader->load($filename);
//生成工作表的对象--从0开始
$sheet = $objPHPExcel->getSheet(0);
// 取得总行数
$highestRow = $sheet->getHighestRow();
// 取得总列数
$highestColumn = $sheet->getHighestColumn();
//计数初始化
$k = 0;
//循环读取excel文件,读取一条,插入一条
//j表示从哪一行开始读取
for($j=1;$j<=$highestRow;$j++){
$a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
$b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
$c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//获取C列的值
//$sql = "INSERT INTO table VALUES(".$a.",".$b.",".$c.",".$d.",null,".$f.",".$g."),";
$sql = 'INSERT INTO `t_tag_type` VALUES(null,"'.$a.'","'.$b.'","'.$c.'");<br/>';
print_r($sql);
//
$res = mysql_query($sql) or die ("错误:$sql");
}