Home >Backend Development >PHP Tutorial >How to use PHP to read the contents of excel files and obtain cell data
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
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 './PHPExcel/IOFactory.php'; $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 = 'A'; $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;}
[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!