diff options
Diffstat (limited to 'vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php')
-rw-r--r-- | vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php | 590 |
1 files changed, 590 insertions, 0 deletions
diff --git a/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php new file mode 100644 index 0000000..675777c --- /dev/null +++ b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php @@ -0,0 +1,590 @@ +<?php
+
+namespace PhpOffice\PhpSpreadsheet\Reader;
+
+use InvalidArgumentException;
+use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
+use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
+use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;
+use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
+use PhpOffice\PhpSpreadsheet\Spreadsheet;
+use PhpOffice\PhpSpreadsheet\Style\Border;
+
+class Slk extends BaseReader
+{
+ /**
+ * Input encoding.
+ *
+ * @var string
+ */
+ private $inputEncoding = 'ANSI';
+
+ /**
+ * Sheet index to read.
+ *
+ * @var int
+ */
+ private $sheetIndex = 0;
+
+ /**
+ * Formats.
+ *
+ * @var array
+ */
+ private $formats = [];
+
+ /**
+ * Format Count.
+ *
+ * @var int
+ */
+ private $format = 0;
+
+ /**
+ * Fonts.
+ *
+ * @var array
+ */
+ private $fonts = [];
+
+ /**
+ * Font Count.
+ *
+ * @var int
+ */
+ private $fontcount = 0;
+
+ /**
+ * Create a new SYLK Reader instance.
+ */
+ public function __construct()
+ {
+ parent::__construct();
+ }
+
+ /**
+ * Validate that the current file is a SYLK file.
+ *
+ * @param string $pFilename
+ *
+ * @return bool
+ */
+ public function canRead($pFilename)
+ {
+ try {
+ $this->openFile($pFilename);
+ } catch (InvalidArgumentException $e) {
+ return false;
+ }
+
+ // Read sample data (first 2 KB will do)
+ $data = fread($this->fileHandle, 2048);
+
+ // Count delimiters in file
+ $delimiterCount = substr_count($data, ';');
+ $hasDelimiter = $delimiterCount > 0;
+
+ // Analyze first line looking for ID; signature
+ $lines = explode("\n", $data);
+ $hasId = substr($lines[0], 0, 4) === 'ID;P';
+
+ fclose($this->fileHandle);
+
+ return $hasDelimiter && $hasId;
+ }
+
+ private function canReadOrBust(string $pFilename): void
+ {
+ if (!$this->canRead($pFilename)) {
+ throw new ReaderException($pFilename . ' is an Invalid SYLK file.');
+ }
+ $this->openFile($pFilename);
+ }
+
+ /**
+ * Set input encoding.
+ *
+ * @deprecated no use is made of this property
+ *
+ * @param string $pValue Input encoding, eg: 'ANSI'
+ *
+ * @return $this
+ *
+ * @codeCoverageIgnore
+ */
+ public function setInputEncoding($pValue)
+ {
+ $this->inputEncoding = $pValue;
+
+ return $this;
+ }
+
+ /**
+ * Get input encoding.
+ *
+ * @deprecated no use is made of this property
+ *
+ * @return string
+ *
+ * @codeCoverageIgnore
+ */
+ public function getInputEncoding()
+ {
+ return $this->inputEncoding;
+ }
+
+ /**
+ * Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
+ *
+ * @param string $pFilename
+ *
+ * @return array
+ */
+ public function listWorksheetInfo($pFilename)
+ {
+ // Open file
+ $this->canReadOrBust($pFilename);
+ $fileHandle = $this->fileHandle;
+ rewind($fileHandle);
+
+ $worksheetInfo = [];
+ $worksheetInfo[0]['worksheetName'] = basename($pFilename, '.slk');
+
+ // loop through one row (line) at a time in the file
+ $rowIndex = 0;
+ $columnIndex = 0;
+ while (($rowData = fgets($fileHandle)) !== false) {
+ $columnIndex = 0;
+
+ // convert SYLK encoded $rowData to UTF-8
+ $rowData = StringHelper::SYLKtoUTF8($rowData);
+
+ // explode each row at semicolons while taking into account that literal semicolon (;)
+ // is escaped like this (;;)
+ $rowData = explode("\t", str_replace('¤', ';', str_replace(';', "\t", str_replace(';;', '¤', rtrim($rowData)))));
+
+ $dataType = array_shift($rowData);
+ if ($dataType == 'B') {
+ foreach ($rowData as $rowDatum) {
+ switch ($rowDatum[0]) {
+ case 'X':
+ $columnIndex = substr($rowDatum, 1) - 1;
+
+ break;
+ case 'Y':
+ $rowIndex = substr($rowDatum, 1);
+
+ break;
+ }
+ }
+
+ break;
+ }
+ }
+
+ $worksheetInfo[0]['lastColumnIndex'] = $columnIndex;
+ $worksheetInfo[0]['totalRows'] = $rowIndex;
+ $worksheetInfo[0]['lastColumnLetter'] = Coordinate::stringFromColumnIndex($worksheetInfo[0]['lastColumnIndex'] + 1);
+ $worksheetInfo[0]['totalColumns'] = $worksheetInfo[0]['lastColumnIndex'] + 1;
+
+ // Close file
+ fclose($fileHandle);
+
+ return $worksheetInfo;
+ }
+
+ /**
+ * Loads PhpSpreadsheet from file.
+ *
+ * @param string $pFilename
+ *
+ * @return Spreadsheet
+ */
+ public function load($pFilename)
+ {
+ // Create new Spreadsheet
+ $spreadsheet = new Spreadsheet();
+
+ // Load into this instance
+ return $this->loadIntoExisting($pFilename, $spreadsheet);
+ }
+
+ private $colorArray = [
+ 'FF00FFFF', // 0 - cyan
+ 'FF000000', // 1 - black
+ 'FFFFFFFF', // 2 - white
+ 'FFFF0000', // 3 - red
+ 'FF00FF00', // 4 - green
+ 'FF0000FF', // 5 - blue
+ 'FFFFFF00', // 6 - yellow
+ 'FFFF00FF', // 7 - magenta
+ ];
+
+ private $fontStyleMappings = [
+ 'B' => 'bold',
+ 'I' => 'italic',
+ 'U' => 'underline',
+ ];
+
+ private function processFormula(string $rowDatum, bool &$hasCalculatedValue, string &$cellDataFormula, string $row, string $column): void
+ {
+ $cellDataFormula = '=' . substr($rowDatum, 1);
+ // Convert R1C1 style references to A1 style references (but only when not quoted)
+ $temp = explode('"', $cellDataFormula);
+ $key = false;
+ foreach ($temp as &$value) {
+ // Only count/replace in alternate array entries
+ if ($key = !$key) {
+ preg_match_all('/(R(\[?-?\d*\]?))(C(\[?-?\d*\]?))/', $value, $cellReferences, PREG_SET_ORDER + PREG_OFFSET_CAPTURE);
+ // Reverse the matches array, otherwise all our offsets will become incorrect if we modify our way
+ // through the formula from left to right. Reversing means that we work right to left.through
+ // the formula
+ $cellReferences = array_reverse($cellReferences);
+ // Loop through each R1C1 style reference in turn, converting it to its A1 style equivalent,
+ // then modify the formula to use that new reference
+ foreach ($cellReferences as $cellReference) {
+ $rowReference = $cellReference[2][0];
+ // Empty R reference is the current row
+ if ($rowReference == '') {
+ $rowReference = $row;
+ }
+ // Bracketed R references are relative to the current row
+ if ($rowReference[0] == '[') {
+ $rowReference = $row + trim($rowReference, '[]');
+ }
+ $columnReference = $cellReference[4][0];
+ // Empty C reference is the current column
+ if ($columnReference == '') {
+ $columnReference = $column;
+ }
+ // Bracketed C references are relative to the current column
+ if ($columnReference[0] == '[') {
+ $columnReference = $column + trim($columnReference, '[]');
+ }
+ $A1CellReference = Coordinate::stringFromColumnIndex($columnReference) . $rowReference;
+
+ $value = substr_replace($value, $A1CellReference, $cellReference[0][1], strlen($cellReference[0][0]));
+ }
+ }
+ }
+ unset($value);
+ // Then rebuild the formula string
+ $cellDataFormula = implode('"', $temp);
+ $hasCalculatedValue = true;
+ }
+
+ private function processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+ {
+ // Read cell value data
+ $hasCalculatedValue = false;
+ $cellDataFormula = $cellData = '';
+ foreach ($rowData as $rowDatum) {
+ switch ($rowDatum[0]) {
+ case 'C':
+ case 'X':
+ $column = substr($rowDatum, 1);
+
+ break;
+ case 'R':
+ case 'Y':
+ $row = substr($rowDatum, 1);
+
+ break;
+ case 'K':
+ $cellData = substr($rowDatum, 1);
+
+ break;
+ case 'E':
+ $this->processFormula($rowDatum, $hasCalculatedValue, $cellDataFormula, $row, $column);
+
+ break;
+ }
+ }
+ $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
+ $cellData = Calculation::unwrapResult($cellData);
+
+ // Set cell value
+ $this->processCFinal($spreadsheet, $hasCalculatedValue, $cellDataFormula, $cellData, "$columnLetter$row");
+ }
+
+ private function processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate): void
+ {
+ // Set cell value
+ $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
+ if ($hasCalculatedValue) {
+ $cellData = Calculation::unwrapResult($cellData);
+ $spreadsheet->getActiveSheet()->getCell($coordinate)->setCalculatedValue($cellData);
+ }
+ }
+
+ private function processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void
+ {
+ // Read cell formatting
+ $formatStyle = $columnWidth = '';
+ $startCol = $endCol = '';
+ $fontStyle = '';
+ $styleData = [];
+ foreach ($rowData as $rowDatum) {
+ switch ($rowDatum[0]) {
+ case 'C':
+ case 'X':
+ $column = substr($rowDatum, 1);
+
+ break;
+ case 'R':
+ case 'Y':
+ $row = substr($rowDatum, 1);
+
+ break;
+ case 'P':
+ $formatStyle = $rowDatum;
+
+ break;
+ case 'W':
+ [$startCol, $endCol, $columnWidth] = explode(' ', substr($rowDatum, 1));
+
+ break;
+ case 'S':
+ $this->styleSettings($rowDatum, $styleData, $fontStyle);
+
+ break;
+ }
+ }
+ $this->addFormats($spreadsheet, $formatStyle, $row, $column);
+ $this->addFonts($spreadsheet, $fontStyle, $row, $column);
+ $this->addStyle($spreadsheet, $styleData, $row, $column);
+ $this->addWidth($spreadsheet, $columnWidth, $startCol, $endCol);
+ }
+
+ private $styleSettingsFont = ['D' => 'bold', 'I' => 'italic'];
+
+ private $styleSettingsBorder = [
+ 'B' => 'bottom',
+ 'L' => 'left',
+ 'R' => 'right',
+ 'T' => 'top',
+ ];
+
+ private function styleSettings(string $rowDatum, array &$styleData, string &$fontStyle): void
+ {
+ $styleSettings = substr($rowDatum, 1);
+ $iMax = strlen($styleSettings);
+ for ($i = 0; $i < $iMax; ++$i) {
+ $char = $styleSettings[$i];
+ if (array_key_exists($char, $this->styleSettingsFont)) {
+ $styleData['font'][$this->styleSettingsFont[$char]] = true;
+ } elseif (array_key_exists($char, $this->styleSettingsBorder)) {
+ $styleData['borders'][$this->styleSettingsBorder[$char]]['borderStyle'] = Border::BORDER_THIN;
+ } elseif ($char == 'S') {
+ $styleData['fill']['fillType'] = \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_PATTERN_GRAY125;
+ } elseif ($char == 'M') {
+ if (preg_match('/M([1-9]\\d*)/', $styleSettings, $matches)) {
+ $fontStyle = $matches[1];
+ }
+ }
+ }
+ }
+
+ private function addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column): void
+ {
+ if ($formatStyle && $column > '' && $row > '') {
+ $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
+ if (isset($this->formats[$formatStyle])) {
+ $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->formats[$formatStyle]);
+ }
+ }
+ }
+
+ private function addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column): void
+ {
+ if ($fontStyle && $column > '' && $row > '') {
+ $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
+ if (isset($this->fonts[$fontStyle])) {
+ $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->fonts[$fontStyle]);
+ }
+ }
+ }
+
+ private function addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column): void
+ {
+ if ((!empty($styleData)) && $column > '' && $row > '') {
+ $columnLetter = Coordinate::stringFromColumnIndex($column);
+ $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($styleData);
+ }
+ }
+
+ private function addWidth(Spreadsheet $spreadsheet, string $columnWidth, string $startCol, string $endCol): void
+ {
+ if ($columnWidth > '') {
+ if ($startCol == $endCol) {
+ $startCol = Coordinate::stringFromColumnIndex((int) $startCol);
+ $spreadsheet->getActiveSheet()->getColumnDimension($startCol)->setWidth($columnWidth);
+ } else {
+ $startCol = Coordinate::stringFromColumnIndex($startCol);
+ $endCol = Coordinate::stringFromColumnIndex($endCol);
+ $spreadsheet->getActiveSheet()->getColumnDimension($startCol)->setWidth((float) $columnWidth);
+ do {
+ $spreadsheet->getActiveSheet()->getColumnDimension(++$startCol)->setWidth($columnWidth);
+ } while ($startCol != $endCol);
+ }
+ }
+ }
+
+ private function processPRecord(array $rowData, Spreadsheet &$spreadsheet): void
+ {
+ // Read shared styles
+ $formatArray = [];
+ $fromFormats = ['\-', '\ '];
+ $toFormats = ['-', ' '];
+ foreach ($rowData as $rowDatum) {
+ switch ($rowDatum[0]) {
+ case 'P':
+ $formatArray['numberFormat']['formatCode'] = str_replace($fromFormats, $toFormats, substr($rowDatum, 1));
+
+ break;
+ case 'E':
+ case 'F':
+ $formatArray['font']['name'] = substr($rowDatum, 1);
+
+ break;
+ case 'M':
+ $formatArray['font']['size'] = substr($rowDatum, 1) / 20;
+
+ break;
+ case 'L':
+ $this->processPColors($rowDatum, $formatArray);
+
+ break;
+ case 'S':
+ $this->processPFontStyles($rowDatum, $formatArray);
+
+ break;
+ }
+ }
+ $this->processPFinal($spreadsheet, $formatArray);
+ }
+
+ private function processPColors(string $rowDatum, array &$formatArray): void
+ {
+ if (preg_match('/L([1-9]\\d*)/', $rowDatum, $matches)) {
+ $fontColor = $matches[1] % 8;
+ $formatArray['font']['color']['argb'] = $this->colorArray[$fontColor];
+ }
+ }
+
+ private function processPFontStyles(string $rowDatum, array &$formatArray): void
+ {
+ $styleSettings = substr($rowDatum, 1);
+ $iMax = strlen($styleSettings);
+ for ($i = 0; $i < $iMax; ++$i) {
+ if (array_key_exists($styleSettings[$i], $this->fontStyleMappings)) {
+ $formatArray['font'][$this->fontStyleMappings[$styleSettings[$i]]] = true;
+ }
+ }
+ }
+
+ private function processPFinal(Spreadsheet &$spreadsheet, array $formatArray): void
+ {
+ if (array_key_exists('numberFormat', $formatArray)) {
+ $this->formats['P' . $this->format] = $formatArray;
+ ++$this->format;
+ } elseif (array_key_exists('font', $formatArray)) {
+ ++$this->fontcount;
+ $this->fonts[$this->fontcount] = $formatArray;
+ if ($this->fontcount === 1) {
+ $spreadsheet->getDefaultStyle()->applyFromArray($formatArray);
+ }
+ }
+ }
+
+ /**
+ * Loads PhpSpreadsheet from file into PhpSpreadsheet instance.
+ *
+ * @param string $pFilename
+ *
+ * @return Spreadsheet
+ */
+ public function loadIntoExisting($pFilename, Spreadsheet $spreadsheet)
+ {
+ // Open file
+ $this->canReadOrBust($pFilename);
+ $fileHandle = $this->fileHandle;
+ rewind($fileHandle);
+
+ // Create new Worksheets
+ while ($spreadsheet->getSheetCount() <= $this->sheetIndex) {
+ $spreadsheet->createSheet();
+ }
+ $spreadsheet->setActiveSheetIndex($this->sheetIndex);
+ $spreadsheet->getActiveSheet()->setTitle(basename($pFilename, '.slk'));
+
+ // Loop through file
+ $column = $row = '';
+
+ // loop through one row (line) at a time in the file
+ while (($rowDataTxt = fgets($fileHandle)) !== false) {
+ // convert SYLK encoded $rowData to UTF-8
+ $rowDataTxt = StringHelper::SYLKtoUTF8($rowDataTxt);
+
+ // explode each row at semicolons while taking into account that literal semicolon (;)
+ // is escaped like this (;;)
+ $rowData = explode("\t", str_replace('¤', ';', str_replace(';', "\t", str_replace(';;', '¤', rtrim($rowDataTxt)))));
+
+ $dataType = array_shift($rowData);
+ if ($dataType == 'P') {
+ // Read shared styles
+ $this->processPRecord($rowData, $spreadsheet);
+ } elseif ($dataType == 'C') {
+ // Read cell value data
+ $this->processCRecord($rowData, $spreadsheet, $row, $column);
+ } elseif ($dataType == 'F') {
+ // Read cell formatting
+ $this->processFRecord($rowData, $spreadsheet, $row, $column);
+ } else {
+ $this->columnRowFromRowData($rowData, $column, $row);
+ }
+ }
+
+ // Close file
+ fclose($fileHandle);
+
+ // Return
+ return $spreadsheet;
+ }
+
+ private function columnRowFromRowData(array $rowData, string &$column, string &$row): void
+ {
+ foreach ($rowData as $rowDatum) {
+ $char0 = $rowDatum[0];
+ if ($char0 === 'X' || $char0 == 'C') {
+ $column = substr($rowDatum, 1);
+ } elseif ($char0 === 'Y' || $char0 == 'R') {
+ $row = substr($rowDatum, 1);
+ }
+ }
+ }
+
+ /**
+ * Get sheet index.
+ *
+ * @return int
+ */
+ public function getSheetIndex()
+ {
+ return $this->sheetIndex;
+ }
+
+ /**
+ * Set sheet index.
+ *
+ * @param int $pValue Sheet index
+ *
+ * @return $this
+ */
+ public function setSheetIndex($pValue)
+ {
+ $this->sheetIndex = $pValue;
+
+ return $this;
+ }
+}
|