I am new in codeigniter 4, when needed to manipulate some excel files in my app I found the phpspreadsheet library convenient for that. However, after installing it using composer I found it difficult to implement it in my app.
Even when I tested their example hereafter couldn't work instead displayed
08-20-2020, 11:14 PM (This post was last modified: 08-20-2020, 11:16 PM by jreklund.)
Hi, CI4 already knows where composer are located. This is how you load it inside an controller
PHP Code:
<?php namespace App\Controllers;
use \PhpOffice\PhpSpreadsheet\Spreadsheet; use \PhpOffice\PhpSpreadsheet\Writer\Xlsx;
class Example extends BaseController { public function index() { $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $writer->save('hello world.xlsx'); } }