[EXTENSION]eexcelview

Yii 1.1 Extensions
101

Yes. You would do so in the same manner as rendering multiple grids on the same page, which is by passing a different dataProvider object.

102

Hi,This is my controller code i cannot get the downloaded file in excel using this extension can anyone help me




public function actionExcel() {

        $model=new News('search');

    

               

              

        $this->widget('EExcelView', array(

     'dataProvider'=> $model->search(),

     'title'=>'My CSV File',

     'autoWidth'=>false,

            'grid_mode' => 'export',

            'title' => 'News Analytics',

            'filename' => 'report.xlsx',

            'stream' =>false,

            'exportType' =>'Excel2007',

//	'filter'=>$model,

            'columns' => array(

//		'pkreportid',

                array('header' => 'Sr#',

                    'value' => '$this->grid->dataProvider->pagination->offset + $row+1',

                ),

                array(

                    'header' => 'News Paper Name',

                    'name' => 'fknewspaperid',

                    'value' => '$data->Newspapername->newspapername',

                ),

                'headline',

                'pageno',

                'reportername',

                'city',

                array(

                    'header' => 'Date',

                    'name' => 'reportdate',

                ),

                array(

                    'header' => 'News Analyst',

                    'name' => 'fkuserid',

                    'value' => '$data->User->username',

                ),

            /*

              'fkcityid',

              'reportinggaps',

              'bridginggapsinfo',

              'publicbody',

              'fklawid',

             */

            ),

        ));

       

         Yii::app()->end();


    }

This code just give me a gridview on html page how to export it in excel

103

Hello, is this extension still maintained?

104

please can anyone tell how to add header,title to the excel sheet using this extension.

I am trying out from two days please help me,i have saw many examples nothing worked out.Help this poor newbie

Thank You In Advance.

105

Hi,

I have lot’s of records in my table and when I try to download it as a excel using this extension. It causes my server to shut down. So basically I am unable to export large files using this extension. My Grid contains data from different tables.

So how do I download large files using this extension.

106

Thanks a lot sir, it worked.

but when my grid is updated it wont export the updated data, can you help me with that.

Thanks again

107

I am currently using 1.8.0 phpexcel…but this little bit tricky…

1.8.0 does not have inbuild pdf library so we have to load external library like mpdf , htmlpdf, tcpdf

so download from any one vendor site and copy the folder into /protected/vendor folder

Then goto eexcelview init method and replace with this code.

what i did here is simple

i am loading [size="2"]rendererName[/size][size="2"] and [/size][size="2"]rendererLibraryPath[/size][size="2"] , then i am calling [/size][size="2"]setPdfRenderer of phpexcel… It will inform [/size]

[size=“2”]hi phpexcel i am going to use mpdf and you can load library from this renderer path :)[/size]

[size="2"]Have Fun[/size]





public function init()

		{

			if(isset($_GET[$this->grid_mode_var]))

				$this->grid_mode = $_GET[$this->grid_mode_var];

			if(isset($_GET['exportType']))

				$this->exportType = $_GET['exportType'];


			$lib = Yii::getPathOfAlias($this->libPath).'.php';

			if($this->grid_mode == 'export' and !file_exists($lib)) {

				$this->grid_mode = 'grid';

				Yii::log("PHP Excel lib not found($lib). Export disabled !", CLogger::LEVEL_WARNING, 'EExcelview');

			}


			if($this->grid_mode == 'export')

			{

				$this->title = $this->title ? $this->title : Yii::app()->getController()->getPageTitle();

				$this->initColumns();

				//parent::init();

				//Autoload fix

				spl_autoload_unregister(array('YiiBase','autoload'));

				Yii::import($this->libPath, true);


				$this->objPHPExcel = new PHPExcel();

				$rendererName = PHPExcel_Settings::PDF_RENDERER_MPDF;

				$rendererLibraryPath = Yii::app()->basePath . '/vendor/mpdf60';

				//  Here's the magic: you __tell__ PHPExcel what rendering engine to use

				// 	and where the library is located in your filesystem

				if (!PHPExcel_Settings::setPdfRenderer($rendererName,$rendererLibraryPath)) {

					die('NOTICE: Please set the $rendererName and $rendererLibraryPath values' .

							'<br />' .

							'at the top of this script as appropriate for your directory structure'

					);

				}


				spl_autoload_register(array('YiiBase','autoload'));

				// Creating a workbook

				$this->objPHPExcel->getProperties()->setCreator($this->creator);

				$this->objPHPExcel->getProperties()->setTitle($this->title);

				$this->objPHPExcel->getProperties()->setSubject($this->subject);

				$this->objPHPExcel->getProperties()->setDescription($this->description);

				$this->objPHPExcel->getProperties()->setCategory($this->category);

			} else

				parent::init();

		}

I hope it will help others who are trying to upgrade 1.7 phpexcel to 1.8.0 (only pdf required this settings)