Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way.

1. Code:

Choose File:

 

         
                     
  
      

 0 ) {

        #Read excel file by using ReadFactory object.
        $reader=ReaderFactory::createFromType(Type::XLSX);

        $reader->open($fileUploadData['tmp_name']);
        $count = 1;
        $rows = array();
        foreach ($reader->getSheetIterator() as $sheet) {
            foreach ($sheet->getRowIterator() as $row) {
				$rowAsArray = $row->toArray();
                if ($count > 0) {
					$fileUploadData['importData'][] = $rowAsArray;
               }
                $count++;
            }
         echo "successfully uploaded!";
        }
        $reader->close();
    } else {
        echo "PLEASE SELECT A VALID EXCEL FILE";
    }
} else {
    echo "UPLOAD AN EXCEL FILE";
}

?>

2. Example:

Input: example_upload_using_spout.xlsx

ID	Name	        Description
1	Spout      	Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS)
2	ReaderFactory   This creates an instance of the appropriate reader, given the type of the file to be read

Output

ID	Name	        Description
1	Spout      	Spout is a PHP library to read and write spreadsheet files (CSV, XLSX and ODS)
2	ReaderFactory   This creates an instance of the appropriate reader, given the type of the file to be read