Class 'PhpOffice\PhpSpreadsheet\Spreadsheet' not found

phpspreadsheet
Scott Johnson picture Scott Johnson · Jan 6, 2018 · Viewed 21.6k times · Source

I have used Composer to install phpoffice/phpspreadsheet. It was installed in a base 'vendor' directory. However where I am needing to use it is in a subdomain directory. I manually moved it to a different 'vendor' directory.

a bit deeper ../public_html/subdomains/newsite/vendor/

I am calling the code from a file a bit yet deeper ../backend/web/xlsx.php

My actual code is as follows:

<?php
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

require '../../vendor/autoload.php';
$spreadsheet = new Spreadsheet();
?>

With just this simple set I am getting the following fatal error:

Class 'PhpOffice\PhpSpreadsheet\Spreadsheet' not found

I am still learning a bit about namespaces and composer and I may have missed something when I moved the files manually.

Any help would be greatly appreciated.

Thank You!

Answer

Luan Menezes picture Luan Menezes · Jul 2, 2019

I know it's been a long time since you asked, but it might help others.

In this case when you modify the structure of the vendor the autoload is also updated.

If you are picking up the folder from a local and putting it into production, you should also send the updated autoload.

Related questions

Setting width of spreadsheet cell using PHPExcel

I'm trying to set the width of a cell in an Excel document generated with PHPExcel with: $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10'); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(false); …

Read More
Merge Cell values with PHPExcel - PHP

I have a simple table like: - id - first_name - last_name - email - phone I'm using PHPExcel to export my data in XLS format $rowNumber = 1; while ($row = mysql_fetch_row($result)) { $col = 'A'; foreach($row as $…

Read More
Composer require phpoffice/phpspreadsheet doesn't work

I want to write a Script using the package Phpspreadsheet. I am not experience in php. I am trying to add the reference to my script through sudo composer require phpoffice/phpspreadsheet. But it doesn't work. I am getting the …

Read More