Advertisement
Guest User

php

a guest
Feb 10th, 2015
267
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.86 KB | None | 0 0
  1. <?php
  2.  
  3. require_once dirname(__FILE__) . '/Classes/PHPExcel.php';
  4. require_once dirname(__FILE__) . '/Classes/PHPExcel/IOFactory.php';
  5.  
  6. class AdminGafController extends AdminController
  7.     {
  8.         public function setMedia() {
  9.             parent::setMedia();
  10.             Tools::addJS(_THEME_JS_DIR_.'gaf.js');
  11.       }
  12.        
  13.         public function initContent()
  14.         {
  15.             parent::initContent();
  16.             $smarty = $this->context->smarty;
  17.            
  18.         if(isset($_POST["status"]))
  19.         {
  20.        
  21.         $idas = $_POST["idas"];
  22.         $status= $_POST["status"];
  23.        
  24.  // Create new PHPExcel object
  25. $objPHPExcel = new PHPExcel();
  26.  
  27. // Set document properties
  28. $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
  29.                              ->setLastModifiedBy("Maarten Balliauw")
  30.                              ->setTitle("Office 2007 XLSX Test Document")
  31.                              ->setSubject("Office 2007 XLSX Test Document")
  32.                              ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
  33.                              ->setKeywords("office 2007 openxml php")
  34.                              ->setCategory("Test result file");
  35.  
  36. // Add some data
  37. $objPHPExcel->setActiveSheetIndex(0)
  38.             ->setCellValue('A1', 'Hello')
  39.             ->setCellValue('B2', 'world!')
  40.             ->setCellValue('C1', 'Hello')
  41.             ->setCellValue('D2', 'world!');
  42.  
  43. // Miscellaneous glyphs, UTF-8
  44. $objPHPExcel->setActiveSheetIndex(0)
  45.             ->setCellValue('A4', 'Miscellaneous glyphs')
  46.             ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
  47.  
  48. // Rename worksheet
  49. $objPHPExcel->getActiveSheet()->setTitle('Simple');
  50.  
  51. // Set active sheet index to the first sheet, so Excel opens this as the first sheet
  52. $objPHPExcel->setActiveSheetIndex(0);
  53.  
  54. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
  55. $objWriter->save('php://output');
  56.        
  57.         }
  58.         $smarty->assign("custdata", $custdata);
  59.         $smarty->assign("editid", $editid);
  60.         }  
  61.    }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement