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...
 

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.

References PHPExcel_ReferenceHelper\getInstance().

67  {
68  $this->_readFilter = new PHPExcel_Reader_DefaultReadFilter();
69  $this->_referenceHelper = PHPExcel_ReferenceHelper::getInstance();
70  }
PHPExcel_ReferenceHelper\getInstance
static getInstance()
Get an instance of this class.
Definition: ReferenceHelper.php:57
PHPExcel_Reader_DefaultReadFilter
Definition: DefaultReadFilter.php:45
+ 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.

References $data, $file, and $filename.

Referenced by loadIntoExisting().

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
+ Here is the caller graph for this function:

◆ _parseBorderAttributes()

static PHPExcel_Reader_Gnumeric::_parseBorderAttributes (   $borderAttributes)
staticprivate

Definition at line 797 of file Gnumeric.php.

References array, 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.

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_Style_Border\BORDER_THIN
const BORDER_THIN
Definition: Border.php:52
PHPExcel_Style_Border\BORDER_DOUBLE
const BORDER_DOUBLE
Definition: Border.php:44
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOT
const BORDER_MEDIUMDASHDOT
Definition: Border.php:47
PHPExcel_Style_Border\BORDER_THICK
const BORDER_THICK
Definition: Border.php:51
PHPExcel_Style_Border\BORDER_DASHDOTDOT
const BORDER_DASHDOTDOT
Definition: Border.php:41
PHPExcel_Style_Border\BORDER_DASHED
const BORDER_DASHED
Definition: Border.php:42
PHPExcel_Style_Border\BORDER_DOTTED
const BORDER_DOTTED
Definition: Border.php:43
PHPExcel_Style_Border\BORDER_DASHDOT
const BORDER_DASHDOT
Definition: Border.php:40
PHPExcel_Style_Border\BORDER_MEDIUM
const BORDER_MEDIUM
Definition: Border.php:46
PHPExcel_Style_Border\BORDER_NONE
const BORDER_NONE
Definition: Border.php:39
PHPExcel_Style_Border\BORDER_MEDIUMDASHDOTDOT
const BORDER_MEDIUMDASHDOTDOT
Definition: Border.php:48
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
PHPExcel_Style_Border\BORDER_SLANTDASHDOT
const BORDER_SLANTDASHDOT
Definition: Border.php:50
PHPExcel_Style_Border\BORDER_MEDIUMDASHED
const BORDER_MEDIUMDASHED
Definition: Border.php:49

◆ _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.

Referenced by loadIntoExisting().

854  {
855  $value = new PHPExcel_RichText();
856 
857  $value->createText($is);
858 
859  return $value;
860  }
PHPExcel_RichText
+ Here is the caller graph for this function:

◆ canRead()

PHPExcel_Reader_Gnumeric::canRead (   $pFilename)

Can the current PHPExcel_Reader_IReader read the file?

Parameters
string$pFilename
Returns
boolean
Exceptions
PHPExcel_Reader_Exception

Implements PHPExcel_Reader_IReader.

Definition at line 80 of file Gnumeric.php.

References $data, and $fh.

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

◆ 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.

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

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  }
string
Add rich text string
The name of the decorator.
Definition: 05featuredemo.inc.php:117
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
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
PHPExcel_Reader_Exception
Definition: Exception.php:36
PHPExcel_Cell\stringFromColumnIndex
static stringFromColumnIndex($pColumnIndex=0)
String from columnindex.
Definition: Cell.php:825
+ 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.

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

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  }
string
Add rich text string
The name of the decorator.
Definition: 05featuredemo.inc.php:117
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
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
PHPExcel_Reader_Exception
Definition: Exception.php:36
+ 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.

References $objPHPExcel, and loadIntoExisting().

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

