create Excel file in Phalcon php framework

Question

create Excel file in Phalcon php framework

nedim23 Oct '13

Created Oct '13	Last Reply Feb '16	Replies 5	Views 3204	Votes 1

nedim23 18.7k

Oct '13

I'm working in phalcon php framework and i am trying to create simple xsl file, but when i call my controller i get empty excel table. Can anyone tell me what is wrong in my code. Here is my method:

   public function createExcelAction(){

$loader = new \Phalcon\Loader();

   $loader->registerClasses(
     array(
    "PHPExcel"=>"C:/wamp/www/phalcon1/Classes/PHPExcel.php",
  "PHPExcel_Writer_Excel2007"=>"C:/wamp/www/phalcon1/Classes/PHPExcel/Writer/PHPExcel_Writer_Excel2007.php"
    )
     );
     $loader->register();
     $excel = new PHPExcel();
           //$excel = new PHPExcel();
    //activate worksheet number 1
    $excel->setActiveSheetIndex(0);
    //name the worksheet
    $excel->getActiveSheet()->setTitle('test worksheet');
    //set cell A1 content with some text

    $excel->getActiveSheet()->setCellValue('A1', 'Rezultati pretrage');
    $excel->getActiveSheet()->setCellValue('A2', "Ime");
    $excel->getActiveSheet()->setCellValue('C2', "Prezime");
    $excel->getActiveSheet()->setCellValue('F2', "Adresa stanovanja");

    $br = rand(0,1000000);
    $naziv = "Pobjeda-Rudet izvjestaj-".$br.".xls";
   //$filename='pobjeda_rudet.xlsx'; //save our workbook as this file name
       header('Content-Type: application/vnd.ms-excel'); //mime typež
     header('Content-Disposition: attachment;filename="'.$naziv.'"');
   // header('Content-Disposition: attachment;filename="'.$filename.'"'); 
      header('Cache-Control: max-age=0'); //no cache
     $objWriter = new PHPExcel_Writer_Excel2007($excel);
     $objWriter->save(str_replace('.php', '.xls', __FILE__));

1

Douglas Bezerra Possas · Answer 1 · 2013-10-10T11:55:34-07:00

Douglas Bezerra Possas
1.4k

Oct '13

Remove "header" instructions.

PHPExcel class to add the required information in the header

nedim23 · Answer 2 · 2013-10-10T13:42:06-07:00

can you provide me some example, how to add required info in header using PHPExcel, because i deal with this for the first time. Thanks in advace.

Douglas Bezerra Possas · Answer 3 · 2013-10-10T13:45:22-07:00

public function createExcelAction() { global $config;

    $loader = new \Phalcon\Loader();

    $loader->registerDirs(
        array(
            $config->application->libraryDir."PHPExcel/"
        )
    );

    // register autoloader
    $loader->register();

    $excel = new PHPExcel();
    $excel->setActiveSheetIndex(0);
    $excel->getActiveSheet()->setTitle('test worksheet');

    $excel->getActiveSheet()->setCellValue('A1', 'Rezultati pretrage');
    $excel->getActiveSheet()->setCellValue('A2', "Ime");
    $excel->getActiveSheet()->setCellValue('C2', "Prezime");
    $excel->getActiveSheet()->setCellValue('F2', "Adresa stanovanja");

    $br = rand(0,1000000);
    $naziv = $br.".xls";
    //$filename='pobjeda_rudet.xlsx'; //save our workbook as this file name
    //header('Content-Type: application/vnd.ms-excel'); //mime typež
    //header('Content-Disposition: attachment;filename="'.$naziv.'"');
    // header('Content-Disposition: attachment;filename="'.$filename.'"'); 
    //header('Cache-Control: max-age=0'); //no cache
    $objWriter = new PHPExcel_Writer_Excel2007($excel);
    $objWriter->save('../tmp/'.$naziv);

}

Douglas Bezerra Possas · Answer 4 · 2013-10-10T14:11:53-07:00

Douglas Bezerra Possas
1.4k

Oct '13

the tmp directory (in root folder project) needs to be writable

Douglas Bezerra Possas · Answer 5 · 2013-10-10T17:50:04-07:00

Douglas Bezerra Possas
1.4k

Oct '13

See more in https://stackoverflow.com/questions/19303339/create-excel-file-in-phalcon-php-framework

msecravi · Answer 6 · 2016-02-29T02:17:49-07:00

Create MyTags function name createExcelAction() Fatal error: Class 'PHPExcel' not found in /app/customhelpers/MyTags.php on line 1145