eexcelview

The extra output was due to my setup having multiple levels of views embedded in each other. By adding: private static function cleanOutput() { for($level=ob_get_level();$level>0;--$level) { @ob_end_clean(); } }

gleaned from the ErrorHandler and calling 'cleanOutput' in stead of 'ob_end_clean' inside 'run', document creation works better.

Hi I am now testing the extension ;-). Making it work for all users still requires some work ;-=.

Some reports on issues (maybe fixes later): - When adding the 'Export' button by adjusting the template, the button opens http://site/index.php?r=controller/actionexportType=Excel2007&grid_mode=export . The '&' is missing between 'action' and 'exportType'; I changed that to $content[] = CHtml::link($item['caption'], Yii::app()->controller->createUrl('',array_merge($_GET,array('exportType'=>$type,$this->grid_mode_var=>'export')))); But even then, the 'grid-id' information is missing from the link to make sure that the link is only applied to 1 grid on the page; - When exporting, any output "rendered" before getting to the grid rendering, and after the grid rendering, is also rendered. This invalidates the file format. It may be possible to clear the output buffer before the grid, and surely avoid the rendering after. - My 'buttons column' makes the 'export' fail. The error is '"CButtonColumn.value"' is not defined. The definition for this column looks like this: array( 'template' =>'{update}', 'header'=>Yii::t('app','header.configure'), 'buttons'=>array( 'update'=>array( 'click'=>'js:function(){updateAlert(jQuery(this).parents(".grid-view").first().attr("id"));return true;}', //'imageUrl'=>'', 'label'=>Yii::t('app','header.configure'), ), ), )

Well it was GPL first, then I updated the site with MIT but have forgotten to update the file. Feel free to use it under MIT license I will udate it .

Hi Thanks for the extension (I haven't tried it yet). The web page says 'MIT' license, but the file still says 'GPL'. Kind regards

thnx valery.merlet . I was thinking about adding some types of columns handling to the extension but I thought that it would be more easy to create callback functions so that you can do whatever custom modification to the the cell you want. So in your case you could just use onRenderDataCell(PHPExcel_Cell $cell, $data, string $value) and then $cell->setValueExplicit($value, PHPExcel_Cell_DataType::TYPE_STRING);

Anyway I may add your modification in the next release :) 10x for using EExcelView.

I needed to add an option to format the value of a cell. This option is useful for text that contains a value, but must remain a digital text format in the Excel file. Here's how I modified the method 'renderRow ()': start at row 147 in the file

if($column instanceof CLinkColumn)
{
    if($column->labelExpression!==null)
        $value=$column->evaluateExpression($column->labelExpression,array('data'=>$data[$row],'row'=>$row));
    else
        $value=$column->label;
} elseif($column->value!==null) 
    $value=$this->evaluateExpression($column->value ,array('data'=>$data[$row]));
elseif($column->name!==null) { 
    $value=$data[$row][$column->name];
    if ($column->type!='text') {
        $value=$value===null ? "" : $column->grid->getFormatter()->format($value,'raw');
    } else {
        $value = $value===null ? "" : $column->grid->getFormatter()->format($value,'text');
    }
}             
 
$a++;
if ($column->type=='text') {
    $cell = $this->objPHPExcel->getActiveSheet()->getCell($this->columnName($a).($row+2))->setValueExplicit($value, PHPExcel_Cell_DataType::TYPE_STRING);
} else {
    $cell = $this->objPHPExcel->getActiveSheet()->setCellValue($this->columnName($a).($row+2) , strip_tags($value), true);
}

Now i can use the property 'type' description column :

...
array(
    'name'=>'columnName',
    'value'=>$data=>columnValue,
    'type'=>'text',
)...

so that the value '09548 'is correctly written in the cell

Thanks, Now I can use it in commercial projects in my work.

I modified the license to MIT. Have a nice day :)

here is the extension, I just needed this to be able to run in console so I delayed it :) @undsoft well I can change the licence if that will make you happy. I dont realy care, I give it for free to the Yii comunity and want nothing in return. I'll be happy if it helps you and makes you life easier.

It's more then tomorrow already. Have you forgot about us? :)

Also, why do you user GPL license? Why not MIT or at least LGPL?

You may put it anywhere as long as it has path to it :) or you use path alias when creating the widget.

PP: I have removed the download of the extension since I found a minor bug :) I'll get it back online tomorrow.

Thanks for this extension, it looks like just what I needed, but where do I store EExcelView.php?

I have extracted PHPExcel at extensions/phpexcel/

Thanks.

Hi phreak, I uploaded some modifications to the code improved by francies, please take a look.

Forum link

Thanks!

Hi i modified eexcelview to support footer and db relationships http://francisja.tumblr.com/post/18486330299/extended-eexcelview-with-relational-database-and-footer

Hello i modified the code a little bit to add renderFooter functionality

paste.org/pastebin/view/40197

Please add installation documentation too.

Thanks.

Thank you for your efforts developing such a nice extension.

But I have a problem. I have column which holds a text consisting of a series of numbers so it will be automatically formatted as numerical value, i.e. 12.333E+12. Is there any way to prevent this?

Thanks

Thanks for the effort and to add a couple of suggestion I've made

Will try it as soon as I need again

Gustavo

Just posted a new version of the extension. I've used almost all of the recommendations you made and a couple of things from me. Please comment.

Hello

I made a new modification

incorporate relationships

the code is adapted from code zii

hopefully useful

see changes