Load($fileId);
$g = new G();
$path = PATH_DOCUMENT . $g->getPathFromUID(@@APPLICATION) . PATH_SEP .
$fileId .'_'. $aFile['DOC_VERSION'] .'.'. $ext;
require_once '/opt/Classes/PHPExcel.php';
require_once '/opt/Classes/PHPExcel/IOFactory.php';
$inputFileType = PHPExcel_IOFactory::identify($path); //identify type of file
$oReader = PHPExcel_IOFactory::createReader($inputFileType);
$oReader->setReadDataOnly(); //get data as plain text
try {
$oExcel = $oReader->load($path);
$aData = $oExcel->getActiveSheet()->toArray(null, true, true, true);
//uncomment to debug:
//print ""; var_dump($aData); die;
}
catch (Exception $e) {
$g->SendMessageText($e->getMessage(), 'ERROR');
PMFRedirectToStep(@@APPLICATION, @%INDEX, 'DYNAFORM', $dynaformId);
};
if (count($aData) <= 1) {
$g->SendMessageText("File $filename contains no data", 'WARNING');
PMFRedirectToStep(@@APPLICATION, @%INDEX, 'DYNAFORM', $dynaformId);
}
@=clientsList = array();
//assume that the first row of spreadsheet contains labels
for ($i=2; $i <= count($aData); $i++) {
@=clientsList[$i-1] = array(
'firstName' => $aData[$i]['A'],
'lastName' => $aData[$i]['B'],
'email' => $aData[$i]['C']
);
}
}]]>