导出EXCEL

/**
 * 导出xls文件
 * @param $columns 列数
 * @param $data 二维数组数据
 * @param string $title 工作表名称
 * @param string $file_name 下载名称
 */
function export_excel($columns, $data, $title='sheet', $file_name='download_xls') {
    $rows = count($data);
    $cell_name = array();
    for ($i=0; $i<$columns; $i++) {
        if ($i<26) {
            $cell_name[$i] = chr($i + 65);
        } else {
            $cell_name[$i] = chr(intval($i/26)+64) . chr($i%26+65);
        }
    }
    vendor("PHPExcel.PHPExcel");
    $obj = new \PHPExcel();
    $cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
    \PHPExcel_Settings::setCacheStorageMethod($cacheMethod);
    //mergeCells 合并单元格
    for ($i=0; $i<$rows; $i++) {
        for ($j=0; $j<$columns; $j++) {
            if (isset($data[$i][$j])) {
                $obj->setActiveSheetIndex(0)->setCellValue($cell_name[$j].($i+1), $data[$i][$j]);
            }
        }
    }
    $obj->getActiveSheet()->setTitle($title);

    header('Content-Type: applicationnd.ms-excel');
    header('Content-Disposition: attachment;filename='.$file_name.'.xls');
    header('Cache-Control: max-age=0');
    $objWriter = \PHPExcel_IOFactory::createWriter($obj, 'Excel5');
    $objWriter->save('php://output');
    exit;
}