release/controllers/changepublished.php
// 读取 excel 数据,存入数据库中
public function api_read_excel(){
$dir = dirname(__FILE__);//找到当前脚本所在路径
$fileName = $dir . "/director.xlsx";
// require_once '/libraries/PHPExcel/PHPExcel/IOFactory.php';
(这里使用的绝对路径)
$this->load->library('PHPExcel/IOFactory');
$this->load->library('PHPExcel/PHPExcel/IOFactory');
// 里面放的为 PHPExcel_IOFactory 所在的文件名
$objPHPExcel = PHPExcel_IOFactory::load($fileName);
//获取sheet表格数目
$sheetCount = $objPHPExcel->getSheetCount();
//默认选中sheet0表
$sheetSelected = 0;
$objPHPExcel->setActiveSheetIndex($sheetSelected);
//获取表格行数
$rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();
//获取表格列数
$columnCount = $objPHPExcel->getActiveSheet()->getHighe