Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

Differences Between: [Versions 310 and 311] [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403] [Versions 39 and 311]

(no description)

File Size: 591 lines (20 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class


Class: Slk  - X-Ref

__construct()   X-Ref
Create a new SYLK Reader instance.


canRead($pFilename)   X-Ref
Validate that the current file is a SYLK file.

param: string $pFilename
return: bool

canReadOrBust(string $pFilename)   X-Ref
No description

setInputEncoding($pValue)   X-Ref
Set input encoding.

param: string $pValue Input encoding, eg: 'ANSI'
return: $this

getInputEncoding()   X-Ref
Get input encoding.

return: string

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

param: string $pFilename
return: array

load($pFilename)   X-Ref
Loads PhpSpreadsheet from file.

param: string $pFilename
return: Spreadsheet

processFormula(string $rowDatum, bool &$hasCalculatedValue, string &$cellDataFormula, string $row, string $column)   X-Ref
No description

processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column)   X-Ref
No description

processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate)   X-Ref
No description

processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column)   X-Ref
No description

styleSettings(string $rowDatum, array &$styleData, string &$fontStyle)   X-Ref
No description

addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column)   X-Ref
No description

addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column)   X-Ref
No description

addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column)   X-Ref
No description

addWidth(Spreadsheet $spreadsheet, string $columnWidth, string $startCol, string $endCol)   X-Ref
No description

processPRecord(array $rowData, Spreadsheet &$spreadsheet)   X-Ref
No description

processPColors(string $rowDatum, array &$formatArray)   X-Ref
No description

processPFontStyles(string $rowDatum, array &$formatArray)   X-Ref
No description

processPFinal(Spreadsheet &$spreadsheet, array $formatArray)   X-Ref
No description

loadIntoExisting($pFilename, Spreadsheet $spreadsheet)   X-Ref
Loads PhpSpreadsheet from file into PhpSpreadsheet instance.

param: string $pFilename
return: Spreadsheet

columnRowFromRowData(array $rowData, string &$column, string &$row)   X-Ref
No description

getSheetIndex()   X-Ref
Get sheet index.

return: int

setSheetIndex($pValue)   X-Ref
Set sheet index.

param: int $pValue Sheet index
return: $this