Error getting while import excel using php

Question

I want to import excel using php. I have

 public function importexcel()
    {

        $this->img = 'poc.xlsx';
$exceldata = array();
 require 'Classes/PHPExcel/IOFactory.php';
try
{
    $inputfiletype = PHPExcel_IOFactory::identify( $this->img);
    $objReader = PHPExcel_IOFactory::createReader($inputfiletype);
    $objPHPExcel = $objReader->load( $this->img);
}

catch(Exception $e)
{
    die('Error loading file "'.pathinfo( $this->img,PATHINFO_BASENAME).'": '.$e->getMessage());
}

POC.xlsx

But when I load the page I got an error like

Error loading file "poc.xlsx": Could not open poc.xlsx for reading! File does not exist.

Please help me. Any help would be appreciated.

It looks like your path to file is not correct. Please check your file path. — Harsh Barach
– Harsh Barach, Commented Mar 15, 2018 at 7:24

Bartosz Zasada · Accepted Answer · 2018-03-15 07:36:04Z

1

You should always use absolute paths for files. If the file is in the same directory as the controller, the line with the path should look as follows:

$this->img = __DIR__ . '/poc.xlsx';

__DIR__ is a magic constant, whose value always equals the absolute path to the directory of the current file.

Notice that you're using a require statement like this:

require 'Classes/PHPExcel/IOFactory.php';

Since you obviously don't have a fatal error informing about an inexistent file, it indicates that the current working directory is not controllers, but one above it. So, you could also write

$this->img = '../poc.xlsx';`

and this would probably work too. But again, it'll be easier to avoid all errors with missing files when you use absolute paths.

answered Mar 15, 2018 at 7:36

Bartosz Zasada

3,9002 gold badges23 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Error getting while import excel using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related