phpoffice phpexcel not loading file

Question

I have the following code:

require_once "../vendor/autoload.php";
require_once '../vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php';
$target_dir = "coverImages/";
$target_file = $target_dir . basename($_FILES["excelfile"]["name"]);
move_uploaded_file($_FILES["excelfile"]["tmp_name"], $target_file);
if ($_FILES["excelfile"]["error"] > 0)
{
    echo "Error: " . $_FILES["excelfile"]["error"] . "<br>";
}
else
{
    if (file_exists($target_file)) {
        echo "file exists!";
    }else{
        echo "oh it does not";
    }
    $objPHPExcel = PHPExcel_IOFactory::load($target_file);
}

I am getting the file from an input file. I am moving the file to a location on my server. But I cannot load the file once I have it moved. I am verifying the file exists, but phpoffice won't grab my file when I call load on a Factory and gives me a 500 error. Any advice can help me, thanks in advance.

EDIT: Error returned:

Fatal error: Uncaught Error: Class 'ZipArchive' not found in /app/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php:94 Stack trace: #0 /app/vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php(268): PHPExcel_Reader_Excel2007->canRead('coverImages/Boo...') #1 /app/vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php(191): PHPExcel_IOFactory::createReaderForFile('coverImages/Boo...') #2 /app/public/upload_file.php(26): PHPExcel_IOFactory::load('coverImages/Boo...') #3 {main} thrown in /app/vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel2007.php on line 94

Not sure why there is an error, in my dockerfile I am calling:

RUN apt-get update && \
  apt-get install -y \
    freetds-dev \
    libsybdb5 \
    wget \
    zip

So zip should be installed.

did you tried to set display_errors? stackoverflow.com/questions/1053424/… — icy
– icy, Commented Oct 5, 2017 at 21:19
When you get a 500 from the server, you'll generally find something written to the server logs that will identify the cause of the problem — Mark Baker
– Mark Baker, Commented Oct 6, 2017 at 8:12
added an edit above, googling the zipArchive for answers. Thanks. — tcoulson
– tcoulson, Commented Oct 6, 2017 at 12:41

Finwe · Accepted Answer · 2017-10-06 12:58:52Z

0

You are missing the zip extension. Either allow it in your php.ini file or install it.

https://secure.php.net/manual/en/book.zip.php

answered Oct 6, 2017 at 12:58

Finwe

6,7933 gold badges35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tcoulson · Accepted Answer · 2017-10-06 13:17:58Z

0

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

This line from this link and an upgrade to 1.8.1 fixed the problem.

answered Oct 6, 2017 at 13:17

tcoulson

6243 gold badges13 silver badges43 bronze badges

Collectives™ on Stack Overflow

phpoffice phpexcel not loading file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related