• php使用PHPexcel类读取excel文件(循环读取每个单元格的数据)


    error_reporting(E_ALL);
    date_default_timezone_set('Asia/ShangHai');
    include_once('Classes/PHPExcel/IOFactory.php');//包含类文件

    $filename = "test.xls";//要读取的excel文件
    if (!file_exists($filename)) {
    exit("not found. ");
    }

    $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿)
    $PHPExcel = $reader->load($filename); // 载入excel文件
    $sheet = $PHPExcel->getSheet(0); // 读取第一個工作表
    $highestRow = $sheet->getHighestRow(); // 取得总行数
    $highestColumm = $sheet->getHighestColumn(); // 取得总列数

    /** 循环读取每个单元格的数据 */
    $dataset=array();
    for ($row = 1; $row <= $highestRow; $row++){//行数是以第1行开始
    for ($column = 'A'; $column <= $highestColumm; $column++) {//列数是以A列开始
    $dataset[$row][] = $sheet->getCell($column.$row)->getValue();
    echo $column.$row.":".$sheet->getCell($column.$row)->getValue()."<br />";
    }
    }

  • 相关阅读:
    228. Summary Ranges
    227. Basic Calculator II
    224. Basic Calculator
    222. Count Complete Tree Nodes
    223. Rectangle Area
    221. Maximal Square
    220. Contains Duplicate III
    219. Contains Duplicate II
    217. Contains Duplicate
    Java编程思想 4th 第4章 控制执行流程
  • 原文地址:https://www.cnblogs.com/linjinzhuang/p/6598457.html
Copyright © 2020-2023  润新知