ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
Public Member Functions | Private Member Functions | Static Private Member Functions | Private Attributes
PHPExcel_Reader_Gnumeric Class Reference
+ Inheritance diagram for PHPExcel_Reader_Gnumeric:
+ Collaboration diagram for PHPExcel_Reader_Gnumeric:

Public Member Functions

 __construct ()
 Create a new PHPExcel_Reader_Gnumeric. More...
 
 canRead ($pFilename)
 Can the current PHPExcel_Reader_IReader read the file? More...
 
 listWorksheetNames ($pFilename)
 Reads names of the worksheets from a file, without parsing the whole file to a PHPExcel object. More...
 
 listWorksheetInfo ($pFilename)
 Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns) More...
 
 load ($pFilename)
 Loads PHPExcel from file. More...
 
 loadIntoExisting ($pFilename, PHPExcel $objPHPExcel)
 Loads PHPExcel from file into PHPExcel instance. More...
 
- Public Member Functions inherited from PHPExcel_Reader_Abstract
 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=FALSE)
 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...
 
 getIncludeCharts ()
 Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...
 
 setIncludeCharts ($pValue=FALSE)
 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=NULL)
 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 (PHPExcel_Reader_IReadFilter $pValue)
 Set read filter. More...
 
 canRead ($pFilename)
 Can the current PHPExcel_Reader_IReader read the file? More...
 
 securityScan ($xml)
 Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks. More...
 
 securityScanFile ($filestream)
 Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks. More...
 
 canRead ($pFilename)
 Can the current PHPExcel_Reader_IReader read the file? More...
 
 load ($pFilename)
 

Private Member Functions

 _gzfileGetContents ($filename)
 
 _parseRichText ($is='')
 

Static Private Member Functions

static _parseBorderAttributes ($borderAttributes)
 
static _parseGnumericColour ($gnmColour)
 

Private Attributes

 $_styles = array()
 
 $_expressions = array()
 
 $_referenceHelper = null
 

Additional Inherited Members

- Protected Member Functions inherited from PHPExcel_Reader_Abstract
 _openFile ($pFilename)
 Open file for reading. More...
 
- Protected Attributes inherited from PHPExcel_Reader_Abstract
 $_readDataOnly = FALSE
 
 $_includeCharts = FALSE
 
 $_loadSheetsOnly = NULL
 
 $_readFilter = NULL
 
 $_fileHandle = NULL
 

Detailed Description

Definition at line 45 of file Gnumeric.php.

Constructor & Destructor Documentation

◆ __construct()

PHPExcel_Reader_Gnumeric::__construct ( )

Create a new PHPExcel_Reader_Gnumeric.

Definition at line 67 of file Gnumeric.php.

67 {
68 $this->_readFilter = new PHPExcel_Reader_DefaultReadFilter();
69 $this->_referenceHelper = PHPExcel_ReferenceHelper::getInstance();
70 }
PHPExcel_Reader_DefaultReadFilter
Definition: DefaultReadFilter.php:46
PHPExcel_ReferenceHelper\getInstance
static getInstance()
Get an instance of this class.
Definition: ReferenceHelper.php:57

References PHPExcel_ReferenceHelper\getInstance().

+ Here is the call graph for this function:

Member Function Documentation

◆ _gzfileGetContents()

PHPExcel_Reader_Gnumeric::_gzfileGetContents (   $filename)
private

Definition at line 192 of file Gnumeric.php.

192 {
193 $file = @gzopen($filename, 'rb');
194 if ($file !== false) {
195 $data = '';
196 while (!gzeof($file)) {
197 $data .= gzread($file, 1024);
198 }
199 gzclose($file);
200 }
201 return $data;
202 }
$file
if(!file_exists("$old.txt")) if( $old===$new) if(file_exists("$new.txt")) $file
Definition: rename-config.php:43

References $data, $file, and $filename.

Referenced by loadIntoExisting().

+ Here is the caller graph for this function:

◆ _parseBorderAttributes()

static PHPExcel_Reader_Gnumeric::_parseBorderAttributes (   $borderAttributes)
staticprivate

Definition at line 797 of file Gnumeric.php.

798 {
799 $styleArray = array();
800
801 if (isset($borderAttributes["Color"])) {
802 $RGB = self::_parseGnumericColour($borderAttributes["Color"]);
803 $styleArray['color']['rgb'] = $RGB;
804 }
805
806 switch ($borderAttributes["Style"]) {
807 case '0' :
808 $styleArray['style'] = PHPExcel_Style_Border::BORDER_NONE;
809 break;
810 case '1' :
811 $styleArray['style'] = PHPExcel_Style_Border::BORDER_THIN;
812 break;
813 case '2' :
814 $styleArray['style'] = PHPExcel_Style_Border::BORDER_MEDIUM;
815 break;
816 case '4' :
817 $styleArray['style'] = PHPExcel_Style_Border::BORDER_DASHED;
818 break;
819 case '5' :
820 $styleArray['style'] = PHPExcel_Style_Border::BORDER_THICK;
821 break;
822 case '6' :
823 $styleArray['style'] = PHPExcel_Style_Border::BORDER_DOUBLE;
824 break;
825 case '7' :
826 $styleArray['style'] = PHPExcel_Style_Border::BORDER_DOTTED;
827 break;
828 case '9' :
829 $styleArray['style'] = PHPExcel_Style_Border::BORDER_DASHDOT;
830 break;
831 case '10' :
832 $styleArray['style'] = PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT;
833 break;
834 case '11' :
835 $styleArray['style'] = PHPExcel_Style_Border::BORDER_DASHDOTDOT;
836 break;
837 case '12' :
838 $styleArray['style'] = PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT;
839 break;
840 case '13' :
841 $styleArray['style'] = PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT;
842 break;
843 case '3' :
844 $styleArray['style'] = PHPExcel_Style_Border::BORDER_SLANTDASHDOT;
845 break;
846 case '8' :
847 $styleArray['style'] = PHPExcel_Style_Border::BORDER_MEDIUMDASHED;
848 break;
849 }
850 return $styleArray;
851 }
PHPExcel_Reader_Gnumeric\_parseGnumericColour
static _parseGnumericColour($gnmColour)
Definition: Gnumeric.php:863
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOTDOT
const BORDER_MEDIUMDASHDOTDOT
Definition: Border.php:48
PHPExcel_Style_Border\BORDER_THIN
const BORDER_THIN
Definition: Border.php:52
PHPExcel_Style_Border\BORDER_THICK
const BORDER_THICK
Definition: Border.php:51
PHPExcel_Style_Border\BORDER_DOTTED
const BORDER_DOTTED
Definition: Border.php:43
PHPExcel_Style_Border\BORDER_MEDIUMDASHED
const BORDER_MEDIUMDASHED
Definition: Border.php:49
PHPExcel_Style_Border\BORDER_DASHDOT
const BORDER_DASHDOT
Definition: Border.php:40
PHPExcel_Style_Border\BORDER_SLANTDASHDOT
const BORDER_SLANTDASHDOT
Definition: Border.php:50
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOT
const BORDER_MEDIUMDASHDOT
Definition: Border.php:47
PHPExcel_Style_Border\BORDER_MEDIUM
const BORDER_MEDIUM
Definition: Border.php:46
PHPExcel_Style_Border\BORDER_DASHED
const BORDER_DASHED
Definition: Border.php:42
PHPExcel_Style_Border\BORDER_DASHDOTDOT
const BORDER_DASHDOTDOT
Definition: Border.php:41
PHPExcel_Style_Border\BORDER_DOUBLE
const BORDER_DOUBLE
Definition: Border.php:44
PHPExcel_Style_Border\BORDER_NONE
const BORDER_NONE
Definition: Border.php:39

References PHPExcel_Style_Border\BORDER_DASHDOT, PHPExcel_Style_Border\BORDER_DASHDOTDOT, PHPExcel_Style_Border\BORDER_DASHED, PHPExcel_Style_Border\BORDER_DOTTED, PHPExcel_Style_Border\BORDER_DOUBLE, PHPExcel_Style_Border\BORDER_MEDIUM, PHPExcel_Style_Border\BORDER_MEDIUMDASHDOT, PHPExcel_Style_Border\BORDER_MEDIUMDASHDOTDOT, PHPExcel_Style_Border\BORDER_MEDIUMDASHED, PHPExcel_Style_Border\BORDER_NONE, PHPExcel_Style_Border\BORDER_SLANTDASHDOT, PHPExcel_Style_Border\BORDER_THICK, and PHPExcel_Style_Border\BORDER_THIN.

◆ _parseGnumericColour()

static PHPExcel_Reader_Gnumeric::_parseGnumericColour (   $gnmColour)
staticprivate

Definition at line 863 of file Gnumeric.php.

863 {
864 list($gnmR,$gnmG,$gnmB) = explode(':',$gnmColour);
865 $gnmR = substr(str_pad($gnmR,4,'0',STR_PAD_RIGHT),0,2);
866 $gnmG = substr(str_pad($gnmG,4,'0',STR_PAD_RIGHT),0,2);
867 $gnmB = substr(str_pad($gnmB,4,'0',STR_PAD_RIGHT),0,2);
868 $RGB = $gnmR.$gnmG.$gnmB;
869// echo 'Excel Colour: ',$RGB,'<br />';
870 return $RGB;
871 }

◆ _parseRichText()

PHPExcel_Reader_Gnumeric::_parseRichText (   $is = '')
private

Definition at line 854 of file Gnumeric.php.

854 {
855 $value = new PHPExcel_RichText();
856
857 $value->createText($is);
858
859 return $value;
860 }
PHPExcel_RichText

◆ canRead()

PHPExcel_Reader_Gnumeric::canRead (   $pFilename)

Can the current PHPExcel_Reader_IReader read the file?

Parameters
string$pFilename
Returns
boolean
Exceptions
PHPExcel_Reader_Exception

Reimplemented from PHPExcel_Reader_Abstract.

Definition at line 80 of file Gnumeric.php.

81 {
82 // Check if file exists
83 if (!file_exists($pFilename)) {
84 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
85 }
86
87 // Check if gzlib functions are available
88 if (!function_exists('gzread')) {
89 throw new PHPExcel_Reader_Exception("gzlib library is not enabled");
90 }
91
92 // Read signature data (first 3 bytes)
93 $fh = fopen($pFilename, 'r');
94 $data = fread($fh, 2);
95 fclose($fh);
96
97 if ($data != chr(0x1F).chr(0x8B)) {
98 return false;
99 }
100
101 return true;
102 }
PHPExcel_Reader_Exception
Definition: Exception.php:36

References $data, and $fh.

◆ listWorksheetInfo()

PHPExcel_Reader_Gnumeric::listWorksheetInfo (   $pFilename)

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

Parameters
string$pFilename
Exceptions
PHPExcel_Reader_Exception

Definition at line 145 of file Gnumeric.php.

