懒虫的宝典

< ?PHP
define("PHPEXCEL_ROOT"，"PHPExcel/"); //这里是定义PHPExcel的路径
 
require_once PHPEXCEL_ROOT.'PHPExcel.php';
require_once PHPEXCEL_ROOT.'IOFactory.php';
require_once PHPEXCEL_ROOT.'Reader/Excel2007.php';
 
 
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
 
$objPHPExcel = $objReader->load("test.xlsx");
 
 
$sheetNum = $objPHPExcel->getSheetCount(); //获取sheet的个数
for($sheet=0;$sheet< $sheetNum;$sheet++) {
    $objWorksheet = $objPHPExcel->getSheet($sheet);
    $highestRow = $objWorksheet->getHighestRow(); 
    $highestColumn = $objWorksheet->getHighestColumn(); 
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
 
    echo '<table>' . "\n";
    for ($row = 1; $row < = $highestRow; ++$row) {
        echo '<tr>' . "\n";
 
        for ($col = 0; $col < = $highestColumnIndex; ++$col) {
            echo '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '' . "\n";
        }
        echo '' . "\n";
    }
    echo '</table>' . "\n";
}
?>