如何用phpspreadsheet读取Excel，构建长尾词？

本文共计265个文字，预计阅读时间需要2分钟。

首先使用composer安装phpoffice/phpspreadsheet库，然后编写一个私有函数readYewuExcel()用于读取Excel数据。具体代码如下：

php

private function readYewuExcel(){ $reader=IOFactory::createReader('Xlsx'); $reader->setReadDataOnly(true); $spreadsheet=$reader->load('yewu.xlsx');}

首先是用composer安装phpoffice/phpspreadsheet

具体代码

//读取数据 private function readYewuExcel(){ $reader = IOFactory::createReader("Xlsx"); $reader->setReadDataOnly(TRUE); $spreadsheet = $reader->load('yewu.xlsx'); //载入excel表格 路径和文件名 $spreadsheet->setActiveSheetIndex(0);//指定excel的sheet 0是第一个 $worksheet = $spreadsheet->getActiveSheet(); $highestRow = $worksheet->getHighestRow(); // 总行数 $highestColumn = $worksheet->getHighestColumn(); // 总列数 没用到 $highestColumnIndex = Coordinate::columnIndexFromString($highestColumn); //没用到 $lines = $highestRow; if ($lines <= 0) { exit('Excel表格中没有数据'); } $yewulist = []; for ($row = 2; $row <= $highestRow; ++$row) {//因为第一行是标题,所以从第二行开始,所以是row=2 //getCellByColumnAndRow(列数,行数)//获取单元格内容 $name = $worksheet->getCellByColumnAndRow(1, $row)->getValue(); //业务名称 $content = $worksheet->getCellByColumnAndRow(2, $row)->getValue(); //客户详情 $btime = $worksheet->getCellByColumnAndRow(4, $row)->getValue(); //开始时间 $etime = $worksheet->getCellByColumnAndRow(5, $row)->getValue(); //结束时间 $gongyingshang = $worksheet->getCellByColumnAndRow(8, $row)->getValue(); //供应商 $yewulist[] = [ 'name'=>$name, 'content'=>$content, 'create_time'=>$btime, //...... ]; } return $yewulist; }