add Title before the column header

[rangganovsky]

i think, it would be nice addition to this great extension if we can add some title before the column header.

and also if possible, we can decide/format where to put it. so i imagine that, we can add any kind of information (it could be title, date time, etc) before we render the column header. as the most of the excel report need to have a some title or date.

what do you think? is it possible for that?

[mysoundmagic]

is features such as the above, already at version 1.1.10 ?

[ebraho]

Adding a title before table:

in tlbExcelView.php add the following code:

public $reportTitle = '';
.
.
.
public function run(){
   $styleTitle = array(
      'font'=>array(
                'bold'=>true,
                'size'=>'20',
         )
   );

   self::$activeSheet
      ->insertNewRowBefore(1, 3) //insert 3 rows before the table
      ->setCellValue('A'.'2', $this->reportTitle)
      ->mergeCells('A2:C2'); //or more if the title is too long
   self::$activeSheet
      ->getStyle('A2')->applyFromArray($styleTitle);
.
.
.

then in the view where you call the tlbexcelview widget, add the new attribute:

$this->widget('application.components.widgets.tlbExcelView', array(
.
.
.
'reportTitle' => 'Set the title of your report here',
.
.
.

The same way you can add other attributes like DATE or whatever