require'lib/PHPExcel.php';设置时间限制(90);$input_file="data.xlsx";$objPHPExcel=PHPExcel_IOFactory::load($input_file);$sheet_count=$objPHPExcel->getSheetCount();for($s=0;$s<$sheet_count;$s++){$currentSheet=$objPHPExcel->getSheet($s);//当前页$row_num=$currentSheet->getHighestRow();//当前页行数字$col_max=$currentSheet->getHighestColumn();//当前页的最大列数//从第二行开始循环,第一行一般是headerfor($i=2;$i<=$row_num;$i++){$cell_values=数组();for($j='A';$j<$col_max;$j++){$address=$j.$我;//单元坐标$cell_values[]=$currentSheet->getCell($address)->getFormattedValue();}//查看数据print_r($cell_values);}}