References $column, $comment, $objPHPExcel, $r, $row, $worksheet, _gzfileGetContents(), _parseRichText(), array, PHPExcel_Style_Borders\DIAGONAL_BOTH, PHPExcel_Style_Borders\DIAGONAL_DOWN, PHPExcel_Style_Borders\DIAGONAL_UP, PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR, PHPExcel_Style_Fill\FILL_GRADIENT_PATH, PHPExcel_Style_Fill\FILL_PATTERN_DARKDOWN, PHPExcel_Style_Fill\FILL_PATTERN_DARKGRAY, PHPExcel_Style_Fill\FILL_PATTERN_DARKGRID, PHPExcel_Style_Fill\FILL_PATTERN_DARKHORIZONTAL, PHPExcel_Style_Fill\FILL_PATTERN_DARKTRELLIS, PHPExcel_Style_Fill\FILL_PATTERN_DARKUP, PHPExcel_Style_Fill\FILL_PATTERN_DARKVERTICAL, PHPExcel_Style_Fill\FILL_PATTERN_GRAY0625, PHPExcel_Style_Fill\FILL_PATTERN_GRAY125, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTDOWN, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRAY, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRID, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTHORIZONTAL, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTTRELLIS, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTUP, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTVERTICAL, PHPExcel_Style_Fill\FILL_PATTERN_MEDIUMGRAY, PHPExcel_Style_Fill\FILL_SOLID, PHPExcel_Settings\getLibXmlLoaderOptions(), PHPExcel\getProperties(), PHPExcel_Reader_Abstract\getReadFilter(), PHPExcel_Style_Alignment\HORIZONTAL_CENTER, PHPExcel_Style_Alignment\HORIZONTAL_CENTER_CONTINUOUS, PHPExcel_Style_Alignment\HORIZONTAL_GENERAL, PHPExcel_Style_Alignment\HORIZONTAL_JUSTIFY, PHPExcel_Style_Alignment\HORIZONTAL_LEFT, PHPExcel_Style_Alignment\HORIZONTAL_RIGHT, PHPExcel_Shared_Date\isDateTimeFormatCode(), PHPExcel_Reader_Abstract\securityScan(), string, PHPExcel_Cell\stringFromColumnIndex(), PHPExcel_Cell_DataType\TYPE_BOOL, PHPExcel_Cell_DataType\TYPE_ERROR, PHPExcel_Cell_DataType\TYPE_FORMULA, PHPExcel_Cell_DataType\TYPE_NULL, PHPExcel_Cell_DataType\TYPE_NUMERIC, PHPExcel_Cell_DataType\TYPE_STRING, PHPExcel_Style_Font\UNDERLINE_DOUBLE, PHPExcel_Style_Font\UNDERLINE_DOUBLEACCOUNTING, PHPExcel_Style_Font\UNDERLINE_NONE, PHPExcel_Style_Font\UNDERLINE_SINGLE, PHPExcel_Style_Font\UNDERLINE_SINGLEACCOUNTING, PHPExcel_Style_Alignment\VERTICAL_BOTTOM, PHPExcel_Style_Alignment\VERTICAL_CENTER, PHPExcel_Style_Alignment\VERTICAL_JUSTIFY, and PHPExcel_Style_Alignment\VERTICAL_TOP.

