$row_id++; } } // create new sheet $objPHPExcel->createSheet(NULL, $sheetId); // Rename worksheet $question_number = $sheetId + 1; $objPHPExcel->getActiveSheet()->setTitle("Group" . $sheetId); // increase sheet id $sheetId++; } // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $question->getTitle() . '.xls"'); header('Cache-Control: max-age=0'); // If you're serving to IE 9, then the following may be needed header('Cache-Control: max-age=1'); // If you're serving to IE over SSL, then the following may be needed header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified header('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header('Pragma: public'); // HTTP/1.0 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); exit;
ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); date_default_timezone_set('Europe/Sofia'); if (PHP_SAPI == 'cli') { die('This example should only be run from a Web Browser'); } /** Include PHPExcel */ require_once dirname(__FILE__) . '/Classes/PHPExcel.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("SU Survey")->setLastModifiedBy("SU Survey")->setTitle("SU Survey - Question report")->setSubject("SU Survey - Question report")->setDescription("SU Survey - Question report")->setKeywords("Sofia University,Survey,Question,System,Results")->setCategory("Question Report"); // set sheet id $sheetId = 0; $objPHPExcel->setActiveSheetIndex($sheetId)->mergeCells('A1:N1'); $objPHPExcel->setActiveSheetIndex($sheetId)->setCellValue('A1', $question->getTitle()); // spread answers throught columns function divideBy26($numberColumns) { global $alphas; if ($numberColumns > 0) { $reminder = $numberColumns % 26; if ($reminder != 0) { $reminderChar = $alphas[$reminder]; $floor = floor($numberColumns / 26); } else { $reminder = 26; $reminderChar = $alphas[$reminder]; $floor = floor($numberColumns / 26); $floor--; }