Exemplos de MoveElevator\XlsxAppender\XlsxAppender em PHP

Exemplo n.º 1

Arquivo: example-append-tempfile.php Projeto: move-elevator/xlsx-appender

<?php

require_once __DIR__ . '/../vendor/autoload.php';
$data = array(array(500, 999502, 22448, '01234'), array(501, 999501, 22448, '01234'));
$tempFile = __DIR__ . '/tempFile';
$startAtLine = 14;
$newContent = '';
foreach ($data as $item) {
    $newContent .= \MoveElevator\XlsxAppender\Templates\XlsxRowTemplate::getTemplateString($item, 'A', $startAtLine);
    $startAtLine++;
}
file_put_contents($tempFile, $newContent, FILE_APPEND);
$xlsxAppender = new \MoveElevator\XlsxAppender\XlsxAppender(__DIR__ . '/../tests/fixtures/test.xlsx');
$sheet = $xlsxAppender->getSheetPathBySheetName('sheet1');
$xlsxAppender->appendTempFileToSheet($tempFile, $sheet);
$xlsxAppender->saveAndExit();

Exemplo n.º 2

Arquivo: example-append.php Projeto: move-elevator/xlsx-appender

<?php

require_once __DIR__ . '/../vendor/autoload.php';
$data = array(array(500, 999502, 22448, '01234'), array(501, 999501, 22448, '01234'));
$xlsxAppender = new \MoveElevator\XlsxAppender\XlsxAppender(__DIR__ . '/../tests/fixtures/test.xlsx');
$sheet = $xlsxAppender->getSheetPathBySheetName('sheet1');
$xlsxAppender->appendDataArrayToSheet($sheet, $data, 12);
$xlsxAppender->saveAndExit();