PHPExcelHelper could not be found. about excel HOT 6 CLOSED

In cakephp, you've to use autoloading. No require_once needed.
Did you load the plugin?
You have to add
Plugin::load('Cewi/Excel', ['bootstrap' => true, 'routes'=>true]);
in your bootstrap.php file.

from excel.

Yes this is my last line in bootstrap.php
Plugin::load('Cewi/Excel', ['bootstrap' => true, 'routes'=>true]);

I dont have problem when i use $this->loadComponent('Cewi/Excel.Import');

the problem is with public $helpers = ['Cewi/Excel.Excel']; when the helper call PHPExcel Helper.

No so much information i had check all the link in a google search. :(

from excel.

Hi Cewi,
I am trying something today. i followed this steps as you described
router.php
Router::extensions(['xlsx']);

ArticlesController:
public $helpers = ['Cewi/Excel.Excel'];

add a Folder 'xlsx' in Template/Articles and create the file 'index.ctp' in this Folder.
$this->Excel->addWorksheet($articles, 'Articles');

create the link to generate the file somewhere in your app:
Html->link(__('Excel'), ['controller' => 'Articles', 'action' => 'index', '_ext'=>'xlsx']); ?>

'_ext' is working as index.xlsx

and of course i am getting the error
Missing Method in ArticlesController public function index.xlsx()

Some advice please

from excel.

Can be something about this:

Deprecated since version 3.1.0: As of 3.1.0 the viewClassMap() method is deprecated. You should use config() to change the viewClassMap at runtime.
???

from excel.

Got it guys,

in router.php the line

Router::extensions(['xlsx']);

must be before the method Router::scope('/', function (RouteBuilder $routes) {}
Something like this:

router.php:

use Cake\Core\Plugin;
use Cake\Routing\RouteBuilder;
use Cake\Routing\Router;
use Cake\Routing\Route\DashedRoute;

Router::extensions(['xlsx']);

Router::defaultRouteClass(DashedRoute::class);
Router::scope('/', function (RouteBuilder $routes)
{
..
..
}

from excel.

that's true. If you want to use it inside a scope, you've to write $routes->extensions(['xlsx']); Will clear that in the doku.
Have fun!

from excel.