php输出excel打印,使用PHPExcel读取excel文档并打印

Excel文档内容：

1

yangyu

136123

2

hercules

124124

3

northwood

123124

require_once './Classes/PHPExcel.php';

require_once './Classes/PHPExcel/IOFactory.php';

require_once './Classes/PHPExcel/Reader/Excel5.php';

$objReader = PHPExcel_IOFactory::createReader('Excel2007');//use excel2007 for 2007 format

$objPHPExcel = $objReader->load('./test.xlsx');

$sheet = $objPHPExcel->getSheet(0);

$highestRow = $sheet->getHighestRow(); //取得总行数

$highestColumn = $sheet->getHighestColumn(); //取得总列数

//$cellValue = $objPHPExcel->getActiveSheet()->getCell('B1')->getValue();

for($j=1;$j<=$highestRow;$j++) //从第一行开始读取数据

{

for($k='A';$k<=$highestColumn;$k++) //从A列读取数据

{

echo $objPHPExcel->getActiveSheet()->getCell("$k$j")

->getValue().'|';//读取单元格

}

echo '
';

}

$dataArray = $objPHPExcel->getActiveSheet()

->rangeToArray(

'A1:D3', // The worksheet range that we want to retrieve

NULL, // Value that should be returned for empty cells

TRUE, // Should formulas be calculated (the equivalent of getCalculatedValue() for each cell)

TRUE, // Should values be formatted (the equivalent of getFormattedValue() for each cell)

TRUE // Should the array be indexed by cell row and cell column

);

echo '

';

print_r ($dataArray);

echo '

';

exit; //debug-------------------