vdomah / octoexcel Goto Github PK

after composer require maatwebsite/excel:3.1 on OC 2, the install does not happen

Problem 1
    - Root composer.json requires maatwebsite/excel 3.1 -> satisfiable by maatwebsite/excel[3.1.0].
    - maatwebsite/excel 3.1.0 requires illuminate/support ^5.5 -> found illuminate/support[v5.5.0, ..., 5.8.x-dev] but these were not loaded, likely because it conflicts with another require.

and if I tried to install on OC v1.1, it crashes the whole backend

When i try to install the plugin,

PHP Fatal error: Uncaught TypeError: Argument 2 passed to Illuminate\Support\Arr::first() must be callable, null given, called in /var/www/ea/plugins/vdomah/excel/vendor/illuminate/support/Collection.php on line 338 and defined in /var/www/ea/vendor/laravel/framework/src/Illuminate/Support/Arr.php:150

edit:
It looks like in this particual server configuration, october is mixing illuminate/support classes from laravel/framework/src and vdomah/excel/vendor

hi, as u wrote at documentation, on octobercms build 469 is unable to install
composer require maatwebsite/excel:3.1

some help?

Problem 1 - Installation request for maatwebsite/excel 3.1 -> satisfiable by maatwebsite/excel[3.1.0]. - Conclusion: remove laravel/framework v6.18.40 - Conclusion: don't install laravel/framework v6.18.40 - maatwebsite/excel 3.1.0 requires illuminate/support ^5.5 -> satisfiable by illuminate/support[5.5.x-dev, 5.6.x-dev, 5.7.17, 5.7.18, 5.7.19, 5.7.x-dev, 5.8.x-dev, v5.5.0, v5.5.16, v5.5.17, v5.5.2, v5.5.28, v5.5.33, v5.5.34, v5.5.35, v5.5.36, v5.5.37, v5.5.39, v5.5.40, v5.5.41, v5.5.43, v5.5.44, v5.6.0, v5.6.1, v5.6.10, v5.6.11, v5.6.12, v5.6.13, v5.6.14, v5.6.15, v5.6.16, v5.6.17, v5.6.19, v5.6.2, v5.6.20, v5.6.21, v5.6.22, v5.6.23, v5.6.24, v5.6.25, v5.6.26, v5.6.27, v5.6.28, v5.6.29, v5.6.3, v5.6.30, v5.6.31, v5.6.32, v5.6.33, v5.6.34, v5.6.35, v5.6.36, v5.6.37, v5.6.38, v5.6.39, v5.6.4, v5.6.5, v5.6.6, v5.6.7, v5.6.8, v5.6.9, v5.7.0, v5.7.1, v5.7.10, v5.7.11, v5.7.15, v5.7.2, v5.7.20, v5.7.21, v5.7.22, v5.7.23, v5.7.26, v5.7.27, v5.7.28, v5.7.3, v5.7.4, v5.7.5, v5.7.6, v5.7.7, v5.7.8, v5.7.9, v5.8.0, v5.8.11, v5.8.12, v5.8.14, v5.8.15, v5.8.17, v5.8.18, v5.8.19, v5.8.2, v5.8.20, v5.8.22, v5.8.24, v5.8.27, v5.8.28, v5.8.29, v5.8.3, v5.8.30, v5.8.31, v5.8.32, v5.8.33, v5.8.34, v5.8.35, v5.8.36, v5.8.4, v5.8.8, v5.8.9]

Can you please remove the "!!!" from the version file?

Update Failed

A syntax error was detected in /var/www/html/plugins/vdomah/excel/updates/version.yaml. The string "!!! Migration to Maatwebsite.Laravel-Excel version 3.x." could not be parsed as it uses an unsupported built-in tag at line 7 (near "3.0.1: !!! Migration to Maatwebsite.Laravel-Excel version 3.x.") at line 43 (near "/var/www/html/vendor/october/rain/src/Parse/Yaml.php").

Problem descriptions

When making a standard export, exceptions are thrown because of incompatibility of Vdomah\Excel\Classes\XlsxStyled class with PhpOffice\PhpSpreadsheet\Reader\IReader class (as present in Maatwebsite\Excel in version 3.1)

Solution

Adjust method declaration according to inherited class:
Line 76:
public function canRead(string $pFilename) : bool
Line 325:
public function load(string $pFilename, int $flags = 0)

