KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Koolreport 4.3: Class 'koolreport\excel\Spreadsheet' not found #1149

Open sevgi opened this topic on on Nov 12, 2019 - 8 comments

sevgi commented on Nov 12, 2019

Koolreport upgrade is export excel in Fatal error: Uncaught Error: Class 'koolreport\excel\Spreadsheet' not found in /report/koolreport/core/packages/excel/ExcelExportable.php:74 Stack trace: #0 /report/export.php(12): ticket->exportToExcel('ticketReport') #1 {main} thrown in/report/koolreport/core/packages/excel/ExcelExportable.php on line 74

KoolReport commented on Nov 12, 2019

Starting from version 4.0.0, we have change the structure of KoolReport, please move the "excel" folder from "koolreport/core" to "koolreport" folder. Please make sure that you are using the latest excel package version with KoolReport 4.3

sevgi commented on Nov 12, 2019

Update folder. Fatal error: Uncaught Error: Class 'PhpOffice\PhpSpreadsheet\Spreadsheet' not found in /koolreport/packages/excel/ExcelExportable.php:74 Stack trace: #0 //report/export.php(13): ticket->exportToExcel('ticketReport') #1 {main} thrown in /report/koolreport/packages/excel/ExcelExportable.php on line 74

KoolReport commented on Nov 13, 2019

So have you updated excel to the latest version? If the issue persist, please go to folder "koolreport/excel" and run:

composer update

It will re-install the package.

sevgi commented on Nov 13, 2019

Updating dependencies (including require-dev) Your requirements could not be resolved to an installable set of packages.

Problem 1 - phpoffice/phpspreadsheet 1.9.0 requires ext-dom * -> the requested PHP extension dom is missing from your system ... - Installation request for phpoffice/phpspreadsheet ^1.2 -> satisfiable by phpoffice/phpspreadsheet[1.2.0, 1.2.1, 1.3.0, 1.3.1, 1.4.0, 1.4.1, 1.5.0, 1.5.1, 1.5.2, 1.6.0, 1.7.0, 1.8.0, 1.8.1, 1.8.2, 1.9.0].

->>composer require phpoffice/phpspreadsheet. but error Your requirements could not be resolved to an installable set of packages.

Problem 1

- Installation request for phpoffice/phpspreadsheet ^1.9 -> satisfiable by phpoffice/phpspreadsheet[1.9.0].
- phpoffice/phpspreadsheet 1.9.0 requires ext-dom * -> the requested PHP extension dom is missing from your system.

You can also run php --ini inside terminal to see which files are used by PHP in CLI mode.

Installation failed, reverting ./composer.json to its original content.

KoolReport commented on Nov 13, 2019

Please have a look at this topic. And may I know your php version?

sevgi commented on Nov 13, 2019

Php version 7.2.24

KoolReport commented on Nov 13, 2019

That's great version of php, may be just dom extension is missing. Please try to enable the dom.so and if it not available, you follow the answer in the topic in my previous post. Let us know if it works.

sevgi commented on Nov 14, 2019

excel -> composer update Your requirements could not be resolved to an installable set of packages.

Problem 1

- phpoffice/phpspreadsheet 1.9.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.8.2 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.8.1 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.8.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.7.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.6.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- phpoffice/phpspreadsheet 1.9.0 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- Installation request for phpoffice/phpspreadsheet ^1.6 -> satisfiable by phpoffice/phpspreadsheet[1.6.0, 1.7.0, 1.8.0, 1.8.1, 1.8.2, 1.9.0].

To enable extensions, verify that they are enabled in your .ini files:

- /etc/php/7.2/cli/php.ini
- /etc/php/7.2/cli/conf.d/10-opcache.ini
- /etc/php/7.2/cli/conf.d/10-pdo.ini
- /etc/php/7.2/cli/conf.d/20-calendar.ini
- /etc/php/7.2/cli/conf.d/20-ctype.ini
- /etc/php/7.2/cli/conf.d/20-exif.ini
- /etc/php/7.2/cli/conf.d/20-fileinfo.ini
- /etc/php/7.2/cli/conf.d/20-ftp.ini
- /etc/php/7.2/cli/conf.d/20-gettext.ini
- /etc/php/7.2/cli/conf.d/20-iconv.ini
- /etc/php/7.2/cli/conf.d/20-json.ini
- /etc/php/7.2/cli/conf.d/20-phar.ini
- /etc/php/7.2/cli/conf.d/20-posix.ini
- /etc/php/7.2/cli/conf.d/20-readline.ini
- /etc/php/7.2/cli/conf.d/20-shmop.ini
- /etc/php/7.2/cli/conf.d/20-sockets.ini
- /etc/php/7.2/cli/conf.d/20-sysvmsg.ini
- /etc/php/7.2/cli/conf.d/20-sysvsem.ini
- /etc/php/7.2/cli/conf.d/20-sysvshm.ini
- /etc/php/7.2/cli/conf.d/20-tokenizer.ini

You can also run php --ini inside terminal to see which files are used by PHP in CLI mode. when ı run

Parse error: syntax error, unexpected '=' in /../report/koolreport/excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line 2460

[$language] = explode('_', $locale);

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

Excel