public function excel_fileput(){
Vendor("PHPExcel.IOFactory");
//2.获取Excel第0张表即(Sheet1)
//获取excel文件
$objPHPExcel = \PHPExcel_IOFactory::load("./Data/test_data.xls");
$objPHPExcel->setActiveSheetIndex(0);
$sheet0=$objPHPExcel->getSheet(0);
//3.获取行数,并把数据读取出来$data数组
$rowCount=$sheet0->getHighestRow();//excel行数
$data=array();
for ($i = 2; $i <= $rowCount; $i++){
list($id,$item['brand_name'],$item['brand_logo'],$item['brand_desc'],$item['site_url'],$item['sort_order'],$item['is_show']) = explode("\t",$objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue());
$data[]=$item;
}
$success=0;
$error=0;
$sum=count($data);
foreach($data as $k=>$v){
if(M('brand')->data($v)->add()){
$success++;
}else {
$error++;
}
}
echo "总{$sum}条,成功{$success}条,失败{$error}条。";
}
Vendor("PHPExcel.IOFactory");
//2.获取Excel第0张表即(Sheet1)
//获取excel文件
$objPHPExcel = \PHPExcel_IOFactory::load("./Data/test_data.xls");
$objPHPExcel->setActiveSheetIndex(0);
$sheet0=$objPHPExcel->getSheet(0);
//3.获取行数,并把数据读取出来$data数组
$rowCount=$sheet0->getHighestRow();//excel行数
$data=array();
for ($i = 2; $i <= $rowCount; $i++){
list($id,$item['brand_name'],$item['brand_logo'],$item['brand_desc'],$item['site_url'],$item['sort_order'],$item['is_show']) = explode("\t",$objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue());
$data[]=$item;
}
$success=0;
$error=0;
$sum=count($data);
foreach($data as $k=>$v){
if(M('brand')->data($v)->add()){
$success++;
}else {
$error++;
}
}
echo "总{$sum}条,成功{$success}条,失败{$error}条。";
}