CODEWITHSUNDEEP
phpxlsxphpspreadsheet
Henrique Biagini
Henrique Biagini

Reputation: 21

SpreadSheet - Uncaught InvalidArgumentException: File "file.xlsx" does not exist

I am uploading an xlsx file in a folder and later reading it to insert the information into the database, however the spreadsheet plugin is not finding the file, it is going to a folder that does not make sense, below is code that I'm using.

The correct file path is: arquivosRetorno/file.xlsx but he is looking for in PHP Fatal error: Uncaught InvalidArgumentException: File "file.xlsx" does not exist. in /vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/File.php:137

$allowed_extension = array('xls', 'csv', 'xlsx');
$file_array = explode(".", $_FILES["arquivo"]["name"]);
$file_extension = end($file_array);
if(in_array($file_extension, $allowed_extension)){
    $file_name = time() . '.' . $file_extension;
    move_uploaded_file($_FILES['arquivo']['tmp_name'], 'arquivosRetorno/'.$file_name);

    $file_type = \PhpOffice\PhpSpreadsheet\IOFactory::identify($file_name);
    $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($file_type);

    $spreadsheet = $reader->load($file_name);
    unlink($file_name);
    $data = $spreadsheet->getActiveSheet()->toArray();
    foreach($data as $row){
        if($row[5] > 0){
            $numeroIdentificacaoContribuicoes = $row[5];
            $situacao = trim($row[7]);
            $dataBaixaLiquidacao = trim($row[2]);
            $dataPedacos = explode("/",$dataBaixaLiquidacao);
            $dataBD = $dataPedacos[2]."-".$dataPedacos[1]."-".$dataPedacos[0];
            if($row[5]>40107){
                if ($numeroIdentificacaoContribuicoes != null || $numeroIdentificacaoContribuicoes != '') {
                    $bd->SQL = "SELECT * FROM entradas WHERE id2 = ".$numeroIdentificacaoContribuicoes;
                    $bd->Executa();
                    $status = $bd->Regs[0]["status"];
                    if ($situacao == 'Liquidado') {
                        if($status == "" || $status == "boleto nao foi pago" || $status == null){
                            $bd->SQL = "UPDATE entradas SET status = 'boleto pago', data_boleto = '".$dataBD."' WHERE id2 = ".$numeroIdentificacaoContribuicoes."";
                            $bd->Executa();
                            $bd2->SQL = "UPDATE transacoes SET status_transacao = '9995' WHERE numeropedido = ".$numeroIdentificacaoContribuicoes."";
                            $bd2->Executa();
                        }

                    }else{
                        if($status != "boleto pago"){
                            $bd->SQL = "UPDATE entradas SET status = 'boleto nao foi pago', data_boleto = '".$dataBD."' WHERE id2 = ".$numeroIdentificacaoContribuicoes."";
                            $bd->Executa();
                            echo "<br>";
                            echo $bd2->SQL = "UPDATE transacoes SET status_transacao = '9994' WHERE numeropedido = ".$numeroIdentificacaoContribuicoes."";
                            $bd2->Executa();
                        }
                    }
                }       
           }
        }
    }
    $message = '<div class="alert alert-success">Arquivo importado com sucesso</div>';
}else{
    $message = '<div class="alert alert-danger">Apenas arquivos .xls .csv or .xlsx são aceitos</div>';
}

Upvotes: 1

Views: 2291

Answers (1)

kmoser
kmoser

Reputation: 9273

Change the call to:

$reader->load($file_name)

to:

$reader->load('arquivosRetorno/' . $file_name)

Upvotes: 2

Related Questions