Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > php import excel php use phpexcel to import excel files

php import excel php use phpexcel to import excel files

WBOY

Release： 2016-07-25 08:54:47

Original

976 people have browsed it

//载入PHPExcel类
include(dirname(__FILE__).'/phpexcel/PHPExcel.php');
$Obj = new PHPExcel_Reader_Excel5();
$Obj->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 <= $highestRow; ++$row) {
for($col = 0; $col < $highestColumnIndex; ++$col) {
$val = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
$data[$row][$col] = trim($val);
}
}

echo '

';</li>
<li>print_r($data);</li>
<li>echo '

复制代码

Related labels：

php导入excel php使用phpexcel导入excel文件

source：php.cn

Previous article：PHP implementation code for sending emails using SMTP Next article：PHP code to force download files (solve the problem of garbled Chinese file names under IE)

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn