Home > Backend Development > PHP Tutorial > phpexcel的getSheet(i)只能读取一页,如何获取一个excel有多少分页

phpexcel的getSheet(i)只能读取一页,如何获取一个excel有多少分页

WBOY
Release: 2016-06-13 10:19:03
Original
1084 people have browsed it

phpexcel的getSheet(i)只能读取一页,怎么获取一个excel有多少分页?
phpexcel的getSheet只能读取一页,怎么获取一个excel有多少分页?

------解决方案--------------------
count?
------解决方案--------------------
//获取工作表的数目
$sheetCount = $PHPExcel->getSheetCount();

PHP code
<?phprequire_once 'Classes/PHPExcel.php';$fileName = 'test.xlsx';$path = '替换成文件的具体路径';$filePath = $path.$fileName;$PHPExcel = new PHPExcel();        $PHPReader = new PHPExcel_Reader_Excel2007(); //为了可以读取所有版本Excel文件if(!$PHPReader->canRead($filePath)){                            $PHPReader = new PHPExcel_Reader_Excel5();        if(!$PHPReader->canRead($filePath))    {                                echo '未发现Excel文件!';        return;    }} //不需要读取整个Excel文件而获取所有工作表数组的函数,感觉这个函数很有用,找了半天才找到$sheetNames  = $PHPReader->listWorksheetNames($filePath); //读取Excel文件$PHPExcel = $PHPReader->load($filePath); //获取工作表的数目$sheetCount = $PHPExcel->getSheetCount(); //选择第一个工作表$currentSheet = $PHPExcel->getSheet(0); //取得一共有多少列$allColumn = $currentSheet->getHighestColumn();    //取得一共有多少行$allRow = $currentSheet->getHighestRow();   //循环读取数据,默认编码是utf8,这里转换成gbk输出for($currentRow = 1;$currentRowgetCell($address)->getValue() )."\t";    }    echo "<br>";}?><div class="clear">
                 
              
              
        
            </div>
Copy after login
Related labels:
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