源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

php读取excel文件的简单实例

  • 时间:2021-04-29 18:15 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:php读取excel文件的简单实例
[u]复制代码[/u] 代码如下:
     $this->loadexcel();//半酣phpexcel文件             $_ReadExcel = new PHPExcel_Reader_Excel2007();             if(!$_ReadExcel->canRead('link.xls')){             $_ReadExcel = new PHPExcel_Reader_Excel5();             }             $_phpExcel = $_ReadExcel->load('link.xls');             $sheetCount = $_phpExcel->getSheetCount();             $newExcel = array();             $excelData = array();             for($s = 0;$s<$sheetCount;$s++) {                 $currentSheet = $_phpExcel->getSheet($s);                 $allColumn = $currentSheet->getHighestColumn();                 $allRow = $currentSheet->getHighestRow();                 for($r = 1;$r<=$allRow;$r++){                     for($currentColumn='A';$currentColumn<=$allColumn;$currentColumn++){                         $address = $currentColumn.$r;                         $newExcel[] = $currentSheet->getCell($address)->getValue();                     }                 }             }
后面就是对数组的操作了--不过要先下载好phpexcel,并包含进来
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部