146 {
147 // Check if file exists
148 if (!file_exists($pFilename)) {
149 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
150 }
151
152 $xml = new XMLReader();
153 $xml->xml(
154 $this->securityScanFile('compress.zlib://'.realpath($pFilename)), null, PHPExcel_Settings::getLibXmlLoaderOptions()
155 );
156 $xml->setParserProperty(2,true);
157
158 $worksheetInfo = array();
159 while ($xml->read()) {
160 if ($xml->name == 'gnm:Sheet' && $xml->nodeType == XMLReader::ELEMENT) {
161 $tmpInfo = array(
162 'worksheetName' => '',
163 'lastColumnLetter' => 'A',
164 'lastColumnIndex' => 0,
165 'totalRows' => 0,
166 'totalColumns' => 0,
167 );
168
169 while ($xml->read()) {
170 if ($xml->name == 'gnm:Name' && $xml->nodeType == XMLReader::ELEMENT) {
171 $xml->read(); // Move onto the value node
172 $tmpInfo['worksheetName'] = (string) $xml->value;
173 } elseif ($xml->name == 'gnm:MaxCol' && $xml->nodeType == XMLReader::ELEMENT) {
174 $xml->read(); // Move onto the value node
175 $tmpInfo['lastColumnIndex'] = (int) $xml->value;
176 $tmpInfo['totalColumns'] = (int) $xml->value + 1;
177 } elseif ($xml->name == 'gnm:MaxRow' && $xml->nodeType == XMLReader::ELEMENT) {
178 $xml->read(); // Move onto the value node
179 $tmpInfo['totalRows'] = (int) $xml->value + 1;
180 break;
181 }
182 }
183 $tmpInfo['lastColumnLetter'] = PHPExcel_Cell::stringFromColumnIndex($tmpInfo['lastColumnIndex']);
184 $worksheetInfo[] = $tmpInfo;
185 }
186 }
187
188 return $worksheetInfo;
189 }
PHPExcel_Cell\stringFromColumnIndex
static stringFromColumnIndex($pColumnIndex=0)
String from columnindex.
Definition: Cell.php:825
PHPExcel_Reader_Abstract\securityScanFile
securityScanFile($filestream)
Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks.
Definition: Abstract.php:251
PHPExcel_Settings\getLibXmlLoaderOptions
static getLibXmlLoaderOptions()
Get default options for libxml loader.
Definition: Settings.php:381

References PHPExcel_Settings\getLibXmlLoaderOptions(), PHPExcel_Reader_Abstract\securityScanFile(), and PHPExcel_Cell\stringFromColumnIndex().

+ Here is the call graph for this function:

◆ listWorksheetNames()

PHPExcel_Reader_Gnumeric::listWorksheetNames (   $pFilename)

Reads names of the worksheets from a file, without parsing the whole file to a PHPExcel object.

Parameters
string$pFilename
Exceptions
PHPExcel_Reader_Exception

Definition at line 111 of file Gnumeric.php.

112 {
113 // Check if file exists
114 if (!file_exists($pFilename)) {
115 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
116 }
117
118 $xml = new XMLReader();
119 $xml->xml(
120 $this->securityScanFile('compress.zlib://'.realpath($pFilename)), null, PHPExcel_Settings::getLibXmlLoaderOptions()
121 );
122 $xml->setParserProperty(2,true);
123
124 $worksheetNames = array();
125 while ($xml->read()) {
126 if ($xml->name == 'gnm:SheetName' && $xml->nodeType == XMLReader::ELEMENT) {
127 $xml->read(); // Move onto the value node
128 $worksheetNames[] = (string) $xml->value;
129 } elseif ($xml->name == 'gnm:Sheets') {
130 // break out of the loop once we've got our sheet names rather than parse the entire file
131 break;
132 }
133 }
134
135 return $worksheetNames;
136 }

References PHPExcel_Settings\getLibXmlLoaderOptions(), and PHPExcel_Reader_Abstract\securityScanFile().

+ Here is the call graph for this function:

◆ load()

PHPExcel_Reader_Gnumeric::load (   $pFilename)

Loads PHPExcel from file.

Parameters
string$pFilename
Returns
PHPExcel
Exceptions
PHPExcel_Reader_Exception

Implements PHPExcel_Reader_IReader.

Definition at line 212 of file Gnumeric.php.

213 {
214 // Create new PHPExcel
215 $objPHPExcel = new PHPExcel();
216
217 // Load into this instance
218 return $this->loadIntoExisting($pFilename, $objPHPExcel);
219 }
$objPHPExcel
$objPHPExcel
Definition: 01pharSimple.php:42
PHPExcel_Reader_Gnumeric\loadIntoExisting
loadIntoExisting($pFilename, PHPExcel $objPHPExcel)
Loads PHPExcel from file into PHPExcel instance.
Definition: Gnumeric.php:230

References $objPHPExcel, and loadIntoExisting().

+ Here is the call graph for this function:

◆ loadIntoExisting()

PHPExcel_Reader_Gnumeric::loadIntoExisting (   $pFilename,
PHPExcel  $objPHPExcel 
)

Loads PHPExcel from file into PHPExcel instance.

Parameters
string$pFilename
PHPExcel$objPHPExcel
Returns
PHPExcel
Exceptions
PHPExcel_Reader_Exception

Definition at line 230 of file Gnumeric.php.

