Taking xlsx file with HTML and PHP

Question

I need to import data xlsx to a system I created.

HTML

<form method="post" action="" enctype="multipart/form-data">
    <input type="file" name="arquivo">
    <input type="submit" name="pegar value="pegar">
</form>

PHP

<?php
ini_set('display_errors', true);
error_reporting(E_ALL);

if (isset($_POST['pega'])) {

   $arquivo = $_FILES['arquivo'];
   $file = fopen($arquivo,"r");

   while(! feof($file)){
       echo fgets($file). "<br />";
   }

   fclose($file);
}

And these are the error messages that appear:

Warning: fopen() expects Parameter 1 to be a Valid path, array Given in /Applications/MAMP/htdocs/sistemas/scripts_da_web/php/importaCSV.php on line 20

Warning: feof() expects Parameter 1 to be Resource, Boolean Given in /Applications/MAMP/htdocs/sistemas/scripts_da_web/php/importaCSV.php on line 22

Warning: fgets() expects Parameter 1 to be Resource, Boolean Given in /Applications/MAMP/htdocs/sistemas/scripts_da_web/php/importaCSV.php on line 24

Answer 1

It is easier for you to do this using the standard CSV files (comma separated). Use the Phpexcel library to convert your xlsx file to csv, and then use the fgetcsv function to transform the csv data into an array in php. Install lib and complete your code with something like this:

$file = $_FILES['arquivo']['tmp_name'];
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load($file);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$csvFileName = str_replace('.xlsx', '.csv', $file);
$objWriter->save($csvFileName);
if (($handle = fopen($csvFileName, "r")) !== false) {
    while (($data = fgetcsv($handle, 1000, ",")) !== false) {
        $num = count($data);
        echo "<p> $num campos na linha $row: <br /></p>\n";
        $row++;
        for ($c = 0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}

Useful links:

https://github.com/PHPOffice/PHPExcel

http://php.net/manual/en/function.fgetcsv.php