getSheetCount(); $csv = []; for ($i = 0; $i < $sheetCount; ++$i) { $csv[] = $spreadsheet->getSheet($i)->toArray(null, true, true, true); } $json = \json_encode($csv); return $json === false ? '' : $json; } elseif ($output === 'pdf') { $spreadsheet->getActiveSheet()->setShowGridLines(false); $spreadsheet->getActiveSheet()->getPageSetup()->setOrientation(PageSetup::ORIENTATION_LANDSCAPE); IOFactory::registerWriter('custom', \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter::class); /** @var \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter $writer */ $writer = IOFactory::createWriter($spreadsheet, 'custom'); return $writer->toPdfString(); } elseif ($output === 'html') { IOFactory::registerWriter('custom', \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter::class); /** @var \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter $writer */ $writer = IOFactory::createWriter($spreadsheet, 'custom'); return $writer->generateHtmlAll(); } elseif ($output === 'txt') { IOFactory::registerWriter('custom', \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter::class); /** @var \phpOMS\Utils\Parser\Spreadsheet\SpreadsheetWriter $writer */ $writer = IOFactory::createWriter($spreadsheet, 'custom'); $html = $writer->generateHtmlAll(); $doc = new \DOMDocument(); $html = \preg_replace( ['~~', '~~'], ['', ''], $html ); $doc->loadHTMLFile($path); $body = $doc->getElementsByTagName('body'); $node = $body->item(0); return empty($node->textContent) ? '' : $node->textContent; } return ''; } }