PHPExcel implements methods and simple examples of reading excel files-PHP Tutorial-php.cn

PHPExcel implements methods and simple examples of reading excel files

墨辰丷

Release： 2023-03-29 12:02:02

Original

2433 people have browsed it

This article mainly introduces the method of PHPExcel to simply read excel files, and briefly analyzes PHPExcel's reading operation skills for Excel files in the form of examples. Friends in need can refer to the following

Reading an excel file, and get an example of the content of each row and column:

set_include_path(get_include_path() . PATH_SEPARATOR . &#39;./Classes/&#39;);
include &#39;PHPExcel/IOFactory.php&#39;;
$reader = PHPExcel_IOFactory::createReader(&#39;Excel2007&#39;); // 读取 excel 文档
$PHPExcel = $reader->load($excelfilename); // 文档名称
$sheet = $PHPExcel->getSheet(0); // 读取第一个工作表(编号从 0 开始)
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$arr = array(1=>&#39;A&#39;,2=>&#39;B&#39;,3=>&#39;C&#39;,4=>&#39;D&#39;,5=>&#39;E&#39;,6=>&#39;F&#39;,7=>&#39;G&#39;,8=>&#39;H&#39;,9=>&#39;I&#39;,10=>&#39;J&#39;,11=>&#39;K&#39;,12=>&#39;L&#39;,13=>&#39;M&#39;, 14=>&#39;N&#39;,15=>&#39;O&#39;,16=>&#39;P&#39;,17=>&#39;Q&#39;,18=>&#39;R&#39;,19=>&#39;S&#39;,20=>&#39;T&#39;,21=>&#39;U&#39;,22=>&#39;V&#39;,23=>&#39;W&#39;,24=>&#39;X&#39;,25=>&#39;Y&#39;,26=>&#39;Z&#39;);
//echo $highestRow.$highestColumn;
// 一次读取一列
for ($row = 5; $row <= $highestRow; $row++) {
  for ($column = 0; $arr[$column] != &#39;T&#39;; $column++) {
    $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
    echo $val;
  }
}

Copy after login

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

phpSharing of methods for developing custom menus on WeChat

PHP MySQL implements fuzzy query Employee information function

phpDetailed explanation of WeChat development access example

The above is the detailed content of PHPExcel implements methods and simple examples of reading excel files. For more information, please follow other related articles on the PHP Chinese website!