这个问题我也遇到过,不知道楼主遇到的情况是不是和我一样
两个写法都是用的同一个版本的PHPEXCEL,但是不知道为啥第一种会慢很多~
以下是老代码:
//代码是基于Yii1
set_time_limit(0);//这个一定要
$Excel = CUploadedFile::getInstanceByName("Excel");
$filePath = $Excel->getTempName() . '.' . $Excel->getExtensionName();
$Excel->saveAs($filePath);
Yii::import("application.extensions.*");
$excel = new ExcelReader($filePath);
foreach ($excel->getWorksheetList() as $worksheet => $value) {
$rs = $excel->getWorksheetData($worksheet);
if (!empty($rs)) {
foreach ($rs as $index => $row) {
$name = $row[1];
$phone = $row[2];
//more code...
}
}
以下是新代码:
//代码是基于Yii1
set_time_limit(0);//这个一定要
$Excel = CUploadedFile::getInstanceByName("Excel");
$filePath = $Excel->getTempName() . '.' . $Excel->getExtensionName();
$Excel->saveAs($filePath);
Yii::import("application.extensions.*");
$PHPExcel = new PHPExcel();
$PHPReader = new PHPExcel_Reader_Excel2007();//如果new的是2007,那么excel必须是2007格式的
$excel = $PHPReader->load($filePath);//引入文件
$excelSheets = $excel->getAllSheets();
$activeSheetNames = $excel->getSheetNames();
foreach ($excelSheets as $SheetIndex => $activeSheet) {
$sheetColumnTotal = $activeSheet->getHighestRow();
if($sheetColumnTotal == 0){
continue;
}
for($i = 2;$i < $sheetColumnTotal;$i++){
$name = $activeSheet->getCell('A'.$i)->getValue();
$phone = $activeSheet->getCell('B'.$i)->getValue();
}
}