<?PHP
require_once '/Classes/PHPExcel.PHP';
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load("..\excel.xlsx");
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $objWorksheet->getHighestRow(); 
$highestColumn = $objWorksheet->getHighestColumn(); 
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); 
$user=strtolower($_GET['user']);
$r_count=0;
echo '<table border="1">' . "\n";
for ($row = 5; $row <= $highestRow; ++$row) {
if ($row <7 || $user=="admin" || strstr(strtolower($objWorksheet->getCellByColumnAndRow(8,$row)->getValue()),$user ))
 { 
 if($row>7)$r_count++;
 for ($col = 0; $col <= $highestColumnIndex; ++$col) {
      if(PHPExcel_Shared_Date::isDateTime($objWorksheet->getCellByColumnAndRow($col,$row)))
        echo '<td>' . date("d M Y",PHPExcel_Shared_Date::ExcelToPHP($objWorksheet->getCellByColumnAndRow($col,$row))) . '</td>' ;
      else
        echo '<td>' . $objWorksheet->getCellByColumnAndRow($col,$row)->getValue() . '</td>' . "\n";
  }
   echo '</tr>' . "\n";
}
}
 echo '</table>' . "\n";
 echo "No. of Entries: ".$r_count;
?>

抱歉,次优代码.当我运行PHP文件时,我得到一个表,其中的所有字符串都正确显示,但是datetime和number字段充满了看似随机的乱码.请从上面的链接看一下.我做了一些研究,然后发现了isDateTime()函数.但它不起作用或可能被错误地使用.我正在为这个项目设置一个紧迫的截止日期,所以如果有人能指出我正确的方向,那就太棒了.如果答案非常明显,真的很抱歉.非常感谢提前.
拉胡尔