dongquexi1990 2016-04-13 12:22
浏览 103
已采纳

使用php中的Spreadsheet_Excel_Reader从excel文件中读取URL

I am using Spreadsheet_Excel_Reader() to read a excel file.

I want to read a url in sheet data like below

<a href="link">text</a>

I know this problem will solve by using PHPExcel like this

$leadCommentLInk=$worksheet->getCellByColumnAndRow(7, 2)->getHyperlink()->getUrl();

please help me in this

  • 写回答

1条回答 默认 最新

  • dongxindu8753 2016-04-14 06:15
    关注

    Finally I got the solution by changing my reader.php file like this

    Added following switch case in _parsesheet method

    case SPREADSHEET_EXCEL_READER_TYPE_HYPER:
                    //  Only handle hyperlinks to a URL
                    $row    = ord($this->data[$spos]) | ord($this->data[$spos+1])<<8;
                    $row2   = ord($this->data[$spos+2]) | ord($this->data[$spos+3])<<8;
                    $column = ord($this->data[$spos+4]) | ord($this->data[$spos+5])<<8;
                    $column2 = ord($this->data[$spos+6]) | ord($this->data[$spos+7])<<8;
                    $linkdata = Array();
                    $flags = ord($this->data[$spos + 28]);
                    $udesc = "";
                    $ulink = "";
                    $uloc = 32;
                    $linkdata['flags'] = $flags;
                    if (($flags & 1) > 0 ) {   // is a type we understand
                        //  is there a description ?
                        if (($flags & 0x14) == 0x14 ) {   // has a description
                            $uloc += 4;
                            $descLen = ord($this->data[$spos + 32]) | ord($this->data[$spos + 33]) << 8;
                            $udesc = substr($this->data, $spos + $uloc, $descLen * 2);
                            $uloc += 2 * $descLen;
                        }
                        $ulink = $this->read16bitstring($this->data, $spos + $uloc + 20);
                        if ($udesc == "") {
                            $udesc = $ulink;
                        }
                    }
                    $linkdata['desc'] = $udesc;
                    $linkdata['link'] = $this->_encodeUTF16($ulink);
                    for ($r=$row; $r<=$row2; $r++) { 
                        for ($c=$column; $c<=$column2; $c++) {
                            $this->sheets[$this->sn]['cellsInfo'][$r+1][$c+1]['hyperlink'] = $linkdata;
                        }
                    }
                    break;
    

    and add this constant

    define('SPREADSHEET_EXCEL_READER_TYPE_HYPER',        0x01b8);
    

    and mothod

    function read16bitstring($data, $start) {
        $len = 0;
        while (ord($data[$start + $len]) + ord($data[$start + $len + 1]) > 0) $len++;
        return substr($data, $start, $len);
    }
    

    or else we can simply use one file excel_reader2.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题