} //results $results.=getVLResult("roche",$worksheetID,$rq["vlSampleID"],$factor).($rcount<$rnum?", ":""); } } //xls $dataRocheResults[]=array($patientART,$patientOtherID,$facility,$numberResults,$results); } } //output to xlsx $writer = new XLSXWriter(); $writer->setAuthor($default_institutionName); $writer->writeSheet($dataAbbottResults,"abbott",$headerAbbottResults); $writer->writeSheet($dataRocheResults,"roche",$headerRocheResults); $writer->writeToStdOut(); break; case "clinicalrequestformsexcel": //filename of the excel file to be downloaded $filename=0; $filename="excel.clinical.request.forms.".getFormattedDateCRB($datetime).".xls"; //create an instance of the class $xls = new ExportXLS($filename); //period $from=0; $from="$fromYear-$fromMonth-$fromDay"; $to=0; $to="$toYear-$toMonth-$toDay";