Home > Backend Development > PHP Tutorial > How to use PHP to read the contents of excel files and obtain cell data

How to use PHP to read the contents of excel files and obtain cell data

藏色散人
Release: 2023-04-03 16:06:01
Original
42367 people have browsed it

This article mainly introduces how to use PHP to read the contents of excel files, that is, the data of each cell. I hope it will be helpful to everyone.

Related video courses: "PHP Quick Control of Excel - PhpSpreadsheet"

Relevant knowledge points involved:

①PHPExcel is a PHP class library used to operate Office Excel documents. It is based on Microsoft's Openxml standard and PHP language. You can use it to read and write spreadsheets in different formats.

②time() Function that returns the number of seconds of the current time, used to obtain the current system time

③require_once In order to avoid repeated loading of files, that is Load the file once

④array() Create an array

⑤memory_get_usage() PHP built-in function can return the current The amount of memory allocated to PHP scripts, use it to debug PHP code performance

⑥var_dump() Used to print an array, or output a string

How to use PHP to read the contents of excel files and obtain cell data

The specific method for php to read excel files and process them accordingly

The code examples are as follows:

<?php
/*读取excel文件,并进行相应处理*/
$fileName = "url.xls";
if (!file_exists($fileName)) {
    exit("文件".$fileName."不存在");
}
$startTime = time(); //返回当前时间的Unix 时间戳
require_once &#39;./PHPExcel/IOFactory.php&#39;;
$objPHPExcel = PHPExcel_IOFactory::load($fileName);
//获取sheet表格数目
$sheetCount = $objPHPExcel->getSheetCount();
//默认选中sheet0表
$sheetSelected = 0;$objPHPExcel->setActiveSheetIndex($sheetSelected);
//获取表格行数
$rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();
//获取表格列数
$columnCount = $objPHPExcel->getActiveSheet()->getHighestColumn();
echo "<div>Sheet Count : ".$sheetCount."  行数: ".$rowCount."  列数:".$columnCount."</div>";
$dataArr = array();

/* 循环读取每个单元格的数据 */
//行数循环
for ($row = 1; $row <= $rowCount; $row++){
//列数循环 , 列数是以A列开始
for ($column = &#39;A&#39;; $column <= $columnCount; $column++) {
    $dataArr[] = $objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue();
    echo $column.$row.":".$objPHPExcel->getActiveSheet()->getCell($column.$row)->getValue()."<br />";
}
echo "<br/>消耗的内存为:".(memory_get_peak_usage(true) / 1024 / 1024)."M";
$endTime = time();
echo "<div>解析完后,当前的时间为:".date("Y-m-d H:i:s")."   
总共消耗的时间为:".(($endTime - $startTime))."秒</div>";
var_dump($dataArr);
$dataArr = NULL;}
Copy after login

[Recommended related articles]

How to use phpexcel? The strongest summary of commonly used methods in phpexcel

Super practical PHPExcel [import][export] implementation method summary

Detailed introduction to PHPExcel reading Excel time Sample code

How to read large excel file data in PHP

[Related video course recommendations]

PHP Video tutorial on controlling Excel

The above is the detailed content of How to use PHP to read the contents of excel files and obtain cell data. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template