How to read Excel file information and content using PHP? (Picture + video tutorial)

This article will give you a detailed introduction to how to use PHP to read Excel file data and content information.

Before the article begins, everyone needs to know what PHPExcel is? PHPExcel is a PHP class library used to operate Office Excel documents.

You can download the PHPExcel class library through this official link: https://github.com/PHPOffice/PHPExcel

Click the location in the picture below to download the PHPExcel class library compressed package.

Then decompress the downloaded PHPExcel compressed package, and then copy the two files PHPExcel and PHPExcel.php directly to the root directory of our own project.

Below we will explain in detail through specific code examples:

The detailed method of PHPExcel reading Excel data.

For example, there is a 1.xls table with the following content:

We use the PHPExcel class library to convert the Excel table The information content in is read out. The complete code is as follows:

<?php
$fileName = "1.xls";
if (!file_exists($fileName)) {
    return "文件不存在！";
}
// 引入PHPExcel
require_once "./PHPExcel/IOFactory.php";
// 载入当前文件
$phpExcel = PHPExcel_IOFactory::load($fileName);

// 设置为默认表
$phpExcel->setActiveSheetIndex(0);
// 获取表格数量
$sheetCount = $phpExcel->getSheetCount();
// 获取行数
$row = $phpExcel->getActiveSheet()->getHighestRow();
// 获取列数
$column = $phpExcel->getActiveSheet()->getHighestColumn();
echo "表格数目为：$sheetCount" . "表格的行数：$row" . "列数：$column";

$data = [];
// 行数循环
for ($i = 1; $i <= $row; $i++) {
    // 列数循环
    for ($c = &#39;A&#39;; $c <= $column; $c++) {
        $data[] = $phpExcel->getActiveSheet()->getCell($c . $i)->getValue();
    }
    echo "<pre class="brush:php;toolbar:false">";
    print_r($data);
}

In the above code, first if determines whether the Excel table exists, and then uses require_once to introduce the PHPExcel class library中IOFactory.phpThis class, and then use a method of the PHPExcel class library to load the Excel file. Here, the loaded Excel file is assigned to the $phpExcel variable.

Then use the $phpExcel variable to specify the corresponding methods to obtain the number, rows, and columns of the Excel table, and set the table as default (0 means default) through the setActiveSheetIndex(0) method.

At this time, the results of the number of tables, rows, and columns are output. The results accessed through the browser are as follows:

We pass the results in the figure Display, you can find that the information in the form has been correctly obtained.

Then we use for loop to traverse all the contents of the table, and then define an array $data to receive these contents.

Then access it through the browser, and the final loop result is as follows:

As shown in the figure, we successfully read the Excel file All content.

This article is about PHP reading Excel filesThat is, using PHPExcel to read Excel dataThe specific method is introduced. It has certain reference value. I hope it will help you if you need Friends help!

If you want to know more about PHP, you can follow the PHP Chinese website PHP Video Tutorial, you are welcome to come and learn!

The above is the detailed content of How to read Excel file information and content using PHP? (Picture + video tutorial). For more information, please follow other related articles on the PHP Chinese website!