private function writeOnWorkSheet(Map $groupedValues, ExcelOutputFile $spreadSheet, array $years, $index = 0)
{
if (!$groupedValues->isEmpty()) {
parent::titles($years);
parent::addValuesToARow($groupedValues, $years);
$spreadSheet->setNewDataToExcel($this->dataToExcel);
$nameGroup = $groupedValues->get(0)->offsetGet(0)->getSubgroupName();
$spreadSheet->buildSpreadSheet($nameGroup, $index);
}
}
<?php
require_once '../util/Maps/HashMap.php';
require_once '../util/excel/writer/MapToExcel.php';
require_once '../util/excel/writer/ExcelOutputFile.php';
require_once '../util/excel/writer/ExcelWriter.php';
$values = new HashMap();
$values->put("rowTitles", array("Nome", "Sobrenome", "Idade"));
$values->put(0, array("Ramon", "Goncalves", "22"));
$values->put(1, array("Matheus", "Goncalves", "09"));
$values->put(2, array("Karen", "Guedes", "22"));
$dataToExcel = new MapToExcel($values);
$excelOutputFile = new ExcelOutputFile($dataToExcel, new ExcelWriter("testName.xls"));
echo $excelOutputFile->getSpreadSheet();
header("Location: " . $excelOutputFile->getSpreadSheet());