Referenced by load().

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  }
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTHORIZONTAL
const FILL_PATTERN_LIGHTHORIZONTAL
Definition: Fill.php:55
$worksheet
$worksheet
Definition: 40duplicateStyle.php:17
PHPExcel_Style_Fill\FILL_GRADIENT_PATH
const FILL_GRADIENT_PATH
Definition: Fill.php:42
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRAY
const FILL_PATTERN_LIGHTGRAY
Definition: Fill.php:53
PHPExcel_Cell_DataType\TYPE_BOOL
const TYPE_BOOL
Definition: DataType.php:43
PHPExcel_NamedRange
Definition: NamedRange.php:36
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRID
const FILL_PATTERN_DARKGRID
Definition: Fill.php:45
PHPExcel_Style_Fill\FILL_PATTERN_DARKHORIZONTAL
const FILL_PATTERN_DARKHORIZONTAL
Definition: Fill.php:46
PHPExcel_Style_Borders\DIAGONAL_DOWN
const DIAGONAL_DOWN
Definition: Borders.php:41
PHPExcel\getSheetByName
getSheetByName($pName='')
Get sheet by name.
Definition: PHPExcel.php:601
PHPExcel_Style_Alignment\HORIZONTAL_LEFT
const HORIZONTAL_LEFT
Definition: Alignment.php:40
$objPHPExcel
$objPHPExcel
Definition: 01pharSimple.php:42
PHPExcel\getProperties
getProperties()
Get properties.
Definition: PHPExcel.php:425
PHPExcel_Style_Alignment\VERTICAL_TOP
const VERTICAL_TOP
Definition: Alignment.php:50
PHPExcel_Style_Alignment\HORIZONTAL_GENERAL
const HORIZONTAL_GENERAL
Definition: Alignment.php:39
string
Add rich text string
The name of the decorator.
Definition: 05featuredemo.inc.php:117
PHPExcel_Style_Font\UNDERLINE_NONE
const UNDERLINE_NONE
Definition: Font.php:39
PHPExcel_Cell_DataType\TYPE_ERROR
const TYPE_ERROR
Definition: DataType.php:46
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTTRELLIS
const FILL_PATTERN_LIGHTTRELLIS
Definition: Fill.php:56
PHPExcel\createSheet
createSheet($iSheetIndex=NULL)
Create sheet and add it to this workbook.
Definition: PHPExcel.php:479
PHPExcel_Style_Font\UNDERLINE_SINGLE
const UNDERLINE_SINGLE
Definition: Font.php:42
PHPExcel_Reader_Abstract\securityScan
securityScan($xml)
Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks.
Definition: Abstract.php:236
$r
$r
Definition: example_031.php:79
$column
$column
Definition: 39dropdown.php:62
PHPExcel_Style_Borders\DIAGONAL_UP
const DIAGONAL_UP
Definition: Borders.php:40
PHPExcel_Style_Alignment\VERTICAL_JUSTIFY
const VERTICAL_JUSTIFY
Definition: Alignment.php:52
PHPExcel_Style_Font\UNDERLINE_DOUBLE
const UNDERLINE_DOUBLE
Definition: Font.php:40
PHPExcel_Style_Font\UNDERLINE_DOUBLEACCOUNTING
const UNDERLINE_DOUBLEACCOUNTING
Definition: Font.php:41
PHPExcel_Style_Alignment\HORIZONTAL_CENTER_CONTINUOUS
const HORIZONTAL_CENTER_CONTINUOUS
Definition: Alignment.php:43
PHPExcel_Cell_DataType\TYPE_NULL
const TYPE_NULL
Definition: DataType.php:44
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTDOWN
const FILL_PATTERN_LIGHTDOWN
Definition: Fill.php:52
PHPExcel_Style_Fill\FILL_PATTERN_MEDIUMGRAY
const FILL_PATTERN_MEDIUMGRAY
Definition: Fill.php:59
PHPExcel_Style_Alignment\HORIZONTAL_JUSTIFY
const HORIZONTAL_JUSTIFY
Definition: Alignment.php:44
PHPExcel_Style_Fill\FILL_PATTERN_DARKDOWN
const FILL_PATTERN_DARKDOWN
Definition: Fill.php:43
PHPExcel_Cell_DataType\TYPE_STRING
const TYPE_STRING
Definition: DataType.php:40
PHPExcel_Reader_Gnumeric\_parseRichText
_parseRichText($is='')
Definition: Gnumeric.php:854
PHPExcel_Style_Fill\FILL_PATTERN_GRAY125
const FILL_PATTERN_GRAY125
Definition: Fill.php:51
PHPExcel_Style_Fill\FILL_PATTERN_DARKTRELLIS
const FILL_PATTERN_DARKTRELLIS
Definition: Fill.php:47
PHPExcel_Settings\getLibXmlLoaderOptions
static getLibXmlLoaderOptions()
Get default options for libxml loader.
Definition: Settings.php:381
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTVERTICAL
const FILL_PATTERN_LIGHTVERTICAL
Definition: Fill.php:58
PHPExcel_Style_Font\UNDERLINE_SINGLEACCOUNTING
const UNDERLINE_SINGLEACCOUNTING
Definition: Font.php:43
PHPExcel_Style_Borders\DIAGONAL_BOTH
const DIAGONAL_BOTH
Definition: Borders.php:42
$comment
$comment
Definition: buildRTE.php:83
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
PHPExcel_Style_Fill\FILL_PATTERN_GRAY0625
const FILL_PATTERN_GRAY0625
Definition: Fill.php:50
PHPExcel\getActiveSheet
getActiveSheet()
Get active sheet.
Definition: PHPExcel.php:467
PHPExcel_Reader_Abstract\getReadFilter
getReadFilter()
Read filter.
Definition: Abstract.php:173
PHPExcel_Reader_Gnumeric\_gzfileGetContents
_gzfileGetContents($filename)
Definition: Gnumeric.php:192
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRID
const FILL_PATTERN_LIGHTGRID
Definition: Fill.php:54
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_Fill\FILL_PATTERN_DARKVERTICAL
const FILL_PATTERN_DARKVERTICAL
Definition: Fill.php:49
PHPExcel_Reader_Exception
Definition: Exception.php:36
PHPExcel_Cell\stringFromColumnIndex
static stringFromColumnIndex($pColumnIndex=0)
String from columnindex.
Definition: Cell.php:825
PHPExcel\setActiveSheetIndex
setActiveSheetIndex($pIndex=0)
Set active sheet index.
Definition: PHPExcel.php:683
PHPExcel_Style_Fill\FILL_SOLID
const FILL_SOLID
Definition: Fill.php:40
PHPExcel_Style_Fill\FILL_PATTERN_DARKGRAY
const FILL_PATTERN_DARKGRAY
Definition: Fill.php:44
PHPExcel_Style_Alignment\VERTICAL_BOTTOM
const VERTICAL_BOTTOM
Definition: Alignment.php:49
PHPExcel\addNamedRange
addNamedRange(PHPExcel_NamedRange $namedRange)
Add named range.
Definition: PHPExcel.php:778
PHPExcel_Style_Fill\FILL_PATTERN_LIGHTUP
const FILL_PATTERN_LIGHTUP
Definition: Fill.php:57
PHPExcel_Style_Alignment\HORIZONTAL_RIGHT
const HORIZONTAL_RIGHT
Definition: Alignment.php:41
PHPExcel_Cell_DataType\TYPE_NUMERIC
const TYPE_NUMERIC
Definition: DataType.php:42
PHPExcel_Style_Fill\FILL_PATTERN_DARKUP
const FILL_PATTERN_DARKUP
Definition: Fill.php:48
PHPExcel_Cell_DataType\TYPE_FORMULA
const TYPE_FORMULA
Definition: DataType.php:41
PHPExcel_Style_Alignment\HORIZONTAL_CENTER
const HORIZONTAL_CENTER
Definition: Alignment.php:42
PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR
const FILL_GRADIENT_LINEAR
Definition: Fill.php:41
if
PHPExcel root directory.
Definition: Database.php:30
+ 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: