How to connect in my file by PHPexcel?

PHPMaker General Discussion (PHPMaker)
1

Hello. How can I connect in my custom file PHPexcel ?

use PHPexcel as PHPexcel; // experimental

$xls = new PHPExcel(); // 43 line

//$xls = PHPExcel_IOFactory::load(__DIR__ . 'reports/'. $userid.'-subscribers.xlsx');

$xls->getProperties()->setTitle("report");
$xls->setActiveSheetIndex(0);
$sheet = $xls->getActiveSheet();
$sheet->setTitle('Subscriptions');

$sheet->getColumnDimensionByColumn("A")->setAutoSize(true);
$sheet->getColumnDimensionByColumn("B")->setAutoSize(true);
$sheet->getColumnDimensionByColumn("C")->setAutoSize(true);
$sheet->getColumnDimensionByColumn("D")->setAutoSize(true);

$sheet->setCellValue("D1", "DATE(D1)");
$sheet->setCellValue("A1", "' . $customer->name . '");
$sheet->setCellValue("B1", "' . $customer->email . '");
$sheet->setCellValue("C1", "' . number_format(($paysItems->amount/100),2,",",".") . '");
$sheet->setCellValue("D1", "' . $paysItems->created . '");

but I have errors.[2022-07-26T04:52:54.928118+00:00] log.DEBUG: Slim Application Error Type: Error Code: 0 Message: Class “PHPexcel” not found File: D:\OpenServer\domains\defi\cp\views\Stripesubscribe.php Line: 43 Trace: #0 D:\OpenServer\domains\defi\cp\vendor\slim\php-view\src\PhpRenderer.php(215): include() #1

2

I connect it, but how to use this code?

3

https://packagist.org/packages/phpoffice/phpexcelunsupported PHP 8.0 ? I use 8.0

4

phpoffice/phpexcel is abandoned, you should use phpoffice/phpspreadsheet which support PHP 8.x.

5

Could you tell me, where have I an arror in my code?

6

btrade wrote:

[2022-07-26T04:52:54.928118+00:00] log.DEBUG: Slim Application Error Type: Error Code: 0 Message: > Class “PHPexcel” not found > File: D:\OpenServer\domains\defi\cp\views\Stripesubscribe.php Line: 43