robotusers/cakephp-excel

CakePHP Spreadsheet (Excel) plugin.

cakephp-excel's Issues

Add support for column callbacks while reading data from excel file.

Graphs

It's possible to export other than data to file also a graph?

Deprecated method "config()" in /config/bootstrap.php

Error:
Deprecated (16384): Cake\Datasource\ConnectionManager::config() is deprecated. Use setConfig()/getConfig() instead. - /var/www/html/public/vendor/robotusers/cakephp-excel/config/bootstrap.php, line: 33

Export

Is there a possibility, of doing the process to the contrary, make a find in the table and write in the file? In the case it would be a data export

Remove deprecated method calls.

This would make the plugin 3.6 only though. Should it be targetted for 1.0.0 release?

Add Plugin class.

Refs cakephp/cakephp#11687

"The plugin class Robotusers\Excel\Plugin cannot be found. Ensure your autoloader is correct."

Hello,
I've followed your steps to get this plugin working with CakePHP 3.6, running PHP 7.2, those two first steps to get this excel plugin working.

All I keep getting is
The plugin class Robotusers\Excel\Plugin cannot be found. Ensure your autoloader is correct.

I executed
composer require robotusers/cakephp-excel

Added to config/bootstrap.php:
Plugin::load('Robotusers/Excel', [ 'bootstrap' => true, ]);

In my src/Application.php

public function bootstrap()
    {
        // Call parent to load bootstrap from files.
        parent::bootstrap();
        $this->addPlugin('Robotusers/Excel');
    }

In my controller:

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

public function excel()
        {
            $registry = Registry::instance();
            $table = $registry->get('records.xlsx', 'efproducts_products', [
                'primaryKey' => 'id',
                'columnMap' => [
                    'A' => 'project_name',
                    'B' => 'ef_type',
                    'C' => 'product_description'
                ]
            ]);
        }

But I keep getting the error explained above.
What am I missing?

Thank you,
James

Nice work. Appreciated

Add an option to set custom reader/writer.

Looks like PHPExcel would default to CSV writer while working with empty files without the extension.

Error: The datasource configuration excel was not found in config\app.php

Hi,
I'm following the first steps to get the plugin working, but I'm receiving an error message Error: The datasource configuration excel was not found in config\app.php. Could someone help me to understand what is wrong?

This is my snippet code

use Robotusers\Excel\Registry;

...

$registry = Registry::instance();
$table = $registry->get($filePath, 'Clientes');
$row = $table->find()->first()->toArray();
print_r($row);

Add support for phpoffice/phpspreadsheet

phpoffice/phpexcel is abandoned, use phpoffice/phpspreadsheet instead.

Create Excel file on the fly

Friend It is not an issue, I want to know how i can use this plugin to generate excel file on the fly. I do not want to save file on server. It take data from database and write in spreadsheet and available user for download

Your quick response is appricited