231 {
232 // Check if file exists
233 if (!file_exists($pFilename)) {
234 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
235 }
236
237 $timezoneObj = new DateTimeZone('Europe/London');
238 $GMT = new DateTimeZone('UTC');
239
240 $gFileData = $this->_gzfileGetContents($pFilename);
241
242// echo '<pre>';
243// echo htmlentities($gFileData,ENT_QUOTES,'UTF-8');
244// echo '</pre><hr />';
245//
246 $xml = simplexml_load_string($this->securityScan($gFileData), 'SimpleXMLElement', PHPExcel_Settings::getLibXmlLoaderOptions());
247 $namespacesMeta = $xml->getNamespaces(true);
248
249// var_dump($namespacesMeta);
250//
251 $gnmXML = $xml->children($namespacesMeta['gnm']);
252
253 $docProps = $objPHPExcel->getProperties();
254 // Document Properties are held differently, depending on the version of Gnumeric
255 if (isset($namespacesMeta['office'])) {
256 $officeXML = $xml->children($namespacesMeta['office']);
257 $officeDocXML = $officeXML->{'document-meta'};
258 $officeDocMetaXML = $officeDocXML->meta;
259
260 foreach($officeDocMetaXML as $officePropertyData) {
261
262 $officePropertyDC = array();
263 if (isset($namespacesMeta['dc'])) {
264 $officePropertyDC = $officePropertyData->children($namespacesMeta['dc']);
265 }
266 foreach($officePropertyDC as $propertyName => $propertyValue) {
267 $propertyValue = (string) $propertyValue;
268 switch ($propertyName) {
269 case 'title' :
270 $docProps->setTitle(trim($propertyValue));
271 break;
272 case 'subject' :
273 $docProps->setSubject(trim($propertyValue));
274 break;
275 case 'creator' :
276 $docProps->setCreator(trim($propertyValue));
277 $docProps->setLastModifiedBy(trim($propertyValue));
278 break;
279 case 'date' :
280 $creationDate = strtotime(trim($propertyValue));
281 $docProps->setCreated($creationDate);
282 $docProps->setModified($creationDate);
283 break;
284 case 'description' :
285 $docProps->setDescription(trim($propertyValue));
286 break;
287 }
288 }
289 $officePropertyMeta = array();
290 if (isset($namespacesMeta['meta'])) {
291 $officePropertyMeta = $officePropertyData->children($namespacesMeta['meta']);
292 }
293 foreach($officePropertyMeta as $propertyName => $propertyValue) {
294 $attributes = $propertyValue->attributes($namespacesMeta['meta']);
295 $propertyValue = (string) $propertyValue;
296 switch ($propertyName) {
297 case 'keyword' :
298 $docProps->setKeywords(trim($propertyValue));
299 break;
300 case 'initial-creator' :
301 $docProps->setCreator(trim($propertyValue));
302 $docProps->setLastModifiedBy(trim($propertyValue));
303 break;
304 case 'creation-date' :
305 $creationDate = strtotime(trim($propertyValue));
306 $docProps->setCreated($creationDate);
307 $docProps->setModified($creationDate);
308 break;
309 case 'user-defined' :
310 list(,$attrName) = explode(':',$attributes['name']);
311 switch ($attrName) {
312 case 'publisher' :
313 $docProps->setCompany(trim($propertyValue));
314 break;
315 case 'category' :
316 $docProps->setCategory(trim($propertyValue));
317 break;
318 case 'manager' :
319 $docProps->setManager(trim($propertyValue));
320 break;
321 }
322 break;
323 }
324 }
325 }
326 } elseif (isset($gnmXML->Summary)) {
327 foreach($gnmXML->Summary->Item as $summaryItem) {
328 $propertyName = $summaryItem->name;
329 $propertyValue = $summaryItem->{'val-string'};
330 switch ($propertyName) {
331 case 'title' :
332 $docProps->setTitle(trim($propertyValue));
333 break;
334 case 'comments' :
335 $docProps->setDescription(trim($propertyValue));
336 break;
337 case 'keywords' :
338 $docProps->setKeywords(trim($propertyValue));
339 break;
340 case 'category' :
341 $docProps->setCategory(trim($propertyValue));
342 break;
343 case 'manager' :
344 $docProps->setManager(trim($propertyValue));
345 break;
346 case 'author' :
347 $docProps->setCreator(trim($propertyValue));
348 $docProps->setLastModifiedBy(trim($propertyValue));
349 break;
350 case 'company' :
351 $docProps->setCompany(trim($propertyValue));
352 break;
353 }
354 }
355 }
356
357 $worksheetID = 0;
358 foreach($gnmXML->Sheets->Sheet as $sheet) {
359 $worksheetName = (string) $sheet->Name;
360// echo '<b>Worksheet: ',$worksheetName,'</b><br />';
361 if ((isset($this->_loadSheetsOnly)) && (!in_array($worksheetName, $this->_loadSheetsOnly))) {
362 continue;
363 }
364
365 $maxRow = $maxCol = 0;
366
367 // Create new Worksheet
368 $objPHPExcel->createSheet();
369 $objPHPExcel->setActiveSheetIndex($worksheetID);
370 // Use false for $updateFormulaCellReferences to prevent adjustment of worksheet references in formula
371 // cells... during the load, all formulae should be correct, and we're simply bringing the worksheet
372 // name in line with the formula, not the reverse
373 $objPHPExcel->getActiveSheet()->setTitle($worksheetName,false);
374
375 if ((!$this->_readDataOnly) && (isset($sheet->PrintInformation))) {
376 if (isset($sheet->PrintInformation->Margins)) {
377 foreach($sheet->PrintInformation->Margins->children('gnm',TRUE) as $key => $margin) {
378 $marginAttributes = $margin->attributes();
379 $marginSize = 72 / 100; // Default
380 switch($marginAttributes['PrefUnit']) {
381 case 'mm' :
382 $marginSize = intval($marginAttributes['Points']) / 100;
383 break;
384 }
385 switch($key) {
386 case 'top' :
387 $objPHPExcel->getActiveSheet()->getPageMargins()->setTop($marginSize);
388 break;
389 case 'bottom' :
390 $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom($marginSize);
391 break;
392 case 'left' :
393 $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft($marginSize);
394 break;
395 case 'right' :
396 $objPHPExcel->getActiveSheet()->getPageMargins()->setRight($marginSize);
397 break;
398 case 'header' :
399 $objPHPExcel->getActiveSheet()->getPageMargins()->setHeader($marginSize);
400 break;
401 case 'footer' :
402 $objPHPExcel->getActiveSheet()->getPageMargins()->setFooter($marginSize);
403 break;
404 }
405 }
406 }
407 }
408
409 foreach($sheet->Cells->Cell as $cell) {
410 $cellAttributes = $cell->attributes();
411 $row = (int) $cellAttributes->Row + 1;
412 $column = (int) $cellAttributes->Col;
413
414 if ($row > $maxRow) $maxRow = $row;
415 if ($column > $maxCol) $maxCol = $column;
416
417 $column = PHPExcel_Cell::stringFromColumnIndex($column);
418
419 // Read cell?
420 if ($this->getReadFilter() !== NULL) {
421 if (!$this->getReadFilter()->readCell($column, $row, $worksheetName)) {
422 continue;
423 }
424 }
425
426 $ValueType = $cellAttributes->ValueType;
427 $ExprID = (string) $cellAttributes->ExprID;
428// echo 'Cell ',$column,$row,'<br />';
429// echo 'Type is ',$ValueType,'<br />';
430// echo 'Value is ',$cell,'<br />';
431 $type = PHPExcel_Cell_DataType::TYPE_FORMULA;
432 if ($ExprID > '') {
433 if (((string) $cell) > '') {
434
435 $this->_expressions[$ExprID] = array( 'column' => $cellAttributes->Col,
436 'row' => $cellAttributes->Row,
437 'formula' => (string) $cell
438 );
439// echo 'NEW EXPRESSION ',$ExprID,'<br />';
440 } else {
441 $expression = $this->_expressions[$ExprID];
442
443 $cell = $this->_referenceHelper->updateFormulaReferences( $expression['formula'],
444 'A1',
445 $cellAttributes->Col - $expression['column'],
446 $cellAttributes->Row - $expression['row'],
447 $worksheetName
448 );
449// echo 'SHARED EXPRESSION ',$ExprID,'<br />';
450// echo 'New Value is ',$cell,'<br />';
451 }
452 $type = PHPExcel_Cell_DataType::TYPE_FORMULA;
453 } else {
454 switch($ValueType) {
455 case '10' : // NULL
456 $type = PHPExcel_Cell_DataType::TYPE_NULL;
457 break;
458 case '20' : // Boolean
459 $type = PHPExcel_Cell_DataType::TYPE_BOOL;
460 $cell = ($cell == 'TRUE') ? True : False;
461 break;
462 case '30' : // Integer
463 $cell = intval($cell);
464 case '40' : // Float
465 $type = PHPExcel_Cell_DataType::TYPE_NUMERIC;
466 break;
467 case '50' : // Error
468 $type = PHPExcel_Cell_DataType::TYPE_ERROR;
469 break;
470 case '60' : // String
471 $type = PHPExcel_Cell_DataType::TYPE_STRING;
472 break;
473 case '70' : // Cell Range
474 case '80' : // Array
475 }
476 }
477 $objPHPExcel->getActiveSheet()->getCell($column.$row)->setValueExplicit($cell,$type);
478 }
479
480 if ((!$this->_readDataOnly) && (isset($sheet->Objects))) {
481 foreach($sheet->Objects->children('gnm',TRUE) as $key => $comment) {
482 $commentAttributes = $comment->attributes();
483 // Only comment objects are handled at the moment
484 if ($commentAttributes->Text) {
485 $objPHPExcel->getActiveSheet()->getComment( (string)$commentAttributes->ObjectBound )
486 ->setAuthor( (string)$commentAttributes->Author )
487 ->setText($this->_parseRichText((string)$commentAttributes->Text) );
488 }
489 }
490 }
491// echo '$maxCol=',$maxCol,'; $maxRow=',$maxRow,'<br />';
492//
493 foreach($sheet->Styles->StyleRegion as $styleRegion) {
494 $styleAttributes = $styleRegion->attributes();
495 if (($styleAttributes['startRow'] <= $maxRow) &&
496 ($styleAttributes['startCol'] <= $maxCol)) {
497
498 $startColumn = PHPExcel_Cell::stringFromColumnIndex((int) $styleAttributes['startCol']);
499 $startRow = $styleAttributes['startRow'] + 1;
500
501 $endColumn = ($styleAttributes['endCol'] > $maxCol) ? $maxCol : (int) $styleAttributes['endCol'];
502 $endColumn = PHPExcel_Cell::stringFromColumnIndex($endColumn);
503 $endRow = ($styleAttributes['endRow'] > $maxRow) ? $maxRow : $styleAttributes['endRow'];
504 $endRow += 1;
505 $cellRange = $startColumn.$startRow.':'.$endColumn.$endRow;
506// echo $cellRange,'<br />';
507
508 $styleAttributes = $styleRegion->Style->attributes();
509// var_dump($styleAttributes);
510// echo '<br />';
511
512 // We still set the number format mask for date/time values, even if _readDataOnly is true
513 if ((!$this->_readDataOnly) ||
514 (PHPExcel_Shared_Date::isDateTimeFormatCode((string) $styleAttributes['Format']))) {
515 $styleArray = array();
516 $styleArray['numberformat']['code'] = (string) $styleAttributes['Format'];
517 // If _readDataOnly is false, we set all formatting information
518 if (!$this->_readDataOnly) {
519 switch($styleAttributes['HAlign']) {
520 case '1' :
521 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_GENERAL;
522 break;
523 case '2' :
524 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_LEFT;
525 break;
526 case '4' :
527 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_RIGHT;
528 break;
529 case '8' :
530 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_CENTER;
531 break;
532 case '16' :
533 case '64' :
534 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS;
535 break;
536 case '32' :
537 $styleArray['alignment']['horizontal'] = PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY;
538 break;
539 }
540
541 switch($styleAttributes['VAlign']) {
542 case '1' :
543 $styleArray['alignment']['vertical'] = PHPExcel_Style_Alignment::VERTICAL_TOP;
544 break;
545 case '2' :
546 $styleArray['alignment']['vertical'] = PHPExcel_Style_Alignment::VERTICAL_BOTTOM;
547 break;
548 case '4' :
549 $styleArray['alignment']['vertical'] = PHPExcel_Style_Alignment::VERTICAL_CENTER;
550 break;
551 case '8' :
552 $styleArray['alignment']['vertical'] = PHPExcel_Style_Alignment::VERTICAL_JUSTIFY;
553 break;
554 }
555
556 $styleArray['alignment']['wrap'] = ($styleAttributes['WrapText'] == '1') ? True : False;
557 $styleArray['alignment']['shrinkToFit'] = ($styleAttributes['ShrinkToFit'] == '1') ? True : False;
558 $styleArray['alignment']['indent'] = (intval($styleAttributes["Indent"]) > 0) ? $styleAttributes["indent"] : 0;
559
560 $RGB = self::_parseGnumericColour($styleAttributes["Fore"]);
561 $styleArray['font']['color']['rgb'] = $RGB;
562 $RGB = self::_parseGnumericColour($styleAttributes["Back"]);
563 $shade = $styleAttributes["Shade"];
564 if (($RGB != '000000') || ($shade != '0')) {
565 $styleArray['fill']['color']['rgb'] = $styleArray['fill']['startcolor']['rgb'] = $RGB;
566 $RGB2 = self::_parseGnumericColour($styleAttributes["PatternColor"]);
567 $styleArray['fill']['endcolor']['rgb'] = $RGB2;
568 switch($shade) {
569 case '1' :
570 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_SOLID;
571 break;
572 case '2' :
573 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR;
574 break;
575 case '3' :
576 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_GRADIENT_PATH;
577 break;
578 case '4' :
579 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN;
580 break;
581 case '5' :
582 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY;
583 break;
584 case '6' :
585 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID;
586 break;
587 case '7' :
588 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL;
589 break;
590 case '8' :
591 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS;
592 break;
593 case '9' :
594 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKUP;
595 break;
596 case '10' :
597 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL;
598 break;
599 case '11' :
600 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625;
601 break;
602 case '12' :
603 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_GRAY125;
604 break;
605 case '13' :
606 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN;
607 break;
608 case '14' :
609 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY;
610 break;
611 case '15' :
612 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID;
613 break;
614 case '16' :
615 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL;
616 break;
617 case '17' :
618 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS;
619 break;
620 case '18' :
621 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP;
622 break;
623 case '19' :
624 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL;
625 break;
626 case '20' :
627 $styleArray['fill']['type'] = PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY;
628 break;
629 }
630 }
631
632 $fontAttributes = $styleRegion->Style->Font->attributes();
633// var_dump($fontAttributes);
634// echo '<br />';
635 $styleArray['font']['name'] = (string) $styleRegion->Style->Font;
636 $styleArray['font']['size'] = intval($fontAttributes['Unit']);
637 $styleArray['font']['bold'] = ($fontAttributes['Bold'] == '1') ? True : False;
638 $styleArray['font']['italic'] = ($fontAttributes['Italic'] == '1') ? True : False;
639 $styleArray['font']['strike'] = ($fontAttributes['StrikeThrough'] == '1') ? True : False;
640 switch($fontAttributes['Underline']) {
641 case '1' :
642 $styleArray['font']['underline'] = PHPExcel_Style_Font::UNDERLINE_SINGLE;
643 break;
644 case '2' :
645 $styleArray['font']['underline'] = PHPExcel_Style_Font::UNDERLINE_DOUBLE;
646 break;
647 case '3' :
648 $styleArray['font']['underline'] = PHPExcel_Style_Font::UNDERLINE_SINGLEACCOUNTING;
649 break;
650 case '4' :
651 $styleArray['font']['underline'] = PHPExcel_Style_Font::UNDERLINE_DOUBLEACCOUNTING;
652 break;
653 default :
654 $styleArray['font']['underline'] = PHPExcel_Style_Font::UNDERLINE_NONE;
655 break;
656 }
657 switch($fontAttributes['Script']) {
658 case '1' :
659 $styleArray['font']['superScript'] = True;
660 break;
661 case '-1' :
662 $styleArray['font']['subScript'] = True;
663 break;
664 }
665
666 if (isset($styleRegion->Style->StyleBorder)) {
667 if (isset($styleRegion->Style->StyleBorder->Top)) {
668 $styleArray['borders']['top'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Top->attributes());
669 }
670 if (isset($styleRegion->Style->StyleBorder->Bottom)) {
671 $styleArray['borders']['bottom'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Bottom->attributes());
672 }
673 if (isset($styleRegion->Style->StyleBorder->Left)) {
674 $styleArray['borders']['left'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Left->attributes());
675 }
676 if (isset($styleRegion->Style->StyleBorder->Right)) {
677 $styleArray['borders']['right'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Right->attributes());
678 }
679 if ((isset($styleRegion->Style->StyleBorder->Diagonal)) && (isset($styleRegion->Style->StyleBorder->{'Rev-Diagonal'}))) {
680 $styleArray['borders']['diagonal'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Diagonal->attributes());
681 $styleArray['borders']['diagonaldirection'] = PHPExcel_Style_Borders::DIAGONAL_BOTH;
682 } elseif (isset($styleRegion->Style->StyleBorder->Diagonal)) {
683 $styleArray['borders']['diagonal'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->Diagonal->attributes());
684 $styleArray['borders']['diagonaldirection'] = PHPExcel_Style_Borders::DIAGONAL_UP;
685 } elseif (isset($styleRegion->Style->StyleBorder->{'Rev-Diagonal'})) {
686 $styleArray['borders']['diagonal'] = self::_parseBorderAttributes($styleRegion->Style->StyleBorder->{'Rev-Diagonal'}->attributes());
687 $styleArray['borders']['diagonaldirection'] = PHPExcel_Style_Borders::DIAGONAL_DOWN;
688 }
689 }
690 if (isset($styleRegion->Style->HyperLink)) {
691 // TO DO
692 $hyperlink = $styleRegion->Style->HyperLink->attributes();
693 }
694 }
695// var_dump($styleArray);
696// echo '<br />';
697 $objPHPExcel->getActiveSheet()->getStyle($cellRange)->applyFromArray($styleArray);
698 }
699 }
700 }
701
702 if ((!$this->_readDataOnly) && (isset($sheet->Cols))) {
703 // Column Widths
704 $columnAttributes = $sheet->Cols->attributes();
705 $defaultWidth = $columnAttributes['DefaultSizePts'] / 5.4;
706 $c = 0;
707 foreach($sheet->Cols->ColInfo as $columnOverride) {
708 $columnAttributes = $columnOverride->attributes();
709 $column = $columnAttributes['No'];
710 $columnWidth = $columnAttributes['Unit'] / 5.4;
711 $hidden = ((isset($columnAttributes['Hidden'])) && ($columnAttributes['Hidden'] == '1')) ? true : false;
712 $columnCount = (isset($columnAttributes['Count'])) ? $columnAttributes['Count'] : 1;
713 while ($c < $column) {
714 $objPHPExcel->getActiveSheet()->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($c))->setWidth($defaultWidth);
715 ++$c;
716 }
717 while (($c < ($column+$columnCount)) && ($c <= $maxCol)) {
718 $objPHPExcel->getActiveSheet()->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($c))->setWidth($columnWidth);
719 if ($hidden) {
720 $objPHPExcel->getActiveSheet()->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($c))->setVisible(false);
721 }
722 ++$c;
723 }
724 }
725 while ($c <= $maxCol) {
726 $objPHPExcel->getActiveSheet()->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($c))->setWidth($defaultWidth);
727 ++$c;
728 }
729 }
730
731 if ((!$this->_readDataOnly) && (isset($sheet->Rows))) {
732 // Row Heights
733 $rowAttributes = $sheet->Rows->attributes();
734 $defaultHeight = $rowAttributes['DefaultSizePts'];
735 $r = 0;
736
737 foreach($sheet->Rows->RowInfo as $rowOverride) {
738 $rowAttributes = $rowOverride->attributes();
739 $row = $rowAttributes['No'];
740 $rowHeight = $rowAttributes['Unit'];
741 $hidden = ((isset($rowAttributes['Hidden'])) && ($rowAttributes['Hidden'] == '1')) ? true : false;
742 $rowCount = (isset($rowAttributes['Count'])) ? $rowAttributes['Count'] : 1;
743 while ($r < $row) {
744 ++$r;
745 $objPHPExcel->getActiveSheet()->getRowDimension($r)->setRowHeight($defaultHeight);
746 }
747 while (($r < ($row+$rowCount)) && ($r < $maxRow)) {
748 ++$r;
749 $objPHPExcel->getActiveSheet()->getRowDimension($r)->setRowHeight($rowHeight);
750 if ($hidden) {
751 $objPHPExcel->getActiveSheet()->getRowDimension($r)->setVisible(false);
752 }
753 }
754 }
755 while ($r < $maxRow) {
756 ++$r;
757 $objPHPExcel->getActiveSheet()->getRowDimension($r)->setRowHeight($defaultHeight);
758 }
759 }
760
761 // Handle Merged Cells in this worksheet
762 if (isset($sheet->MergedRegions)) {
763 foreach($sheet->MergedRegions->Merge as $mergeCells) {
764 if (strpos($mergeCells,':') !== FALSE) {
765 $objPHPExcel->getActiveSheet()->mergeCells($mergeCells);
766 }
767 }
768 }
769
770 $worksheetID++;
771 }
772
773 // Loop through definedNames (global named ranges)
774 if (isset($gnmXML->Names)) {
775 foreach($gnmXML->Names->Name as $namedRange) {
776 $name = (string) $namedRange->name;
777 $range = (string) $namedRange->value;
778 if (stripos($range, '#REF!') !== false) {
779 continue;
780 }
781
782 $range = explode('!',$range);
783 $range[0] = trim($range[0],"'");;
784 if ($worksheet = $objPHPExcel->getSheetByName($range[0])) {
785 $extractedRange = str_replace('$', '', $range[1]);
786 $objPHPExcel->addNamedRange( new PHPExcel_NamedRange($name, $worksheet, $extractedRange) );
787 }
788 }
789 }
790
791
792 // Return
793 return $objPHPExcel;
794 }
$column
$column
Definition: 39dropdown.php:62
$worksheet
$worksheet
Definition: 40duplicateStyle.php:17
$comment
$comment
Definition: buildRTE.php:83
if
PHPExcel root directory.
Definition: PHPExcel.php:30
PHPExcel_Cell_DataType\TYPE_ERROR
const TYPE_ERROR
Definition: DataType.php:46
PHPExcel_Cell_DataType\TYPE_FORMULA
const TYPE_FORMULA
Definition: DataType.php:41
PHPExcel_Cell_DataType\TYPE_NULL
const TYPE_NULL
Definition: DataType.php:44
PHPExcel_Cell_DataType\TYPE_NUMERIC
const TYPE_NUMERIC
Definition: DataType.php:42
PHPExcel_Cell_DataType\TYPE_BOOL
const TYPE_BOOL
Definition: DataType.php:43
PHPExcel_Cell_DataType\TYPE_STRING
const TYPE_STRING
Definition: DataType.php:40
PHPExcel_NamedRange
Definition: NamedRange.php:37
PHPExcel_Reader_Abstract\securityScan
securityScan($xml)
Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks.
Definition: Abstract.php:236
PHPExcel_Reader_Abstract\getReadFilter
getReadFilter()
Read filter.
Definition: Abstract.php:173
PHPExcel_Reader_Gnumeric\_gzfileGetContents
_gzfileGetContents($filename)
Definition: Gnumeric.php:192
PHPExcel_Reader_Gnumeric\_parseRichText
_parseRichText($is='')
Definition: Gnumeric.php:854
PHPExcel_Reader_Gnumeric\_parseBorderAttributes
static _parseBorderAttributes($borderAttributes)
Definition: Gnumeric.php:797
PHPExcel_Shared_Date\isDateTimeFormatCode
static isDateTimeFormatCode($pFormatCode='')
Is a given number format code a date/time?
Definition: Date.php:282
PHPExcel_Style_Alignment\VERTICAL_CENTER
const VERTICAL_CENTER
Definition: Alignment.php:51
PHPExcel_Style_Alignment\VERTICAL_JUSTIFY
const VERTICAL_JUSTIFY
Definition: Alignment.php:52
PHPExcel_Style_Alignment\VERTICAL_TOP
const VERTICAL_TOP
Definition: Alignment.php:50
PHPExcel_Style_Alignment\HORIZONTAL_GENERAL
const HORIZONTAL_GENERAL
Definition: Alignment.php:39
PHPExcel_Style_Alignment\HORIZONTAL_RIGHT
const HORIZONTAL_RIGHT
Definition: Alignment.php:41
PHPExcel_Style_Alignment\VERTICAL_BOTTOM
const VERTICAL_BOTTOM
Definition: Alignment.php:49
PHPExcel_Style_Alignment\HORIZONTAL_CENTER
const HORIZONTAL_CENTER
Definition: Alignment.php:42
PHPExcel_Style_Alignment\HORIZONTAL_CENTER_CONTINUOUS
const HORIZONTAL_CENTER_CONTINUOUS
Definition: Alignment.php:43
PHPExcel_Style_Alignment\HORIZONTAL_JUSTIFY
const HORIZONTAL_JUSTIFY
Definition: Alignment.php:44
PHPExcel_Style_Alignment\HORIZONTAL_LEFT
const HORIZONTAL_LEFT
Definition: Alignment.php:40
PHPExcel_Style_Borders\DIAGONAL_DOWN
const DIAGONAL_DOWN
Definition: Borders.php:41
PHPExcel_Style_Borders\DIAGONAL_BOTH
const DIAGONAL_BOTH
Definition: Borders.php:42
PHPExcel_Style_Borders\DIAGONAL_UP
const DIAGONAL_UP
Definition: Borders.php:40
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTUP
const FILL_PATTERN_LIGHTUP
Definition: Fill.php:57
PHPExcel_Style_Fill\FILL_SOLID
const FILL_SOLID
Definition: Fill.php:40
PHPExcel_Style_Fill\FILL_PATTERN_DARKDOWN
const FILL_PATTERN_DARKDOWN
Definition: Fill.php:43
PHPExcel_Style_Fill\FILL_PATTERN_DARKUP
const FILL_PATTERN_DARKUP
Definition: Fill.php:48
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTVERTICAL
const FILL_PATTERN_LIGHTVERTICAL
Definition: Fill.php:58
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRAY
const FILL_PATTERN_LIGHTGRAY
Definition: Fill.php:53
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTDOWN
const FILL_PATTERN_LIGHTDOWN
Definition: Fill.php:52
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRAY
const FILL_PATTERN_DARKGRAY
Definition: Fill.php:44
PHPExcel_Style_Fill\FILL_PATTERN_GRAY125
const FILL_PATTERN_GRAY125
Definition: Fill.php:51
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTHORIZONTAL
const FILL_PATTERN_LIGHTHORIZONTAL
Definition: Fill.php:55
PHPExcel_Style_Fill\FILL_PATTERN_DARKTRELLIS
const FILL_PATTERN_DARKTRELLIS
Definition: Fill.php:47
PHPExcel_Style_Fill\FILL_PATTERN_GRAY0625
const FILL_PATTERN_GRAY0625
Definition: Fill.php:50
PHPExcel_Style_Fill\FILL_PATTERN_MEDIUMGRAY
const FILL_PATTERN_MEDIUMGRAY
Definition: Fill.php:59
PHPExcel_Style_Fill\FILL_GRADIENT_PATH
const FILL_GRADIENT_PATH
Definition: Fill.php:42
PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR
const FILL_GRADIENT_LINEAR
Definition: Fill.php:41
PHPExcel_Style_Fill\FILL_PATTERN_DARKVERTICAL
const FILL_PATTERN_DARKVERTICAL
Definition: Fill.php:49
PHPExcel_Style_Fill\FILL_PATTERN_DARKHORIZONTAL
const FILL_PATTERN_DARKHORIZONTAL
Definition: Fill.php:46
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRID
const FILL_PATTERN_LIGHTGRID
Definition: Fill.php:54
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTTRELLIS
const FILL_PATTERN_LIGHTTRELLIS
Definition: Fill.php:56
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRID
const FILL_PATTERN_DARKGRID
Definition: Fill.php:45
PHPExcel_Style_Font\UNDERLINE_DOUBLE
const UNDERLINE_DOUBLE
Definition: Font.php:40
PHPExcel_Style_Font\UNDERLINE_SINGLEACCOUNTING
const UNDERLINE_SINGLEACCOUNTING
Definition: Font.php:43
PHPExcel_Style_Font\UNDERLINE_DOUBLEACCOUNTING
const UNDERLINE_DOUBLEACCOUNTING
Definition: Font.php:41
PHPExcel_Style_Font\UNDERLINE_SINGLE
const UNDERLINE_SINGLE
Definition: Font.php:42
PHPExcel_Style_Font\UNDERLINE_NONE
const UNDERLINE_NONE
Definition: Font.php:39
$r
$r
Definition: example_031.php:79

References $objPHPExcel, _gzfileGetContents(), PHPExcel_Settings\getLibXmlLoaderOptions(), and PHPExcel_Reader_Abstract\securityScan().

Referenced by load().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

Field Documentation

◆ $_expressions

PHPExcel_Reader_Gnumeric::$_expressions = array()
private

Definition at line 59 of file Gnumeric.php.

◆ $_referenceHelper

PHPExcel_Reader_Gnumeric::$_referenceHelper = null
private

Definition at line 61 of file Gnumeric.php.

◆ $_styles

PHPExcel_Reader_Gnumeric::$_styles = array()
private

Definition at line 52 of file Gnumeric.php.

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