Come leggere un file XLSX e scrivere in MYSQLI

[stefano.coccia]

Ciao PhpExcel è molto semplice, dopo che fai un form di upload basta che esplodi le righe come se fosse un DB

include '../Excel/vendor/autoload.php';
if($_FILES["import_excel"]["name"] != '')
{
	 $allowed_extension = array('xls', 'csv', 'xlsx');
	 $file_array = explode(".", $_FILES["import_excel"]["name"]);
	 $file_extension = end($file_array);


	 if(in_array($file_extension, $allowed_extension))
	 {
	$file_name = time() . '.' . $file_extension;
	move_uploaded_file($_FILES['import_excel']['tmp_name'], $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)
		  { 
                    echo $row[0]; //la colonna A
                    echo $row[1]; //la colonna B
                  }
            }
    }