public function testSimple()
{
$data = ['ROOT' => ['LEVEL1' => [['LEVEL1_CAPTION' => '1'], ['LEVEL1_CAPTION' => '2']]]];
$namedRange = $this->output->getNamedRange('ROOT');
$this->sut->write($data, $namedRange);
$this->output->setActiveSheetIndexByName('TEMPLATE');
$this->output->removeSheetByIndex($this->output->getActiveSheetIndex());
$excelWriter = \PHPExcel_IOFactory::createWriter($this->output, 'Excel2007');
$excelWriter->save(__DIR__ . '/../metadata/output/verticalrangewritertest.xlsx');
}
/**
* Write BookViews
*
* @param PHPExcel_Shared_XMLWriter $objWriter XML Writer
* @param PHPExcel $pPHPExcel
* @throws PHPExcel_Writer_Exception
*/
private function _writeBookViews(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)
{
// bookViews
$objWriter->startElement('bookViews');
// workbookView
$objWriter->startElement('workbookView');
$objWriter->writeAttribute('activeTab', $pPHPExcel->getActiveSheetIndex());
$objWriter->writeAttribute('autoFilterDateGrouping', '1');
$objWriter->writeAttribute('firstSheet', '0');
$objWriter->writeAttribute('minimized', '0');
$objWriter->writeAttribute('showHorizontalScroll', '1');
$objWriter->writeAttribute('showSheetTabs', '1');
$objWriter->writeAttribute('showVerticalScroll', '1');
$objWriter->writeAttribute('tabRatio', '600');
$objWriter->writeAttribute('visibility', 'visible');
$objWriter->endElement();
$objWriter->endElement();
}
/**
* Write Excel BIFF WINDOW1 record.
*/
private function writeWindow1()
{
$record = 0x3d;
// Record identifier
$length = 0x12;
// Number of bytes to follow
$xWn = 0x0;
// Horizontal position of window
$yWn = 0x0;
// Vertical position of window
$dxWn = 0x25bc;
// Width of window
$dyWn = 0x1572;
// Height of window
$grbit = 0x38;
// Option flags
// not supported by PHPExcel, so there is only one selected sheet, the active
$ctabsel = 1;
// Number of workbook tabs selected
$wTabRatio = 0x258;
// Tab to scrollbar ratio
// not supported by PHPExcel, set to 0
$itabFirst = 0;
// 1st displayed worksheet
$itabCur = $this->phpExcel->getActiveSheetIndex();
// Active worksheet
$header = pack("vv", $record, $length);
$data = pack("vvvvvvvvv", $xWn, $yWn, $dxWn, $dyWn, $grbit, $itabCur, $itabFirst, $ctabsel, $wTabRatio);
$this->append($header . $data);
}
function getDayTest(PHPExcel $objPHPExcel, PHPExcel_Worksheet $sheet, $col = 'A', $row = 1, $day = 'ПОНЕДЕЛЬНИК')
{
$b = false;
$index_sheet = $objPHPExcel->getActiveSheetIndex();
$rowHiestIndex = PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn($row));
for ($i = 0; $i <= $rowHiestIndex; $i++) {
$cell_value = $this->getValueMergedCell($objPHPExcel, $index_sheet, $this->arr_merged_allCells, $i, $row);
if ($cell_value == $day) {
return $b = true;
}
}
if (!$b) {
$colHiestIndex = $sheet->getHighestRow($col);
for ($i = 0; $i <= $colHiestIndex; $i++) {
$cell_value = $this->getValueMergedCell($objPHPExcel, $index_sheet, $this->arr_merged_allCells, $col, $i);
if ($cell_value == $day) {
return $b = true;
}
}
}
return $b;
}
$objPHPExcel->getActiveSheet()->getColumnDimension($coluna)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getStyle($coluna . '1')->getFont()->setBold(true);
}
}
$colunas = array('A' => 'CAMPUS', 'B' => 'CURSO', 'C' => 'LOCAL DE PROVA', 'D' => 'INSCRITO', 'E' => 'N. INSCRICAO', 'F' => 'CPF', 'G' => 'RG', 'H' => 'ORGAO EXPEDIDOR', 'I' => 'UF', 'J' => 'DATA DE EXPEDICAO', 'K' => 'NACIONALIDADE', 'L' => 'DATA DE NASCIMENTO', 'M' => 'SEXO', 'N' => 'ENDERECO', 'O' => 'CEP', 'P' => 'CIDADE', 'Q' => 'ESTADO', 'R' => 'TELEFONE', 'S' => 'CELULAR', 'T' => 'EMAIL', 'U' => 'ESTADO CIVIL', 'V' => 'NECESSIDADE ESPECIAL', 'W' => 'DESCRICAO NECESSIDADE ESPECIAL', 'X' => 'ISENCAO DE TAXA', 'Y' => 'CONDICOES ESPECIAIS PARA REALIZACAO DA PROVA', 'Z' => 'DESCRICAO CONDICOES ESPECIAIS PARA REALIZACAO DA PROVA', 'AA' => 'CONCORRE AS VAGAS DESTINADAS A CANDIDATOS COM NECESSIDADES ESPECIAIS');
$query = $banco->ExecutaQueryGenerica($sql);
$numResults = mysql_num_rows($query);
$linha = 2;
$campus_id = null;
while ($row = mysql_fetch_assoc($query)) {
$val = array_values($row);
if ($campus_id != $val[0]) {
$campus_id = $val[0];
if ($campus_id > 1 && $numResults > 1) {
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex($objPHPExcel->getActiveSheetIndex() + 1);
}
$objPHPExcel->getActiveSheet()->setTitle(removeAcentos($val[1]));
setCabecalho($objPHPExcel, $colunas);
$linha = 2;
}
$col = 1;
foreach ($colunas as $coluna => $valor) {
if ($val[$col] == null) {
$objPHPExcel->getActiveSheet()->SetCellValue($coluna . $linha, '---');
} else {
$objPHPExcel->getActiveSheet()->SetCellValue($coluna . $linha, utf8_encode($val[$col]));
}
$col++;
}
$linha++;
/**
* Get the currently active sheet
*
* @return PHPExcel_Worksheet
*/
public function get_active_worksheet()
{
return $this->_worksheets[$this->_spreadsheet->getActiveSheetIndex()];
}
protected function clean()
{
$this->output->setActiveSheetIndexByName('TEMPLATE');
$this->output->removeSheetByIndex($this->output->getActiveSheetIndex());
}
