Guest User

Untitled

a guest
Nov 23rd, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. function createPDF($filename){
  2.  
  3. //PHPExcel
  4. require_once dirname(__FILE__) . '/plugin/PHPExcel/IOFactory.php';
  5.  
  6. $inputFile = dirname(__FILE__) . '/export/'.$filename.'.xls';
  7. $inputFileType = PHPExcel_IOFactory::identify($inputFile);
  8. $objReader = PHPExcel_IOFactory::createReader($inputFileType);
  9. $objPHPExcel = $objReader->load($inputFile);
  10. $objPHPExcel->setActiveSheetIndex(0);
  11.  
  12. $rendererName = PHPExcel_Settings::PDF_RENDERER_DOMPDF;
  13. $rendererLibrary = 'dompdf';
  14. $rendererLibraryPath = dirname(__FILE__) . '/plugin/'.$rendererLibrary;
  15.  
  16. if (!PHPExcel_Settings::setPdfRenderer($rendererLibrary,$rendererLibraryPath)){
  17. die(
  18. 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
  19. '<br />' .
  20. 'at the top of this script as appropriate for your directory structure'
  21. );
  22. }
  23.  
  24. header('Content-Type: application/pdf');
  25. header('Content-Disposition: attachement;filename="'.$filename.'"');
  26. header('Cache-Control: max-age=0');
  27. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
  28. $objWriter->save(str_replace('summaryOnLateReportSubmissions.php', 'export/' . $filename . '.pdf', __FILE__));
  29. return true;
Add Comment
Please, Sign In to add comment