Welcome Guest, Not a member yet? Register   Sign In
trying to use phpSpreadsheet
#1

(This post was last modified: 02-07-2018, 03:00 PM by richb201.)

I am trying to allow a user to upload and import the data from an excel file into my mysql table. To do this I am trying to use phpSpreadsheet.

I installed phpSpreadsheet with Composer. I then put their sample function into my controller in one of the functions. I can upload the file fine using the CI upload lib. The require statemenrt works good ( at least no errors!). The use statements don't work at all so I commented them out. The new Spreadsheet statement complains that


A PHP Error was encountered
Severity: Error
Message: Class 'Spreadsheet' not found
Filename: controllers/Configure.php


How can I get this to work? 
 
require 'vendor/autoload.php';

//use PhpOffice\PhpSpreadsheet\Spreadsheet;
//use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');
proof that an old dog can learn new tricks
Reply


Messages In This Thread
trying to use phpSpreadsheet - by richb201 - 02-07-2018, 02:58 PM
RE: trying to use phpSpreadsheet - by dave friend - 02-07-2018, 04:03 PM
RE: trying to use phpSpreadsheet - by richb201 - 02-07-2018, 04:20 PM
RE: trying to use phpSpreadsheet - by dave friend - 02-07-2018, 08:24 PM
RE: trying to use phpSpreadsheet - by Wouter60 - 02-07-2018, 11:09 PM
RE: trying to use phpSpreadsheet - by richb201 - 02-07-2018, 11:29 PM
RE: trying to use phpSpreadsheet - by dave friend - 02-08-2018, 07:05 AM
RE: trying to use phpSpreadsheet - by Wouter60 - 02-08-2018, 11:31 AM
RE: trying to use phpSpreadsheet - by dave friend - 02-08-2018, 12:00 PM
RE: trying to use phpSpreadsheet - by Wouter60 - 02-08-2018, 01:54 PM
RE: trying to use phpSpreadsheet - by dave friend - 02-08-2018, 07:51 PM



Theme © iAndrew 2016 - Forum software by © MyBB