从excel文件里读取数据
<?php
/**
* 从Excel文件中读取数据
* @var Ambiguous $dir
*/
$dir = dirname(__FILE__);
require $dir.'/PHPExcel/PHPExcel/IOFactory.php';
$filename = $dir.'/excel.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($filename);//加载Excel文件
/**
* 将所有数据读取到数组里
* $sheetCount = $objPHPExcel->getSheetCount();
for($i = 0;$i < $sheetCount;$i++){
$data = $objPHPExcel->getSheet($i)->toArray();
print($data);
}**/
$sheetIndex = 0;
foreach ($objPHPExcel->getWorksheetIterator() as $sheet){//循环取sheet
if($sheetIndex>0){
break;
}
foreach ($sheet->getRowIterator() as $row){//循环取row(行)
if($row->getRowIndex()>35){//控制行数不超过35
break;
}
foreach ($row->getCellIterator() as $cell){//循环取cell(单元格)
$data = $cell->getValue();
echo $data.' ';//显示读取的数据
}
echo '<br/>';
}
$sheetIndex++;
echo '<br/>';
}