1.下载
https://github.com/JOakley77/CI-Excel-Generation-Library
2.解压,并复制 Excel.php, 找到项目的 libraries 文件夹粘贴,不是 sysm\libraries这个文件夹,如果没有就新建一个,
3.具体操作
引用类库
$this->load->library('Excel');
处理要导出数据
$array = array(); $titles = array( iconv("UTF-8", "GBK", '登录时间'), iconv("UTF-8", "GBK", '登录IP'), ); foreach ($logs as $logsKey => $logsVal){ $array[] = array( iconv("UTF-8", "GBK", date('Y-m-d',$logsVal['time'])), iconv("UTF-8", "GBK", $logsVal['IP']), ); }
输出(下载导出数据)
$this->excel->make_from_array($titles, $array);
自己瞎折腾
自定义导出文件名称
$this->excel->filename = '-登陆日志-'.date('Y-m-d');