Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once dirname(__FILE__) . '/Classes/PHPExcel.php';
- require_once dirname(__FILE__) . '/Classes/PHPExcel/IOFactory.php';
- class AdminGafController extends AdminController
- {
- public function setMedia() {
- parent::setMedia();
- Tools::addJS(_THEME_JS_DIR_.'gaf.js');
- }
- public function initContent()
- {
- parent::initContent();
- $smarty = $this->context->smarty;
- if(isset($_POST["status"]))
- {
- $idas = $_POST["idas"];
- $status= $_POST["status"];
- // Create new PHPExcel object
- $objPHPExcel = new PHPExcel();
- // Set document properties
- $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
- ->setLastModifiedBy("Maarten Balliauw")
- ->setTitle("Office 2007 XLSX Test Document")
- ->setSubject("Office 2007 XLSX Test Document")
- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
- ->setKeywords("office 2007 openxml php")
- ->setCategory("Test result file");
- // Add some data
- $objPHPExcel->setActiveSheetIndex(0)
- ->setCellValue('A1', 'Hello')
- ->setCellValue('B2', 'world!')
- ->setCellValue('C1', 'Hello')
- ->setCellValue('D2', 'world!');
- // Miscellaneous glyphs, UTF-8
- $objPHPExcel->setActiveSheetIndex(0)
- ->setCellValue('A4', 'Miscellaneous glyphs')
- ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
- // Rename worksheet
- $objPHPExcel->getActiveSheet()->setTitle('Simple');
- // Set active sheet index to the first sheet, so Excel opens this as the first sheet
- $objPHPExcel->setActiveSheetIndex(0);
- $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
- $objWriter->save('php://output');
- }
- $smarty->assign("custdata", $custdata);
- $smarty->assign("editid", $editid);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement