Inheritance diagram for PhpOffice\PhpSpreadsheet\Reader\Slk:

Collaboration diagram for PhpOffice\PhpSpreadsheet\Reader\Slk:

Public Member Functions
	__construct ()
	Create a new SYLK Reader instance. More...

	canRead ($pFilename)
	Validate that the current file is a SYLK file. More...

	setInputEncoding ($pValue)
	Set input encoding. More...

	getInputEncoding ()
	Get input encoding. More...

	listWorksheetInfo ($pFilename)
	Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns). More...

	load ($pFilename)
	Loads PhpSpreadsheet from file. More...

	loadIntoExisting ($pFilename, Spreadsheet $spreadsheet)
	Loads PhpSpreadsheet from file into PhpSpreadsheet instance. More...

	getSheetIndex ()
	Get sheet index. More...

	setSheetIndex ($pValue)
	Set sheet index. More...

Public Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	__construct ()
	IReader constructor. More...

	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...

	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...

	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...

	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...

	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...

	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...

	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...

	setLoadSheetsOnly ($value)
	Set which sheets to load. More...

	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...

	getReadFilter ()
	Read filter. More...

	setReadFilter (IReadFilter $pValue)
	Set read filter. More...

	getSecurityScanner ()

	__construct ()
	IReader constructor. More...

	canRead ($pFilename)
	Can the current IReader read the file? More...

	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...

	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...

	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...

	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...

	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...

	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...

	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...

	setLoadSheetsOnly ($value)
	Set which sheets to load. More...

	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...

	getReadFilter ()
	Read filter. More...

	setReadFilter (IReadFilter $pValue)
	Set read filter. More...

	load ($pFilename)
	Loads PhpSpreadsheet from file. More...

Private Member Functions
	canReadOrBust (string $pFilename)

	processFormula (string $rowDatum, bool &$hasCalculatedValue, string &$cellDataFormula, string $row, string $column)

	processCRecord (array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column)

	processCFinal (Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate)

	processFRecord (array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column)

	styleSettings (string $rowDatum, array &$styleData, string &$fontStyle)

	addFormats (Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column)

	addFonts (Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column)

	addStyle (Spreadsheet &$spreadsheet, array $styleData, string $row, string $column)

	addWidth (Spreadsheet $spreadsheet, string $columnWidth, string $startCol, string $endCol)

	processPRecord (array $rowData, Spreadsheet &$spreadsheet)

	processPColors (string $rowDatum, array &$formatArray)

	processPFontStyles (string $rowDatum, array &$formatArray)

	processPFinal (Spreadsheet &$spreadsheet, array $formatArray)

	columnRowFromRowData (array $rowData, string &$column, string &$row)

Private Attributes
	$inputEncoding = 'ANSI'

	$sheetIndex = 0

	$formats = []

	$format = 0

	$fonts = []

	$fontcount = 0

	$colorArray

	$fontStyleMappings

	$styleSettingsFont = ['D' => 'bold', 'I' => 'italic']

	$styleSettingsBorder

Additional Inherited Members
Protected Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	openFile ($pFilename)
	Open file for reading. More...

Protected Attributes inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	$readDataOnly = false

	$readEmptyCells = true

	$includeCharts = false

	$loadSheetsOnly

	$readFilter

	$fileHandle

	$securityScanner

Detailed Description

Definition at line 14 of file Slk.php.

Constructor & Destructor Documentation

◆ __construct()

PhpOffice\PhpSpreadsheet\Reader\Slk::__construct ( )

Create a new SYLK Reader instance.

Reimplemented from PhpOffice\PhpSpreadsheet\Reader\BaseReader.

Definition at line 61 of file Slk.php.

    {
        parent::__construct();
    }

Member Function Documentation

◆ addFonts()

PhpOffice\PhpSpreadsheet\Reader\Slk::addFonts	(	Spreadsheet &	$spreadsheet,
		string	$fontStyle,
		string	$row,
		string	$column
	)

private

