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()); }