ILIAS
release_5-4 Revision v5.4.26-12-gabc799a52e6
|
Public Member Functions | |
static | __construct () |
Create a new Gnumeric. More... | |
canRead ($pFilename) | |
Can the current IReader read the file? More... | |
listWorksheetNames ($pFilename) | |
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object. More... | |
listWorksheetInfo ($pFilename) | |
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns). More... | |
load ($pFilename) | |
Loads Spreadsheet from file. More... | |
loadIntoExisting (string $pFilename, Spreadsheet $spreadsheet) | |
Loads from file into Spreadsheet instance. 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 () | |
Static Public Member Functions | |
static | gnumericMappings () |
Data Fields | |
const | NAMESPACE_GNM = 'http://www.gnumeric.org/v10.dtd' |
const | NAMESPACE_XSI = 'http://www.w3.org/2001/XMLSchema-instance' |
const | NAMESPACE_OFFICE = 'urn:oasis:names:tc:opendocument:xmlns:office:1.0' |
const | NAMESPACE_XLINK = 'http://www.w3.org/1999/xlink' |
const | NAMESPACE_DC = 'http://purl.org/dc/elements/1.1/' |
const | NAMESPACE_META = 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0' |
const | NAMESPACE_OOO = 'http://openoffice.org/2004/office' |
Static Public Attributes | |
static | $mappings |
Private Member Functions | |
gzfileGetContents ($filename) | |
processComments (SimpleXMLElement $sheet) | |
processMergedCells (?SimpleXMLElement $sheet) | |
processAutofilter (?SimpleXMLElement $sheet) | |
setColumnWidth (int $whichColumn, float $defaultWidth) | |
setColumnInvisible (int $whichColumn) | |
processColumnLoop (int $whichColumn, int $maxCol, SimpleXMLElement $columnOverride, float $defaultWidth) | |
processColumnWidths (?SimpleXMLElement $sheet, int $maxCol) | |
setRowHeight (int $whichRow, float $defaultHeight) | |
setRowInvisible (int $whichRow) | |
processRowLoop (int $whichRow, int $maxRow, SimpleXMLElement $rowOverride, float $defaultHeight) | |
processRowHeights (?SimpleXMLElement $sheet, int $maxRow) | |
processDefinedNames (?SimpleXMLElement $gnmXML) | |
parseRichText (string $is) | |
Static Private Member Functions | |
static | matchXml (XMLReader $xml, string $expectedLocalName) |
static | testSimpleXml ($value) |
Private Attributes | |
$expressions = [] | |
$spreadsheet | |
$referenceHelper | |
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 | |
Definition at line 21 of file Gnumeric.php.
static PhpOffice\PhpSpreadsheet\Reader\Gnumeric::__construct | ( | ) |
Create a new Gnumeric.
Implements PhpOffice\PhpSpreadsheet\Reader\IReader.
Definition at line 71 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\ReferenceHelper\getInstance(), and PhpOffice\PhpSpreadsheet\Reader\Security\XmlScanner\getInstance().
PhpOffice\PhpSpreadsheet\Reader\Gnumeric::canRead | ( | $pFilename | ) |
Can the current IReader read the file?
string | $pFilename |
Implements PhpOffice\PhpSpreadsheet\Reader\IReader.
Definition at line 85 of file Gnumeric.php.
References $data, and PhpOffice\PhpSpreadsheet\Shared\File\assertFile().
|
static |
Definition at line 207 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Styles\$mappings.
|
private |
string | $filename |
Definition at line 193 of file Gnumeric.php.
References $data, and $filename.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
PhpOffice\PhpSpreadsheet\Reader\Gnumeric::listWorksheetInfo | ( | $pFilename | ) |
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
string | $pFilename |
Definition at line 146 of file Gnumeric.php.
References $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().
PhpOffice\PhpSpreadsheet\Reader\Gnumeric::listWorksheetNames | ( | $pFilename | ) |
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.
string | $pFilename |
Definition at line 117 of file Gnumeric.php.
References $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), and PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions().
PhpOffice\PhpSpreadsheet\Reader\Gnumeric::load | ( | $pFilename | ) |
Loads Spreadsheet from file.
string | $pFilename |
Implements PhpOffice\PhpSpreadsheet\Reader\IReader.
Definition at line 242 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\$spreadsheet, and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
PhpOffice\PhpSpreadsheet\Reader\Gnumeric::loadIntoExisting | ( | string | $pFilename, |
Spreadsheet | $spreadsheet | ||
) |
Loads from file into Spreadsheet instance.
Definition at line 255 of file Gnumeric.php.
References $row, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\$spreadsheet, $type, $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions(), PhpOffice\PhpSpreadsheet\Reader\BaseReader\getReadFilter(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\gzfileGetContents(), if, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processAutofilter(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processComments(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processDefinedNames(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processMergedCells(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowHeights(), PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex(), and PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_FORMULA.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\load().
|
staticprivate |
Definition at line 103 of file Gnumeric.php.
|
private |
Definition at line 533 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processComments().
|
private |
Definition at line 377 of file Gnumeric.php.
References $attributes.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 407 of file Gnumeric.php.
References $columnCount, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnInvisible(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnWidth().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths().
|
private |
Definition at line 429 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnWidth().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 212 of file Gnumeric.php.
References $comment, $key, and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\parseRichText().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 511 of file Gnumeric.php.
References $name, PhpOffice\PhpSpreadsheet\DefinedName\createInstance(), and PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\extractSheetTitle().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 365 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 487 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
|
private |
Definition at line 465 of file Gnumeric.php.
References $row, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setRowHeight(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setRowInvisible().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowHeights().
|
private |
Definition at line 399 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop().
|
private |
Definition at line 391 of file Gnumeric.php.
References PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths().
|
private |
Definition at line 449 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().
|
private |
Definition at line 457 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().
|
staticprivate |
mixed | $value |
Definition at line 230 of file Gnumeric.php.
|
private |
Definition at line 42 of file Gnumeric.php.
|
static |
Definition at line 55 of file Gnumeric.php.
|
private |
Definition at line 52 of file Gnumeric.php.
|
private |
Definition at line 49 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\load(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_DC = 'http://purl.org/dc/elements/1.1/' |
Definition at line 31 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_GNM = 'http://www.gnumeric.org/v10.dtd' |
Definition at line 23 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\PageSetup\buildMarginSet().
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_META = 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0' |
Definition at line 33 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\docPropertiesMeta(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_OFFICE = 'urn:oasis:names:tc:opendocument:xmlns:office:1.0' |
Definition at line 27 of file Gnumeric.php.
Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_OOO = 'http://openoffice.org/2004/office' |
Definition at line 35 of file Gnumeric.php.
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_XLINK = 'http://www.w3.org/1999/xlink' |
Definition at line 29 of file Gnumeric.php.
const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_XSI = 'http://www.w3.org/2001/XMLSchema-instance' |
Definition at line 25 of file Gnumeric.php.