PHP Excel import

Question

I have used the following code for excel import in php

$filename=$_FILES["file"]["tmp_name"];
$this->load->library("PHPExcel");
$inputFileType = PHPExcel_IOFactory::identify($filename);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($filename);
//$objPHPExcel = PHPExcel_IOFactory::load($file);
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$arrayCount = count($allDataInSheet);

while uploading some xls file getting the error,

Fatal error: Call to undefined method PHPExcel_Shared_ZipArchive::statName() in D:\xampp\htdocs\folder\application\third_party\PHPExcel\Reader\OOCalc.php on line 80 .

I have also used the line

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

but getting the same error. pls help me resolve the error.

Possible duplicate of PHPExcel ZipArchive not found

Alex Slipknot
– Alex Slipknot

2017-05-03 09:17:52 +00:00
Commented May 3, 2017 at 9:17 — Alex Slipknot
– Alex Slipknot, Commented May 3, 2017 at 9:17
I suggest you to replace your PHPExcel with fresh version

Alex Slipknot
– Alex Slipknot

2017-05-03 09:19:12 +00:00
Commented May 3, 2017 at 9:19 — Alex Slipknot
– Alex Slipknot, Commented May 3, 2017 at 9:19
Yes already did those things.

pabha
– pabha

2017-05-03 09:21:02 +00:00
Commented May 3, 2017 at 9:21 — pabha
– pabha, Commented May 3, 2017 at 9:21

Nuri Ensing · Accepted Answer · 2017-05-03 09:22:15Z

Try something in this fashion:

$filename = $_FILES["file"]["tmp_name"];;
//load the excel library
$this->load->library('PHPExcel');
//read file from path
$objPHPExcel = PHPExcel_IOFactory::load($filename );
//get only the Cell Collection
$cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection();
//extract to a PHP readable array format
foreach ($cell_collection as $cell) {
    $column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn();
    $row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow();
    $data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue();
    //header will/should be in row 1 only. of course this can be modified to suit your need.
    if ($row == 1) {
        $header[$row][$column] = $data_value;
    } else {
        $arr_data[$row][$column] = $data_value;
    }
}
//send the data in an array format
$data['header'] = $header;
$data['values'] = $arr_data;

groenhen · Accepted Answer · 2020-09-14 14:13:23Z

0

I was able to upload only xlsx file and not able to add csv, xls and other format files.
I removed this line from controller:

PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);

It works for me, now I'm able to upload all excel formats.

edited Sep 14, 2020 at 14:13

groenhen

3,02725 gold badges51 silver badges69 bronze badges

answered Sep 14, 2020 at 12:47

Meena sudhesh

11 silver badge1 bronze badge

1 Comment

Nico Haase Over a year ago

Please add some explanation to your answer such that others can learn from it

Collectives™ on Stack Overflow

PHP Excel import

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related