setreaddataonly(true);//读取demo.xls文件
$phpexcel = $obj->load(dirname(__file__).'/output.xls');//获取当前活动sheet
$objworksheet = $phpexcel->getactivesheet();//获取行数
$highestrow = $objworksheet->gethighestrow();//获取列数
//by bbs.it-home.org$highestcolumn = $objworksheet->gethighestcolumn();$highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);//循环输出数据
$data = array();for($row = 1; $row for($col = 0; $col $val = $objworksheet->getcellbycolumnandrow($col, $row)->getvalue(); $data[$row][$col] = trim($val); }}echo '
';
print_r($data);echo '';
复制代码