public function test()
{
$service = new ExcelSelectionSetter();
$service->addStrategy(new AllFirst());
$service->addStrategy(new SynchronizeToTemplate());
$originalFile = __DIR__ . '/data/functional/target.xlsx';
$templateFile = new ZipArchive();
$templateFile->open(__DIR__ . '/data/functional/template.xlsx');
// allfirst
$allFirstTarget = __DIR__ . '/data/functional/all_first.xlsx';
copy($originalFile, $allFirstTarget);
$service->execute($allFirstTarget, 'all_first');
// synchro
$syncTarget = __DIR__ . '/data/functional/sync.xlsx';
copy($originalFile, $syncTarget);
$service->execute($syncTarget, 'synchronize_to_template', $templateFile);
$this->assertTrue(true);
}
/**
* 選択されているシート名を返す
* @inheritdoc
*/
public function read(ZipArchive $xlsx)
{
$worksheetXml = $xlsx->getFromName('xl/workbook.xml');
if (!$worksheetXml) {
throw new \RuntimeException('Could not find workbook.xml');
}
$sheets = $this->bookUtil->makeSheetMap($xlsx);
$dom = new \DOMDocument();
$dom->loadXML($worksheetXml);
$xpath = new \DOMXPath($dom);
$xpath->registerNamespace('s', XmlNamespace::SPREADSHEETML_NS_URL);
// 選択されているシートIDを調べる
$activeSheetId = null;
$views = $xpath->query('//s:workbook/s:bookViews/s:workbookView');
if ($views->length == 1) {
/** @var \DOMElement $workbookView */
$workbookView = $views->item(0);
$activeSheetId = $workbookView->getAttribute('activeTab');
}
return $activeSheetId && isset($sheets[$activeSheetId]) ? $sheets[$activeSheetId] : reset($sheets);
}
private function setInWorkbook(ZipArchive $xlsx, $targetSheetName)
{
$workbookXml = $xlsx->getFromName('xl/workbook.xml');
if (!$workbookXml) {
throw new \RuntimeException('Could not find workbook.xml');
}
// 対象のシートindexを探す
$sheets = $this->bookUtil->makeSheetMap($xlsx);
$i = 0;
$targetSheetIndex = false;
foreach ($sheets as $sheetName) {
if ($sheetName == $targetSheetName) {
$targetSheetIndex = $i;
break;
}
$i++;
}
if ($targetSheetIndex === false) {
throw new \RuntimeException(sprintf('Could not find sheet"%s" in workbook', $targetSheetName));
}
$dom = new \DOMDocument();
$dom->loadXML($workbookXml);
$xpath = new \DOMXPath($dom);
$xpath->registerNamespace('s', XmlNamespace::SPREADSHEETML_NS_URL);
$views = $xpath->query('//s:workbook/s:bookViews/s:workbookView');
if ($views->length == 1) {
/** @var \DOMElement $workbookView */
$workbookView = $views->item(0);
$workbookView->setAttribute('activeTab', $targetSheetIndex);
} else {
$workbookView = $dom->createElement('workbookView');
$workbookView->setAttribute('activeTab', $targetSheetIndex);
$bookView = $xpath->query('//s:workbook/s:bookViews')->item(0);
$bookView->appendChild($workbookView);
}
$xlsx->addFromString('xl/workbook.xml', $dom->saveXML());
}