Definition at line 399 of file Slk.php.

                                                                                                        : void
    {
        if ($fontStyle && $column > '' && $row > '') {
            $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
            if (isset($this->fonts[$fontStyle])) {
                $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->fonts[$fontStyle]);
            }
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processFRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ addFormats()

PhpOffice\PhpSpreadsheet\Reader\Slk::addFormats	(	Spreadsheet &	$spreadsheet,
		string	$formatStyle,
		string	$row,
		string	$column
	)

private

Definition at line 389 of file Slk.php.

                                                                                                            : void
    {
        if ($formatStyle && $column > '' && $row > '') {
            $columnLetter = Coordinate::stringFromColumnIndex((int) $column);
            if (isset($this->formats[$formatStyle])) {
                $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->formats[$formatStyle]);
            }
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processFRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ addStyle()

PhpOffice\PhpSpreadsheet\Reader\Slk::addStyle	(	Spreadsheet &	$spreadsheet,
		array	$styleData,
		string	$row,
		string	$column
	)

private

Definition at line 409 of file Slk.php.

                                                                                                       : void
    {
        if ((!empty($styleData)) && $column > '' && $row > '') {
            $columnLetter = Coordinate::stringFromColumnIndex($column);
            $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($styleData);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processFRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ addWidth()

PhpOffice\PhpSpreadsheet\Reader\Slk::addWidth	(	Spreadsheet	$spreadsheet,
		string	$columnWidth,
		string	$startCol,
		string	$endCol
	)

private

Definition at line 417 of file Slk.php.

                                                                                                              : void
    {
        if ($columnWidth > '') {
            if ($startCol == $endCol) {
                $startCol = Coordinate::stringFromColumnIndex((int) $startCol);
                $spreadsheet->getActiveSheet()->getColumnDimension($startCol)->setWidth((float) $columnWidth);
            } else {
                $startCol = Coordinate::stringFromColumnIndex($startCol);
                $endCol = Coordinate::stringFromColumnIndex($endCol);
                $spreadsheet->getActiveSheet()->getColumnDimension($startCol)->setWidth((float) $columnWidth);
                do {
                    $spreadsheet->getActiveSheet()->getColumnDimension(++$startCol)->setWidth((float) $columnWidth);
                } while ($startCol !== $endCol);
            }
        }
    }

References PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processFRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ canRead()

PhpOffice\PhpSpreadsheet\Reader\Slk::canRead ( $pFilename )

Validate that the current file is a SYLK file.

Parameters

string $pFilename

Returns: bool

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 73 of file Slk.php.

    {
        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;
    }

References $data, and PhpOffice\PhpSpreadsheet\Reader\BaseReader\openFile().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\canReadOrBust().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ canReadOrBust()

PhpOffice\PhpSpreadsheet\Reader\Slk::canReadOrBust ( string $pFilename )

private

Definition at line 97 of file Slk.php.

                                                     : void
    {
        if (!$this->canRead($pFilename)) {
            throw new ReaderException($pFilename . ' is an Invalid SYLK file.');
        }
        $this->openFile($pFilename);
    }

References PhpOffice\PhpSpreadsheet\Reader\Slk\canRead(), and PhpOffice\PhpSpreadsheet\Reader\BaseReader\openFile().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\listWorksheetInfo(), and PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ columnRowFromRowData()

PhpOffice\PhpSpreadsheet\Reader\Slk::columnRowFromRowData	(	array	$rowData,
		string &	$column,
		string &	$row
	)

private

Definition at line 556 of file Slk.php.

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

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the caller graph for this function:

◆ getInputEncoding()

PhpOffice\PhpSpreadsheet\Reader\Slk::getInputEncoding ( )

Get input encoding.

Deprecated:: no use is made of this property

Returns: string

@codeCoverageIgnore

Definition at line 132 of file Slk.php.

    {
        return $this->inputEncoding;
    }

References PhpOffice\PhpSpreadsheet\Reader\Slk\$inputEncoding.

◆ getSheetIndex()

PhpOffice\PhpSpreadsheet\Reader\Slk::getSheetIndex ( )

Get sheet index.

Returns: int

Definition at line 573 of file Slk.php.

    {
        return $this->sheetIndex;
    }

References PhpOffice\PhpSpreadsheet\Reader\Slk\$sheetIndex.

◆ listWorksheetInfo()

PhpOffice\PhpSpreadsheet\Reader\Slk::listWorksheetInfo ( $pFilename )

Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).

Parameters

string $pFilename

Returns: array

Definition at line 144 of file Slk.php.

    {
        // 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 = (int) 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;
    }

References PhpOffice\PhpSpreadsheet\Reader\BaseReader\$fileHandle, PhpOffice\PhpSpreadsheet\Reader\Slk\canReadOrBust(), PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex(), and PhpOffice\PhpSpreadsheet\Shared\StringHelper\SYLKtoUTF8().

Here is the call graph for this function:

◆ load()

PhpOffice\PhpSpreadsheet\Reader\Slk::load ( $pFilename )

Loads PhpSpreadsheet from file.

Parameters

string $pFilename

Returns: Spreadsheet

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 204 of file Slk.php.

    {
        // Create new Spreadsheet
        $spreadsheet = new Spreadsheet();
 
        // Load into this instance
        return $this->loadIntoExisting($pFilename, $spreadsheet);
    }

References PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the call graph for this function:

◆ loadIntoExisting()

PhpOffice\PhpSpreadsheet\Reader\Slk::loadIntoExisting	(		$pFilename,
		Spreadsheet	$spreadsheet
	)

Loads PhpSpreadsheet from file into PhpSpreadsheet instance.

Parameters

string $pFilename

Returns: Spreadsheet

Definition at line 508 of file Slk.php.

    {
        // 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(substr(basename($pFilename, '.slk'), 0, Worksheet::SHEET_TITLE_MAXIMUM_LENGTH));
 
        // 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;
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\load().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processCFinal()

PhpOffice\PhpSpreadsheet\Reader\Slk::processCFinal	(	Spreadsheet &	$spreadsheet,
		bool	$hasCalculatedValue,
		string	$cellDataFormula,
		string	$cellData,
		string	$coordinate
	)

private

Definition at line 311 of file Slk.php.

                                                                                                                                                      : void
    {
        // Set cell value
        $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
        if ($hasCalculatedValue) {
            $cellData = Calculation::unwrapResult($cellData);
            $spreadsheet->getActiveSheet()->getCell($coordinate)->setCalculatedValue($cellData);
        }
    }

References PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), and PhpOffice\PhpSpreadsheet\Calculation\Calculation\unwrapResult().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processCRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processCRecord()

PhpOffice\PhpSpreadsheet\Reader\Slk::processCRecord	(	array	$rowData,
		Spreadsheet &	$spreadsheet,
		string &	$row,
		string &	$column
	)

private

Definition at line 277 of file Slk.php.

                                                                                                             : 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");
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Slk\processCFinal(), PhpOffice\PhpSpreadsheet\Reader\Slk\processFormula(), PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex(), and PhpOffice\PhpSpreadsheet\Calculation\Calculation\unwrapResult().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processFormula()

PhpOffice\PhpSpreadsheet\Reader\Slk::processFormula	(	string	$rowDatum,
		bool &	$hasCalculatedValue,
		string &	$cellDataFormula,
		string	$row,
		string	$column
	)

private

Definition at line 230 of file Slk.php.

                                                                                                                                       : 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 = (int) $row + (int) 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 = (int) $column + (int) 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;
    }

References $key, $row, and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processCRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processFRecord()

PhpOffice\PhpSpreadsheet\Reader\Slk::processFRecord	(	array	$rowData,
		Spreadsheet &	$spreadsheet,
		string &	$row,
		string &	$column
	)

private

Definition at line 321 of file Slk.php.

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

References $row, PhpOffice\PhpSpreadsheet\Reader\Slk\addFonts(), PhpOffice\PhpSpreadsheet\Reader\Slk\addFormats(), PhpOffice\PhpSpreadsheet\Reader\Slk\addStyle(), PhpOffice\PhpSpreadsheet\Reader\Slk\addWidth(), and PhpOffice\PhpSpreadsheet\Reader\Slk\styleSettings().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processPColors()

PhpOffice\PhpSpreadsheet\Reader\Slk::processPColors	(	string	$rowDatum,
		array &	$formatArray
	)

private

Definition at line 468 of file Slk.php.

                                                                          : void
    {
        if (preg_match('/L([1-9]\\d*)/', $rowDatum, $matches)) {
            $fontColor = $matches[1] % 8;
            $formatArray['font']['color']['argb'] = $this->colorArray[$fontColor];
        }
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processPRecord().

Here is the caller graph for this function:

◆ processPFinal()

PhpOffice\PhpSpreadsheet\Reader\Slk::processPFinal	(	Spreadsheet &	$spreadsheet,
		array	$formatArray
	)

private

Definition at line 487 of file Slk.php.

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

References PhpOffice\PhpSpreadsheet\Reader\Slk\$fontcount, PhpOffice\PhpSpreadsheet\Reader\Slk\$format, and PhpOffice\PhpSpreadsheet\Spreadsheet\getDefaultStyle().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processPRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processPFontStyles()

PhpOffice\PhpSpreadsheet\Reader\Slk::processPFontStyles	(	string	$rowDatum,
		array &	$formatArray
	)

private

Definition at line 476 of file Slk.php.

                                                                              : 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;
            }
        }
    }

References $i.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processPRecord().

Here is the caller graph for this function:

◆ processPRecord()

PhpOffice\PhpSpreadsheet\Reader\Slk::processPRecord	(	array	$rowData,
		Spreadsheet &	$spreadsheet
	)

private

Definition at line 434 of file Slk.php.

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

References PhpOffice\PhpSpreadsheet\Reader\Slk\processPColors(), PhpOffice\PhpSpreadsheet\Reader\Slk\processPFinal(), and PhpOffice\PhpSpreadsheet\Reader\Slk\processPFontStyles().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setInputEncoding()

PhpOffice\PhpSpreadsheet\Reader\Slk::setInputEncoding ( $pValue )

Set input encoding.

Deprecated:: no use is made of this property

Parameters

string $pValue Input encoding, eg: 'ANSI'

Returns: $this

@codeCoverageIgnore

Definition at line 116 of file Slk.php.

    {
        $this->inputEncoding = $pValue;
 
        return $this;
    }

◆ setSheetIndex()

PhpOffice\PhpSpreadsheet\Reader\Slk::setSheetIndex ( $pValue )

Set sheet index.

Parameters

int $pValue Sheet index

Returns: $this

Definition at line 585 of file Slk.php.

    {
        $this->sheetIndex = $pValue;
 
        return $this;
    }

◆ styleSettings()

PhpOffice\PhpSpreadsheet\Reader\Slk::styleSettings	(	string	$rowDatum,
		array &	$styleData,
		string &	$fontStyle
	)

private

Definition at line 369 of file Slk.php.

                                                                                           : 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];
                }
            }
        }
    }

References $i, and PhpOffice\PhpSpreadsheet\Style\Fill\FILL_PATTERN_GRAY125.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processFRecord().

Here is the caller graph for this function:

Field Documentation

◆ $colorArray

PhpOffice\PhpSpreadsheet\Reader\Slk::$colorArray

private

Initial value:

= [
        'FF00FFFF', 
        'FF000000', 
        'FFFFFFFF', 
        'FFFF0000', 
        'FF00FF00', 
        'FF0000FF', 
        'FFFFFF00', 
        'FFFF00FF', 
    ]

Definition at line 213 of file Slk.php.

◆ $fontcount

PhpOffice\PhpSpreadsheet\Reader\Slk::$fontcount = 0

private

Definition at line 56 of file Slk.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processPFinal().

◆ $fonts

PhpOffice\PhpSpreadsheet\Reader\Slk::$fonts = []

private

Definition at line 49 of file Slk.php.

◆ $fontStyleMappings

PhpOffice\PhpSpreadsheet\Reader\Slk::$fontStyleMappings

private

Initial value:

= [
        'B' => 'bold',
        'I' => 'italic',
        'U' => 'underline',
    ]

Definition at line 224 of file Slk.php.

◆ $format

PhpOffice\PhpSpreadsheet\Reader\Slk::$format = 0

private

Definition at line 42 of file Slk.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\processPFinal().

◆ $formats

PhpOffice\PhpSpreadsheet\Reader\Slk::$formats = []

private

Definition at line 35 of file Slk.php.

◆ $inputEncoding

PhpOffice\PhpSpreadsheet\Reader\Slk::$inputEncoding = 'ANSI'

private

Definition at line 21 of file Slk.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\getInputEncoding().

◆ $sheetIndex

PhpOffice\PhpSpreadsheet\Reader\Slk::$sheetIndex = 0

private

Definition at line 28 of file Slk.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Slk\getSheetIndex().

◆ $styleSettingsBorder

PhpOffice\PhpSpreadsheet\Reader\Slk::$styleSettingsBorder

private

Initial value:

= [
        'B' => 'bottom',
        'L' => 'left',
        'R' => 'right',
        'T' => 'top',
    ]

Definition at line 362 of file Slk.php.

◆ $styleSettingsFont

PhpOffice\PhpSpreadsheet\Reader\Slk::$styleSettingsFont = ['D' => 'bold', 'I' => 'italic']

private

Definition at line 360 of file Slk.php.

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Slk.php

Public Member Functions

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addFonts()

◆ addFormats()

◆ addStyle()

◆ addWidth()

◆ canRead()

◆ canReadOrBust()

◆ columnRowFromRowData()

◆ getInputEncoding()

◆ getSheetIndex()

◆ listWorksheetInfo()

◆ load()

◆ loadIntoExisting()

◆ processCFinal()

◆ processCRecord()

◆ processFormula()

◆ processFRecord()

◆ processPColors()

◆ processPFinal()

◆ processPFontStyles()

◆ processPRecord()

◆ setInputEncoding()

◆ setSheetIndex()

◆ styleSettings()

Field Documentation

◆ $colorArray

◆ $fontcount

◆ $fonts

◆ $fontStyleMappings

◆ $format

◆ $formats

◆ $inputEncoding

◆ $sheetIndex

◆ $styleSettingsBorder

◆ $styleSettingsFont