excel

    $xls = new PHPExcel();


    $baseFont = array(
        'font'=>array(
                'bold'=>false
        )
    );
    $boldFont = array(
        'font'=>array(
                'bold'=>true
        )
    );

    $xls->setActiveSheetIndex(0);
    $aSheet = $xls->getActiveSheet();
    $aSheet->setTitle('регионы');
    //устанавливаем данные
    //номера по порядку
    $aSheet->getColumnDimension('A')->setWidth(15);
    $aSheet->getColumnDimension('B')->setWidth(45);
    $aSheet->getColumnDimension('C')->setWidth(45);
    $aSheet->getColumnDimension('D')->setWidth(45);

    $aSheet->setCellValue('A1','№ п/п');
    $aSheet->getStyle('A1')->applyFromArray($boldFont);

    $aSheet->setCellValue('B1', "Регион");
    $aSheet->getStyle('B1')->applyFromArray($boldFont);

    $aSheet->setCellValue('C1', "Количество анкет");
    $aSheet->getStyle('C1')->applyFromArray($boldFont);

    $items = $Methods->get_region_count(); //данные для выгрузки
    $i = 2; $n = 1;
    foreach($items as $item)
    {
        $aSheet->setCellValue('A'.$i, $n++);
        $aSheet->getStyle('A'.$i)->applyFromArray($baseFont);

        $name = (array_key_exists($item["region_id"], $distr_arr))?$distr_arr[$item["region_id"]]:"";
        $aSheet->setCellValue('B'.$i, $name);
        $aSheet->getStyle('B'.$i)->applyFromArray($baseFont);

        $aSheet->setCellValue('C'.$i, $item["rows"]);
        $aSheet->getStyle('C'.$i++)->applyFromArray($baseFont);
    }
    $file_name = 'регионы.xls';
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="'.$file_name);
    header('Cache-Control: max-age=0');

    $objWriter = PHPExcel_IOFactory::createWriter($xls, 'Excel2007');
    $objWriter->save('php://output');
    exit();
    unset($xls);