<?php
require "F:/6/htdocs/PHPExcel-1.8/Classes/PHPExcel/IOFactory.php";
$filename="F:/6/htdocs/PHPExcel-1.8/Classes/demo.slsx";
//引入读取的excel类文件
$objPHPExcel=PHPExcel_IOFactory::load($filename);
//加载要读取的文件
$sheetCount=$objPHPExcel->getSheetCount();
//获取excel文件中有多少个sheet
/*for ($i=0;$i<$sheetCount;$i++)
{
$data=$objPHPExcel->getSheet($i)->toArray();
print_r($data);//读取每个sheet里的数据全部放到数组中.
}*/
foreach ($objPHPExcel->getWorksheetIterator() as $sheet)//循环取shert
{
foreach ($sheet->getRowIterator() as $row)//逐行处理
{
if($row->getRowIndex()<2)
{
continue;
}
foreach ($row->getCellIterator() as $cell)//逐列处理
{
$data=$cell->getValue();//获取单元格数据
echo $data." ";
}
echo "<br />";
}
echo "<br />";
}
exit;
?>