Hello,

Do you have in your helper the following line ?
App::import('Vendor', 'PHPExcel/Classes/PHPExcel');

Assuming you put PHPExcel in APP.Vendor/PHPExcel

Cheers,
Rémi


On 9 October 2013 11:49, Rajkamal Ganesan
<[email protected]>wrote:

> Hi Friends,
>
>    I use PHPExcel library.
>
>    Controller :
>
>    public $helpers = array('PhpExcel');
>
>    View :
>
>    <?php
>                 $this->PhpExcel->createWorksheet();
> $this->PhpExcel->setDefaultFont('Calibri', 12);
>  $table = array(
> array('label' => __('Company'), 'width' => 'auto', 'filter' => true),
>  array('label' => __('city'), 'width' => 'auto', 'filter' => true),
> array('label' => __('phone'), 'width' => 'auto')
>  );
>         $this->PhpExcel->addTableHeader($table, array('name' => 'Cambria',
> 'bold' => true));
>  foreach ($contacts as $contact) {
> $this->PhpExcel->addTableRow(array(
> $contact['Contact']['company'],
>  $contact['Contact']['city'],
> $contact['Contact']['phone']
> ));
>  }
> $this->PhpExcel->addTableFooter();
> $this->PhpExcel->output();
>  ?>
>
>
>> Now i get
>
>
>
> Vendor class PHPExcel not found!
>
> *Error: *An Internal Error Has Occurred.
> Stack Trace
>
>    - APP\View\Helper\PhpExcelHelper.php line 
> 37<http://localhost/cake/target_crm/mis#>
>     → PhpExcelHelper->loadEssentials()<http://localhost/cake/target_crm/mis#>
>    - APP\View\Themed\Default\Mis\index.ctp line 
> 35<http://localhost/cake/target_crm/mis#>
>     → PhpExcelHelper->createWorksheet()<http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\View\View.php line 947<http://localhost/cake/target_crm/mis#>
>     → include(string) <http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\View\View.php line 909<http://localhost/cake/target_crm/mis#>
>     → View->_evaluate(string, array)<http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\View\View.php line 470<http://localhost/cake/target_crm/mis#>
>     → View->_render(string) <http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\Controller\Controller.php line 
> 947<http://localhost/cake/target_crm/mis#>
>     → View->render(null, null) <http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\Routing\Dispatcher.php line 
> 193<http://localhost/cake/target_crm/mis#>
>     → Controller->render() <http://localhost/cake/target_crm/mis#>
>    - CORE\Cake\Routing\Dispatcher.php line 
> 161<http://localhost/cake/target_crm/mis#>
>     → Dispatcher->_invoke(MisController, CakeRequest, 
> CakeResponse)<http://localhost/cake/target_crm/mis#>
>    - APP\webroot\index.php line 97 <http://localhost/cake/target_crm/mis#> → 
> Dispatcher->dispatch(CakeRequest,
>    CakeResponse)
>
> Now what i am doing? please help me.
> thanks,
> Rajkamal
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/R2eKtOcc-Qg/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to