/** * _output * * @param mixed $fileName * * @access protected * @return void */ function _output($fileName) { //$starting_pos = ord('C'); //unused header("Content-type: application/vnd.ms-excel"); header('Content-Disposition: attachment;filename=' . $fileName . ".xls"); header('Cache-Control: max-age=0'); $objWriter = new PHPExcel_Writer_Excel5($this->xls); $objWriter->setTempDir(TMP); $objWriter->save('php://output'); }
/** * Outputs export footer * * @return bool Whether it suceeded * * @access public */ function PMA_exportFooter() { global $workbook; global $tmp_filename; $tmp_filename = tempnam(realpath($GLOBALS['cfg']['TempDir']), 'pma_xls_'); $workbookWriter = new PHPExcel_Writer_Excel5($workbook); $workbookWriter->setTempDir(realpath($GLOBALS['cfg']['TempDir'])); $workbookWriter->save($tmp_filename); if (!PMA_exportOutputHandler(file_get_contents($tmp_filename))) { return FALSE; } unlink($tmp_filename); unset($GLOBALS['workbook']); unset($GLOBALS['sheet_index']); return TRUE; }
function generateBook($book, $format) { $this->book= $book; if (!$book->bookId) $bookName= "spreadsheet-1"; else $bookName= "spreadsheet-$book->bookId"; $filename= "default-".rand(1,9999); /*SET SPREADSHEET PROPERTIES*/ if ($format!= "ods"){ $this->objPHPExcel = new PHPExcel(); $this->objPHPExcel->getProperties()->setCreator("Maarten Balliauw"); $this->objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw"); $this->objPHPExcel->getProperties()->setTitle("Test Document"); $this->objPHPExcel->getProperties()->setSubject("Test Document"); $this->objPHPExcel->getProperties()->setDescription("Test document generated using PHP classes."); $this->objPHPExcel->getProperties()->setKeywords("office php"); $this->objPHPExcel->getProperties()->setCategory("Test result file"); } else{ $this->objPHPOds= new PHPOds(); //create a new ods file } /*GENERATE THE SHEETS*/ $this->_generateSheets($format); global $cnf; $currentDir= $cnf['path']['Temp']."/"; // Get the Storage Folder switch($format){ case "ods": saveOds($this->objPHPOds,"$filename.$format"); //save the object to a ods file break; case "pdf": $objWriter1 = new PHPExcel_Writer_PDF($this->objPHPExcel); $objWriter1->writeAllSheets(); $objWriter1->setTempDir($currentDir); $objWriter1->save("$filename.$format"); //save the object to a pdf file break; case "xls": $objWriter2 = new PHPExcel_Writer_Excel5($this->objPHPExcel); $objWriter2->setTempDir($currentDir); $objWriter2->save("$filename.$format"); //save the object to a xls file break; case "xlsx": $objWriter3 = PHPExcel_IOFactory::createWriter($this->objPHPExcel, 'Excel2007'); $objWriter3->save($currentDir."$filename.$format"); //save the object to a xlsx file break; case "csv": $objWriter4 = new PHPExcel_Writer_CSV($this->objPHPExcel); //$objWriter4->setTempDir($currentDir); $objWriter4->setDelimiter(';'); $objWriter4->setEnclosure(''); $objWriter4->setLineEnding("\r\n"); $objWriter4->save("$filename.$format"); //save the object to a CSV file break; case "html": $objWriter5 = new PHPExcel_Writer_HTML($this->objPHPExcel); $objWriter5->writeAllSheets(); //$objWriter5->setTempDir($currentDir); $objWriter5->save("$filename.$format"); //save the object to a HTML file break; } if ($format != "ods") $this->_send("$filename.$format", $format, $bookName); }
public function execute(Request $request, Response $response) { $courseID = $request->getParameter("courseID"); $customerID = $request->getParameter("customerID"); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('Benutzer'); $filename = ""; $titel = ""; //get users $currentRow = 4; if ($courseID === "all") { $filename = "Nutzerliste_" . $_SESSION["CURRENT_CUSTOMER_NAME"] . "_" . date("d-m-Y", time()) . ".xls"; $titel = "E-Learning Benutzliste des Unternehmen " . $_SESSION["CURRENT_CUSTOMER_NAME"]; foreach ($GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getAllEmployees($customerID) as $employeeID => $employeeName) { $password = "******"; if ($GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->isGeneratedPassword($employeeID)) { $password = $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getGeneratedPassword($employeeID); } $email = $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserEmail($employeeID); $date = date("d.m.Y", $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getObjCreationDate($employeeID)); if ($email === false) { $email = ""; } $objPHPExcel->getActiveSheet()->SetCellValue("A" . $currentRow, $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserFirstName($employeeID)); $objPHPExcel->getActiveSheet()->SetCellValue("B" . $currentRow, $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserLastName($employeeID)); $objPHPExcel->getActiveSheet()->SetCellValue("C" . $currentRow, $email); $objPHPExcel->getActiveSheet()->SetCellValue("D" . $currentRow, $employeeName); $objPHPExcel->getActiveSheet()->SetCellValue("E" . $currentRow, $password); $objPHPExcel->getActiveSheet()->SetCellValue("F" . $currentRow, $date); $currentRow++; } } else { $filename = "Nutzerliste_" . $_SESSION["CURRENT_CUSTOMER_NAME"] . "_" . $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getObjectName($courseID) . "_" . date("d-m-Y", time()) . ".xls"; $titel = "E-Learning Benutzliste des Unternehmen " . $_SESSION["CURRENT_CUSTOMER_NAME"] . " - " . $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getObjectDesc($courseID) . " (" . $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getObjectName($courseID) . ")"; foreach ($GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getCourseParticipants($courseID) as $employeeID => $employeeName) { $password = "******"; if ($GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->isGeneratedPassword($employeeID)) { $password = $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getGeneratedPassword($employeeID); } $email = $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserEmail($employeeID); if ($email === false) { $email = ""; } $objPHPExcel->getActiveSheet()->SetCellValue("A" . $currentRow, $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserFirstName($employeeID)); $objPHPExcel->getActiveSheet()->SetCellValue("B" . $currentRow, $GLOBALS["USERMANAGEMENT_DATA_ACCESS"]->getUserLastName($employeeID)); $objPHPExcel->getActiveSheet()->SetCellValue("C" . $currentRow, $email); $objPHPExcel->getActiveSheet()->SetCellValue("D" . $currentRow, $employeeName); $objPHPExcel->getActiveSheet()->SetCellValue("E" . $currentRow, $password); $currentRow++; } } // Excel header $objPHPExcel->getActiveSheet()->SetCellValue("A1", $titel); $objPHPExcel->getActiveSheet()->SetCellValue("A2", "Stand " . date("d.m.Y", time())); $objPHPExcel->getActiveSheet()->SetCellValue("A3", "Vorname"); $objPHPExcel->getActiveSheet()->SetCellValue("B3", "Nachname"); $objPHPExcel->getActiveSheet()->SetCellValue("C3", "Email"); $objPHPExcel->getActiveSheet()->SetCellValue("D3", "Benutzerkennung"); $objPHPExcel->getActiveSheet()->SetCellValue("E3", "Passwort"); $objPHPExcel->getActiveSheet()->SetCellValue("F3", "Erstellungsdatum"); $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); $objWriter->setTempDir(PATH_TEMP); $objWriter->save(PATH_TEMP . $filename); $myFile = PATH_TEMP . $filename; $fh = fopen($myFile, 'r'); $theData = fread($fh, filesize($myFile)); fclose($fh); header('Content-type: text/plain'); header('Content-Disposition: attachment; filename="' . $filename . '"'); echo $theData; exit; }
public function exportAction() { SxCms_Acl::requireAcl('subscriptions', 'subscription.export'); $event_id = $this->_getParam('id'); $eventMapper = new SxCms_Event_DataMapper(); $event = $eventMapper->getEventById($event_id); $subProxy = new SxCms_Event_Subscription_DataMapper(); $subscriptions = $subProxy->getValidSubscriptionsForEvent($event_id); $fieldProxy = new SxCms_Event_Field_DataMapper(); $fields = $fieldProxy->getFieldsByEvent($event_id); $objPHPExcel = new PHPExcel(); $objPHPExcel->createSheet("Event Subsciptions"); $objPHPExcel->setActiveSheetIndex(0); $objPHPSheet = $objPHPExcel->getActiveSheet(); $objPHPSheet->setCellValueByColumnAndRow(0, 1, $this->admin_tmx->_('subscriptionsforevent') . $event->getTitle()); $i = 0; foreach ($fields as $field) { $objPHPSheet->setCellValueByColumnAndRow($i, 2, $field->getLabel()); $i++; } $j = 3; foreach ($subscriptions as $subscription) { $i = 0; foreach ($fields as $field) { $objPHPSheet->setCellValueByColumnAndRow($i, $j, $subscription[$field->getName()]); $i++; } $j++; } $file = "sub_" . date("d_m_Y") . ".xls"; header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment; filename={$file}"); header("Content-Transfer-Encoding: binary"); error_reporting(0); $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); $objWriter->setTempDir(APPLICATION_ROOT . '/tmp'); $objWriter->save("php://output"); die; }
/** * _output * * @param mixed $title * * @access protected * @return void */ function _output($title) { header("Content-type: application/vnd.ms-excel"); header('Content-Disposition: attachment;filename="'.$title.'.xls"'); header('Cache-Control: max-age=0'); $objWriter = new PHPExcel_Writer_Excel5($this->xls); $objWriter->setTempDir(TMP); $objWriter->save('php://output'); }