Class 'ZipArchive' not found in PHPExcel/Reader/Excel2007.php on line 86

[shaheenhashinclude]

I got an error
Message: Class 'ZipArchive' not found
Filename: Reader/Excel2007.php
Line Number: 86

Any help

[PowerKiKi]

Upgrade to PHPExcel 1.8.1. In that latest version, there is nothing on line 86. So you should not experience that bug if you had latest version.

[shaheenhashinclude]

Hi
I am attached PHPExcel/Reader/Excel2007.php
Excel2007.zip

same error occurs
Message: Class 'ZipArchive' not found

Filename: Reader/Excel2007.php

Line Number: 94

This file is working on localhost(php version 7.0). And not working in server(php version 5.4.45)

[PowerKiKi]

Upgrade to PHPExcel 1.8.1. Download it from here.

[shaheenhashinclude]

Same error

[PowerKiKi]

Then you probably don't have zip extension for PHP. What will the following code return ?

var_dump(extension_loaded ('zip'));

This might be solved by installing the extension, or using an alternative implementation via:

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

[shaheenhashinclude]

var_dump(extension_loaded ('zip')) returns bool(false)
where to place this code PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

[PowerKiKi]

This should be the first thing before using PHPExcel. Eg:

// Use PCLZip rather than ZipArchive
PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);
$phpExcel = PHPExcel_IOFactory::load("filename.xlsx");
// your code here...

[shaheenhashinclude]

I am using linke this
PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

			/*$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
			$objReader = PHPExcel_IOFactory::createReader($inputFileType);
			$objPHPExcel = $objReader->load($inputFileName);*/
	
	

			$sheet = $objPHPExcel->getSheet(0); 
			$highestRow = $sheet->getHighestRow(); 
			$highestColumn = $sheet->getHighestColumn();

That time somany errors occurs in localhost. I cant' solve . Pls help
error.txt

[PowerKiKi]

this is a warning, not an error. You can't do much about it now, unless migrate to unstable 1.8 branch (not recommended), or migrate to PhpSpreadsheet (only if you understand the risks).

@shaheenhashinclude

I have faced the same issue but i got fixed

Step1:
sudo apt-get install php5.6-zip

Step 2:
sudo service apache2 restart

If there is any doubt on it please let me know......Happy coding !!!!!

[cdmathukiya]

you just need to add zip module in server from cpanel
you can set it from here

cpanel -> Select PHP version -> check zip module in this page

[KaiJiaBrother]

ths

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

Works!
Good Job!

[cocoya23]

Where can I find the PHPExcel_Settings class?
whats the use statement?