PHPEXCEL导出语句

    define('EOL', '<br />');
    $objPHPExcel = new \app\extensions\PHPExcel\PHPExcel();
    ini_set("memory_limit", "1024M"); // 设置php可使用内存

    $cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
    if (!\PHPExcel_Settings::setCacheStorageMethod($cacheMethod)) {
        die($cacheMethod . " 缓存方法不可用" . EOL);
    }
    echo date('H:i:s'), " 当前使用的缓存方法是： ", $cacheMethod, " 方式", EOL;
    echo date('H:i:s'), " 开始设置文档属性", EOL;
    $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
            ->setLastModifiedBy("Maarten Balliauw")
            ->setTitle("Office 2007 XLSX Test Document")
            ->setSubject("Office 2007 XLSX Test Document")
            ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
            ->setKeywords("office 2007 openxml php")
            ->setCategory("Test result file");


    echo date('H:i:s'), " 开始添加单元格标题", EOL;
    $objPHPExcel->setActiveSheetIndex(0);
    $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");
    $objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");
    $objPHPExcel->getActiveSheet()->setCellValue('C1', "Phone");
    $objPHPExcel->getActiveSheet()->setCellValue('D1', "Fax");
    $objPHPExcel->getActiveSheet()->setCellValue('E1', "Is Client ?");
    
    // 设置单元格宽度
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
    
    /**
     * 左对齐与 右对齐
     * 可设置整列->getStyle('N')   可针对行rows设置getStyle('N3')
     */
    $objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
    $objPHPExcel->getActiveSheet()->getStyle('B3')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT);

    echo date('H:i:s'), " 设置隐藏C D列", EOL;
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
    $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);

    echo date('H:i:s'), " 设置大纲级别", EOL;
    $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
            ->setVisible(false)
            ->setCollapsed(true);

    /**
     * 开始添加数据
     */
    for ($i = 2; $i <= 50000; $i++) {
        $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
                ->setCellValue('B' . $i, "LName $i")
                ->setCellValue('C' . $i, "PhoneNo $i")
                ->setCellValue('D' . $i, "FaxNo $i")
                ->setCellValue('E' . $i, true);
    }

    $objPHPExcel->getActiveSheet()->setTitle('供应商信息');
    echo date('H:i:s'), " 设置格式为Excel2007版格式", EOL;
    $callStartTime = microtime(true);

    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
    $callEndTime = microtime(true);
    $callTime = $callEndTime - $callStartTime;

    echo date('H:i:s'), " 设置生成的文件为： ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
    echo date('H:i:s'), ' 写入Workbook中耗时 ', sprintf('%.4f', $callTime), " 秒", EOL;
    echo date('H:i:s'), ' 当前内存使用情况: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
    echo date('H:i:s'), " 内存使用峰值: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
    echo date('H:i:s'), " 完成写入文件", EOL;
    echo date('H:i:s'), ' 文件被创建在： ', getcwd(), '目录', EOL;