@vdomah you need to release a new version bump so that the marketplace server can rebuild your plugin package (including the dependencies) and people can update to the rebuilt plugin as your plugin version currently on the marketplace embeds a version of illuminate/support that is incompatible with the current version of October: octobercms/october#4009

Keep having this error , using OC 472

[2021-05-08 04:11:01] development.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Interface 'Maatwebsite\Excel\Concerns\FromCollection' not found in /Users/toto/Sites/oc-pcf/plugins/voilaah/pcf/classes/ExportSubmissions.php:12

Recently Im getting error for latest october build + octoexcel

Class '\Maatwebsite\Excel\ExcelServiceProvider' not found

No special things, just its a fresh install.

Im trying this simple code

use Vdomah\Excel\Classes\Excel;
use Vdomah\Excel\Classes\ExportExample;
function onStart()
{
    return Excel::export(ExportExample::class, 'my_export_filename');
}

Error in plugin due to outdated dependency in vendor
Octobercms Build 446

Declaration of Illuminate\Mail\Mailer::queue($view, $queue = NULL) must be compatible with Illuminate\Contracts\Mail\MailQueue::queue($view, array $data, $callback, $queue = NULL)

To reproduce try sending email through Mailer::send()

Please update your plugin for the same.

How can I use this to save the exported file to disk?

Hello,
When I try to export from CMS templates code section it is not downloading a file, it just returns raw data. What I am doing wrong?
Here is my code:

use Vdomah\Excel\Classes\Excel;
use Acme\Test\Models\User;
function onExportExcel(){
Excel::excel()->create('users', function($excel) {
$excel->sheet('Sheet', function($sheet) {
$model = User::get();
$sheet->fromModel($model);
});
})->download('csv');
}

Hi,

i'm using this plugin since a long time, and since few months, i'm upgrading my websites to OctoberCMS v2.0
Today, i had to deploy this plugin to a website, unfortunately, it didn't work well.

My import code is like this :

Excel::excel()->import(new ModelImport, 'file.csv');

and i have this error showing :
Declaration of Vdomah\Excel\Classes\XlsxStyled::load(string $pFilename, int $flags = 0) must be compatible with PhpOffice\PhpSpreadsheet\Reader\BaseReader::load(string $filename, int $flags = 0): PhpOffice\PhpSpreadsheet\Spreadsheet

so, to fixed this, i tried to disabled row 25 in Vdomah\Excel\Classes\Excel

//\PhpOffice\PhpSpreadsheet\IOFactory::registerReader('xlsx_styled', XlsxStyled::class);

and all works fine now.
Did somebody already had this error ?

thanks
Lucas.

Good afternoon, I tried several alternatives, but I can not install Maatwebsite\Excel in October.
I need a help.

can we just add more file type to following array to get it working?

    public static function export($class, $filename, $type = 'csv')
    {
        if (! in_array($type, ['xls', 'csv'])) {
            $type = 'csv';
        }

        $fn = $filename;

        return self::excel()->download(new $class, $fn.'.'.$type);
    }

why its only limited to ['xls', 'csv']
can we just allow whats passed as an argument from export method?

I guess it does support many types

Hi, could you please help me? I have created new plugin and run:

composer require maatwebsite/excel:~2.1.0

but I'm getting:

[Symfony\Component\Debug\Exception\FatalErrorException]
  Class Illuminate\View\Factory contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (Illuminate\Contracts\View\Factory::replaceNamespace)

So I tried:

composer dump autoload in root and also in plugin directory, but didn't helps.

There is some magic, that your vendor directory contains Laravel 5.2 libraries and mine vendor contains Laravel 5.4. My PHP version is 5.6.

Do you know, where could be my fail? Thanks a lot

Recently it stopped working on all of my sites. Its throwing error

Call to undefined method Vdomah\Excel\Classes\Excel::create()

I'm using it as:

function onStart()
{
    use Vdomah\Excel\Classes\Excel; //earlier was working without this
    $users =  RainLab\User\Models\User::all();
    $userArray = $users->toArray();

    Excel::create('ISBM-Staff', function($excel) use($userArray){

    $excel->sheet('User-List', function($sheet) use($userArray) {

        $sheet->fromArray($userArray);

    });

	})->download('xls');
}