For God so loved the world, that He gave His only begotten Son, that all who believe in Him should not perish but have everlasting life
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

94 lines
3.3 KiB

  1. <?php
  2. /**
  3. * PHPExcel
  4. *
  5. * Copyright (c) 2006 - 2015 PHPExcel
  6. *
  7. * This library is free software; you can redistribute it and/or
  8. * modify it under the terms of the GNU Lesser General Public
  9. * License as published by the Free Software Foundation; either
  10. * version 2.1 of the License, or (at your option) any later version.
  11. *
  12. * This library is distributed in the hope that it will be useful,
  13. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  15. * Lesser General Public License for more details.
  16. *
  17. * You should have received a copy of the GNU Lesser General Public
  18. * License along with this library; if not, write to the Free Software
  19. * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
  20. *
  21. * @category PHPExcel
  22. * @package PHPExcel
  23. * @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
  24. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
  25. * @version ##VERSION##, ##DATE##
  26. */
  27. /** Error reporting */
  28. error_reporting(E_ALL);
  29. ini_set('display_errors', TRUE);
  30. ini_set('display_startup_errors', TRUE);
  31. date_default_timezone_set('Europe/London');
  32. define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
  33. date_default_timezone_set('Europe/London');
  34. include "05featuredemo.inc.php";
  35. /** PHPExcel_IOFactory */
  36. require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';
  37. // Change these values to select the Rendering library that you wish to use
  38. // and its directory location on your server
  39. //$rendererName = PHPExcel_Settings::PDF_RENDERER_TCPDF;
  40. //$rendererName = PHPExcel_Settings::PDF_RENDERER_MPDF;
  41. $rendererName = PHPExcel_Settings::PDF_RENDERER_DOMPDF;
  42. //$rendererLibrary = 'tcPDF5.9';
  43. //$rendererLibrary = 'mPDF5.4';
  44. $rendererLibrary = 'domPDF0.6.0beta3';
  45. $rendererLibraryPath = '/php/libraries/PDF/' . $rendererLibrary;
  46. echo date('H:i:s') , " Hide grid lines" , EOL;
  47. $objPHPExcel->getActiveSheet()->setShowGridLines(false);
  48. echo date('H:i:s') , " Set orientation to landscape" , EOL;
  49. $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
  50. echo date('H:i:s') , " Write to PDF format using {$rendererName}" , EOL;
  51. if (!PHPExcel_Settings::setPdfRenderer(
  52. $rendererName,
  53. $rendererLibraryPath
  54. )) {
  55. die(
  56. 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
  57. EOL .
  58. 'at the top of this script as appropriate for your directory structure'
  59. );
  60. }
  61. $callStartTime = microtime(true);
  62. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
  63. $objWriter->setSheetIndex(0);
  64. $objWriter->save(str_replace('.php', '_'.$rendererName.'.pdf', __FILE__));
  65. $callEndTime = microtime(true);
  66. $callTime = $callEndTime - $callStartTime;
  67. echo date('H:i:s') , " File written to " , str_replace('.php', '_'.$rendererName.'.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
  68. echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
  69. // Echo memory usage
  70. echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
  71. // Echo memory peak usage
  72. echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
  73. // Echo done
  74. echo date('H:i:s') , " Done writing files" , EOL;
  75. echo 'File has been created in ' , getcwd() , EOL;