ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions | Protected Member Functions | Static Protected Member Functions | Protected Attributes
PHPExcel_Reader_Excel2003XML Class Reference
+ Inheritance diagram for PHPExcel_Reader_Excel2003XML:
+ Collaboration diagram for PHPExcel_Reader_Excel2003XML:

Public Member Functions

 __construct ()
 Create a new PHPExcel_Reader_Excel2003XML. 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)
 

Protected Member Functions

 _parseRichText ($is='')
 
- Protected Member Functions inherited from PHPExcel_Reader_Abstract
 _openFile ($pFilename)
 Open file for reading. More...
 

Static Protected Member Functions

static identifyFixedStyleValue ($styleList, &$styleAttributeValue)
 
static _pixel2WidthUnits ($pxs)
 pixel units to excel width units(units of 1/256th of a character width) More...
 
static _widthUnits2Pixel ($widthUnits)
 excel width units(units of 1/256th of a character width) to pixel units More...
 
static _hex2str ($hex)
 
static _convertStringEncoding ($string, $charset)
 

Protected Attributes

 $_styles = array()
 
 $_charSet = 'UTF-8'
 
- 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 Excel2003XML.php.

Constructor & Destructor Documentation

◆ __construct()

PHPExcel_Reader_Excel2003XML::__construct ( )

Create a new PHPExcel_Reader_Excel2003XML.

Definition at line 65 of file Excel2003XML.php.

65 {
66 $this->_readFilter = new PHPExcel_Reader_DefaultReadFilter();
67 }
PHPExcel_Reader_DefaultReadFilter
Definition: DefaultReadFilter.php:46

Member Function Documentation

◆ _convertStringEncoding()

static PHPExcel_Reader_Excel2003XML::_convertStringEncoding (   $string,
  $charset 
)
staticprotected

Definition at line 793 of file Excel2003XML.php.

793 {
794 if ($charset != 'UTF-8') {
795 return PHPExcel_Shared_String::ConvertEncoding($string,'UTF-8',$charset);
796 }
797 return $string;
798 }
PHPExcel_Shared_String\ConvertEncoding
static ConvertEncoding($value, $to, $from)
Convert string from one encoding to another.
Definition: String.php:493

References PHPExcel_Shared_String\ConvertEncoding().

Referenced by listWorksheetNames(), and loadIntoExisting().

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

◆ _hex2str()

static PHPExcel_Reader_Excel2003XML::_hex2str (   $hex)
staticprotected

Definition at line 281 of file Excel2003XML.php.

281 {
282 return chr(hexdec($hex[1]));
283 }

◆ _parseRichText()

PHPExcel_Reader_Excel2003XML::_parseRichText (   $is = '')
protected

Definition at line 801 of file Excel2003XML.php.

801 {
802 $value = new PHPExcel_RichText();
803
804 $value->createText(self::_convertStringEncoding($is,$this->_charSet));
805
806 return $value;
807 }
PHPExcel_RichText

Referenced by loadIntoExisting().

+ Here is the caller graph for this function:

◆ _pixel2WidthUnits()

static PHPExcel_Reader_Excel2003XML::_pixel2WidthUnits (   $pxs)
staticprotected

pixel units to excel width units(units of 1/256th of a character width)

Parameters
pxs
Returns

Definition at line 259 of file Excel2003XML.php.

259 {
260 $UNIT_OFFSET_MAP = array(0, 36, 73, 109, 146, 182, 219);
261
262 $widthUnits = 256 * ($pxs / 7);
263 $widthUnits += $UNIT_OFFSET_MAP[($pxs % 7)];
264 return $widthUnits;
265 }

◆ _widthUnits2Pixel()

static PHPExcel_Reader_Excel2003XML::_widthUnits2Pixel (   $widthUnits)
staticprotected

excel width units(units of 1/256th of a character width) to pixel units

Parameters
widthUnits
Returns

Definition at line 273 of file Excel2003XML.php.

273 {
274 $pixels = ($widthUnits / 256) * 7;
275 $offsetWidthUnits = $widthUnits % 256;
276 $pixels += round($offsetWidthUnits / (256 / 7));
277 return $pixels;
278 }

◆ canRead()

PHPExcel_Reader_Excel2003XML::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 77 of file Excel2003XML.php.

78 {
79
80 // Office xmlns:o="urn:schemas-microsoft-com:office:office"
81 // Excel xmlns:x="urn:schemas-microsoft-com:office:excel"
82 // XML Spreadsheet xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
83 // Spreadsheet component xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"
84 // XML schema xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
85 // XML data type xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
86 // MS-persist recordset xmlns:rs="urn:schemas-microsoft-com:rowset"
87 // Rowset xmlns:z="#RowsetSchema"
88 //
89
90 $signature = array(
91 '<?xml version="1.0"',
92 '<?mso-application progid="Excel.Sheet"?>'
93 );
94
95 // Open file
96 $this->_openFile($pFilename);
97 $fileHandle = $this->_fileHandle;
98
99 // Read sample data (first 2 KB will do)
100 $data = fread($fileHandle, 2048);
101 fclose($fileHandle);
102
103 $valid = true;
104 foreach($signature as $match) {
105 // every part of the signature must be present
106 if (strpos($data, $match) === false) {
107 $valid = false;
108 break;
109 }
110 }
111
112 // Retrieve charset encoding
113 if(preg_match('/<?xml.*encoding=[\'"](.*?)[\'"].*?>/um',$data,$matches)) {
114 $this->_charSet = strtoupper($matches[1]);
115 }
116// echo 'Character Set is ',$this->_charSet,'<br />';
117
118 return $valid;
119 }
PHPExcel_Reader_Abstract\$_fileHandle
$_fileHandle
Definition: Abstract.php:70
PHPExcel_Reader_Abstract\_openFile
_openFile($pFilename)
Open file for reading.
Definition: Abstract.php:195
$valid
$valid
Definition: dummy_client.php:52

References PHPExcel_Reader_Abstract\$_fileHandle, $data, $valid, and PHPExcel_Reader_Abstract\_openFile().

Referenced by listWorksheetNames(), and loadIntoExisting().

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

◆ identifyFixedStyleValue()

static PHPExcel_Reader_Excel2003XML::identifyFixedStyleValue (   $styleList,
&  $styleAttributeValue 
)
staticprotected

Definition at line 242 of file Excel2003XML.php.

242 {
243 $styleAttributeValue = strtolower($styleAttributeValue);
244 foreach($styleList as $style) {
245 if ($styleAttributeValue == strtolower($style)) {
246 $styleAttributeValue = $style;
247 return true;
248 }
249 }
250 return false;
251 }
$style
$style
Definition: example_012.php:70

References $style.

◆ listWorksheetInfo()

PHPExcel_Reader_Excel2003XML::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 159 of file Excel2003XML.php.

160 {
161 // Check if file exists
162 if (!file_exists($pFilename)) {
163 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
164 }
165
166 $worksheetInfo = array();
167
168 $xml = simplexml_load_string($this->securityScan(file_get_contents($pFilename)), 'SimpleXMLElement', PHPExcel_Settings::getLibXmlLoaderOptions());
169 $namespaces = $xml->getNamespaces(true);
170
171 $worksheetID = 1;
172 $xml_ss = $xml->children($namespaces['ss']);
173 foreach($xml_ss->Worksheet as $worksheet) {
174 $worksheet_ss = $worksheet->attributes($namespaces['ss']);
175
176 $tmpInfo = array();
177 $tmpInfo['worksheetName'] = '';
178 $tmpInfo['lastColumnLetter'] = 'A';
179 $tmpInfo['lastColumnIndex'] = 0;
180 $tmpInfo['totalRows'] = 0;
181 $tmpInfo['totalColumns'] = 0;
182
183 if (isset($worksheet_ss['Name'])) {
184 $tmpInfo['worksheetName'] = (string) $worksheet_ss['Name'];
185 } else {
186 $tmpInfo['worksheetName'] = "Worksheet_{$worksheetID}";
187 }
188
189 if (isset($worksheet->Table->Row)) {
190 $rowIndex = 0;
191
192 foreach($worksheet->Table->Row as $rowData) {
193 $columnIndex = 0;
194 $rowHasData = false;
195
196 foreach($rowData->Cell as $cell) {
197 if (isset($cell->Data)) {
198 $tmpInfo['lastColumnIndex'] = max($tmpInfo['lastColumnIndex'], $columnIndex);
199 $rowHasData = true;
200 }
201
202 ++$columnIndex;
203 }
204
205 ++$rowIndex;
206
207 if ($rowHasData) {
208 $tmpInfo['totalRows'] = max($tmpInfo['totalRows'], $rowIndex);
209 }
210 }
211 }
212
213 $tmpInfo['lastColumnLetter'] = PHPExcel_Cell::stringFromColumnIndex($tmpInfo['lastColumnIndex']);
214 $tmpInfo['totalColumns'] = $tmpInfo['lastColumnIndex'] + 1;
215
216 $worksheetInfo[] = $tmpInfo;
217 ++$worksheetID;
218 }
219
220 return $worksheetInfo;
221 }
$worksheet
$worksheet
Definition: 40duplicateStyle.php:17
PHPExcel_Cell\stringFromColumnIndex
static stringFromColumnIndex($pColumnIndex=0)
String from columnindex.
Definition: Cell.php:825
PHPExcel_Reader_Abstract\securityScan
securityScan($xml)
Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks.
Definition: Abstract.php:236
PHPExcel_Reader_Exception
Definition: Exception.php:36
PHPExcel_Settings\getLibXmlLoaderOptions
static getLibXmlLoaderOptions()
Get default options for libxml loader.
Definition: Settings.php:381
$xml
$xml
Definition: metadata.php:240

References $worksheet, $xml, PHPExcel_Settings\getLibXmlLoaderOptions(), PHPExcel_Reader_Abstract\securityScan(), and PHPExcel_Cell\stringFromColumnIndex().

+ Here is the call graph for this function:

◆ listWorksheetNames()

PHPExcel_Reader_Excel2003XML::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 128 of file Excel2003XML.php.

129 {
130 // Check if file exists
131 if (!file_exists($pFilename)) {
132 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
133 }
134 if (!$this->canRead($pFilename)) {
135 throw new PHPExcel_Reader_Exception($pFilename . " is an Invalid Spreadsheet file.");
136 }
137
138 $worksheetNames = array();
139
140 $xml = simplexml_load_string($this->securityScan(file_get_contents($pFilename)), 'SimpleXMLElement', PHPExcel_Settings::getLibXmlLoaderOptions());
141 $namespaces = $xml->getNamespaces(true);
142
143 $xml_ss = $xml->children($namespaces['ss']);
144 foreach($xml_ss->Worksheet as $worksheet) {
145 $worksheet_ss = $worksheet->attributes($namespaces['ss']);
146 $worksheetNames[] = self::_convertStringEncoding((string) $worksheet_ss['Name'],$this->_charSet);
147 }
148
149 return $worksheetNames;
150 }
PHPExcel_Reader_Excel2003XML\_convertStringEncoding
static _convertStringEncoding($string, $charset)
Definition: Excel2003XML.php:793
PHPExcel_Reader_Excel2003XML\canRead
canRead($pFilename)
Can the current PHPExcel_Reader_IReader read the file?
Definition: Excel2003XML.php:77

References $worksheet, $xml, _convertStringEncoding(), canRead(), PHPExcel_Settings\getLibXmlLoaderOptions(), and PHPExcel_Reader_Abstract\securityScan().

+ Here is the call graph for this function:

◆ load()

PHPExcel_Reader_Excel2003XML::load (   $pFilename)

Loads PHPExcel from file.

Parameters
string$pFilename
Returns
PHPExcel
Exceptions
PHPExcel_Reader_Exception

Implements PHPExcel_Reader_IReader.

Definition at line 231 of file Excel2003XML.php.

232 {
233 // Create new PHPExcel
234 $objPHPExcel = new PHPExcel();
235 $objPHPExcel->removeSheetByIndex(0);
236
237 // Load into this instance
238 return $this->loadIntoExisting($pFilename, $objPHPExcel);
239 }
$objPHPExcel
$objPHPExcel
Definition: 01pharSimple.php:42
PHPExcel_Reader_Excel2003XML\loadIntoExisting
loadIntoExisting($pFilename, PHPExcel $objPHPExcel)
Loads PHPExcel from file into PHPExcel instance.
Definition: Excel2003XML.php:294

References $objPHPExcel, and loadIntoExisting().

+ Here is the call graph for this function:

◆ loadIntoExisting()

PHPExcel_Reader_Excel2003XML::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 294 of file Excel2003XML.php.

295 {
296 $fromFormats = array('\-', '\ ');
297 $toFormats = array('-', ' ');
298
299 $underlineStyles = array (
300 PHPExcel_Style_Font::UNDERLINE_NONE,
301 PHPExcel_Style_Font::UNDERLINE_DOUBLE,
302 PHPExcel_Style_Font::UNDERLINE_DOUBLEACCOUNTING,
303 PHPExcel_Style_Font::UNDERLINE_SINGLE,
304 PHPExcel_Style_Font::UNDERLINE_SINGLEACCOUNTING
305 );
306 $verticalAlignmentStyles = array (
307 PHPExcel_Style_Alignment::VERTICAL_BOTTOM,
308 PHPExcel_Style_Alignment::VERTICAL_TOP,
309 PHPExcel_Style_Alignment::VERTICAL_CENTER,
310 PHPExcel_Style_Alignment::VERTICAL_JUSTIFY
311 );
312 $horizontalAlignmentStyles = array (
313 PHPExcel_Style_Alignment::HORIZONTAL_GENERAL,
314 PHPExcel_Style_Alignment::HORIZONTAL_LEFT,
315 PHPExcel_Style_Alignment::HORIZONTAL_RIGHT,
316 PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
317 PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS,
318 PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY
319 );
320
321 $timezoneObj = new DateTimeZone('Europe/London');
322 $GMT = new DateTimeZone('UTC');
323
324
325 // Check if file exists
326 if (!file_exists($pFilename)) {
327 throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");
328 }
329
330 if (!$this->canRead($pFilename)) {
331 throw new PHPExcel_Reader_Exception($pFilename . " is an Invalid Spreadsheet file.");
332 }
333
334 $xml = simplexml_load_string($this->securityScan(file_get_contents($pFilename)), 'SimpleXMLElement', PHPExcel_Settings::getLibXmlLoaderOptions());
335 $namespaces = $xml->getNamespaces(true);
336
337 $docProps = $objPHPExcel->getProperties();
338 if (isset($xml->DocumentProperties[0])) {
339 foreach($xml->DocumentProperties[0] as $propertyName => $propertyValue) {
340 switch ($propertyName) {
341 case 'Title' :
342 $docProps->setTitle(self::_convertStringEncoding($propertyValue,$this->_charSet));
343 break;
344 case 'Subject' :
345 $docProps->setSubject(self::_convertStringEncoding($propertyValue,$this->_charSet));
346 break;
347 case 'Author' :
348 $docProps->setCreator(self::_convertStringEncoding($propertyValue,$this->_charSet));
349 break;
350 case 'Created' :
351 $creationDate = strtotime($propertyValue);
352 $docProps->setCreated($creationDate);
353 break;
354 case 'LastAuthor' :
355 $docProps->setLastModifiedBy(self::_convertStringEncoding($propertyValue,$this->_charSet));
356 break;
357 case 'LastSaved' :
358 $lastSaveDate = strtotime($propertyValue);
359 $docProps->setModified($lastSaveDate);
360 break;
361 case 'Company' :
362 $docProps->setCompany(self::_convertStringEncoding($propertyValue,$this->_charSet));
363 break;
364 case 'Category' :
365 $docProps->setCategory(self::_convertStringEncoding($propertyValue,$this->_charSet));
366 break;
367 case 'Manager' :
368 $docProps->setManager(self::_convertStringEncoding($propertyValue,$this->_charSet));
369 break;
370 case 'Keywords' :
371 $docProps->setKeywords(self::_convertStringEncoding($propertyValue,$this->_charSet));
372 break;
373 case 'Description' :
374 $docProps->setDescription(self::_convertStringEncoding($propertyValue,$this->_charSet));
375 break;
376 }
377 }
378 }
379 if (isset($xml->CustomDocumentProperties)) {
380 foreach($xml->CustomDocumentProperties[0] as $propertyName => $propertyValue) {
381 $propertyAttributes = $propertyValue->attributes($namespaces['dt']);
382 $propertyName = preg_replace_callback('/_x([0-9a-z]{4})_/','PHPExcel_Reader_Excel2003XML::_hex2str',$propertyName);
383 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_UNKNOWN;
384 switch((string) $propertyAttributes) {
385 case 'string' :
386 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_STRING;
387 $propertyValue = trim($propertyValue);
388 break;
389 case 'boolean' :
390 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_BOOLEAN;
391 $propertyValue = (bool) $propertyValue;
392 break;
393 case 'integer' :
394 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_INTEGER;
395 $propertyValue = intval($propertyValue);
396 break;
397 case 'float' :
398 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_FLOAT;
399 $propertyValue = floatval($propertyValue);
400 break;
401 case 'dateTime.tz' :
402 $propertyType = PHPExcel_DocumentProperties::PROPERTY_TYPE_DATE;
403 $propertyValue = strtotime(trim($propertyValue));
404 break;
405 }
406 $docProps->setCustomProperty($propertyName,$propertyValue,$propertyType);
407 }
408 }
409
410 foreach($xml->Styles[0] as $style) {
411 $style_ss = $style->attributes($namespaces['ss']);
412 $styleID = (string) $style_ss['ID'];
413// echo 'Style ID = '.$styleID.'<br />';
414 if ($styleID == 'Default') {
415 $this->_styles['Default'] = array();
416 } else {
417 $this->_styles[$styleID] = $this->_styles['Default'];
418 }
419 foreach ($style as $styleType => $styleData) {
420 $styleAttributes = $styleData->attributes($namespaces['ss']);
421// echo $styleType.'<br />';
422 switch ($styleType) {
423 case 'Alignment' :
424 foreach($styleAttributes as $styleAttributeKey => $styleAttributeValue) {
425// echo $styleAttributeKey.' = '.$styleAttributeValue.'<br />';
426 $styleAttributeValue = (string) $styleAttributeValue;
427 switch ($styleAttributeKey) {
428 case 'Vertical' :
429 if (self::identifyFixedStyleValue($verticalAlignmentStyles,$styleAttributeValue)) {
430 $this->_styles[$styleID]['alignment']['vertical'] = $styleAttributeValue;
431 }
432 break;
433 case 'Horizontal' :
434 if (self::identifyFixedStyleValue($horizontalAlignmentStyles,$styleAttributeValue)) {
435 $this->_styles[$styleID]['alignment']['horizontal'] = $styleAttributeValue;
436 }
437 break;
438 case 'WrapText' :
439 $this->_styles[$styleID]['alignment']['wrap'] = true;
440 break;
441 }
442 }
443 break;
444 case 'Borders' :
445 foreach($styleData->Border as $borderStyle) {
446 $borderAttributes = $borderStyle->attributes($namespaces['ss']);
447 $thisBorder = array();
448 foreach($borderAttributes as $borderStyleKey => $borderStyleValue) {
449// echo $borderStyleKey.' = '.$borderStyleValue.'<br />';
450 switch ($borderStyleKey) {
451 case 'LineStyle' :
452 $thisBorder['style'] = PHPExcel_Style_Border::BORDER_MEDIUM;
453// $thisBorder['style'] = $borderStyleValue;
454 break;
455 case 'Weight' :
456// $thisBorder['style'] = $borderStyleValue;
457 break;
458 case 'Position' :
459 $borderPosition = strtolower($borderStyleValue);
460 break;
461 case 'Color' :
462 $borderColour = substr($borderStyleValue,1);
463 $thisBorder['color']['rgb'] = $borderColour;
464 break;
465 }
466 }
467 if (!empty($thisBorder)) {
468 if (($borderPosition == 'left') || ($borderPosition == 'right') || ($borderPosition == 'top') || ($borderPosition == 'bottom')) {
469 $this->_styles[$styleID]['borders'][$borderPosition] = $thisBorder;
470 }
471 }
472 }
473 break;
474 case 'Font' :
475 foreach($styleAttributes as $styleAttributeKey => $styleAttributeValue) {
476// echo $styleAttributeKey.' = '.$styleAttributeValue.'<br />';
477 $styleAttributeValue = (string) $styleAttributeValue;
478 switch ($styleAttributeKey) {
479 case 'FontName' :
480 $this->_styles[$styleID]['font']['name'] = $styleAttributeValue;
481 break;
482 case 'Size' :
483 $this->_styles[$styleID]['font']['size'] = $styleAttributeValue;
484 break;
485 case 'Color' :
486 $this->_styles[$styleID]['font']['color']['rgb'] = substr($styleAttributeValue,1);
487 break;
488 case 'Bold' :
489 $this->_styles[$styleID]['font']['bold'] = true;
490 break;
491 case 'Italic' :
492 $this->_styles[$styleID]['font']['italic'] = true;
493 break;
494 case 'Underline' :
495 if (self::identifyFixedStyleValue($underlineStyles,$styleAttributeValue)) {
496 $this->_styles[$styleID]['font']['underline'] = $styleAttributeValue;
497 }
498 break;
499 }
500 }
501 break;
502 case 'Interior' :
503 foreach($styleAttributes as $styleAttributeKey => $styleAttributeValue) {
504// echo $styleAttributeKey.' = '.$styleAttributeValue.'<br />';
505 switch ($styleAttributeKey) {
506 case 'Color' :
507 $this->_styles[$styleID]['fill']['color']['rgb'] = substr($styleAttributeValue,1);
508 break;
509 }
510 }
511 break;
512 case 'NumberFormat' :
513 foreach($styleAttributes as $styleAttributeKey => $styleAttributeValue) {
514// echo $styleAttributeKey.' = '.$styleAttributeValue.'<br />';
515 $styleAttributeValue = str_replace($fromFormats,$toFormats,$styleAttributeValue);
516 switch ($styleAttributeValue) {
517 case 'Short Date' :
518 $styleAttributeValue = 'dd/mm/yyyy';
519 break;
520 }
521 if ($styleAttributeValue > '') {
522 $this->_styles[$styleID]['numberformat']['code'] = $styleAttributeValue;
523 }
524 }
525 break;
526 case 'Protection' :
527 foreach($styleAttributes as $styleAttributeKey => $styleAttributeValue) {
528// echo $styleAttributeKey.' = '.$styleAttributeValue.'<br />';
529 }
530 break;
531 }
532 }
533// print_r($this->_styles[$styleID]);
534// echo '<hr />';
535 }
536// echo '<hr />';
537
538 $worksheetID = 0;
539 $xml_ss = $xml->children($namespaces['ss']);
540
541 foreach($xml_ss->Worksheet as $worksheet) {
542 $worksheet_ss = $worksheet->attributes($namespaces['ss']);
543
544 if ((isset($this->_loadSheetsOnly)) && (isset($worksheet_ss['Name'])) &&
545 (!in_array($worksheet_ss['Name'], $this->_loadSheetsOnly))) {
546 continue;
547 }
548
549// echo '<h3>Worksheet: ',$worksheet_ss['Name'],'<h3>';
550//
551 // Create new Worksheet
552 $objPHPExcel->createSheet();
553 $objPHPExcel->setActiveSheetIndex($worksheetID);
554 if (isset($worksheet_ss['Name'])) {
555 $worksheetName = self::_convertStringEncoding((string) $worksheet_ss['Name'],$this->_charSet);
556 // Use false for $updateFormulaCellReferences to prevent adjustment of worksheet references in
557 // formula cells... during the load, all formulae should be correct, and we're simply bringing
558 // the worksheet name in line with the formula, not the reverse
559 $objPHPExcel->getActiveSheet()->setTitle($worksheetName,false);
560 }
561
562 $columnID = 'A';
563 if (isset($worksheet->Table->Column)) {
564 foreach($worksheet->Table->Column as $columnData) {
565 $columnData_ss = $columnData->attributes($namespaces['ss']);
566 if (isset($columnData_ss['Index'])) {
567 $columnID = PHPExcel_Cell::stringFromColumnIndex($columnData_ss['Index']-1);
568 }
569 if (isset($columnData_ss['Width'])) {
570 $columnWidth = $columnData_ss['Width'];
571// echo '<b>Setting column width for '.$columnID.' to '.$columnWidth.'</b><br />';
572 $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setWidth($columnWidth / 5.4);
573 }
574 ++$columnID;
575 }
576 }
577
578 $rowID = 1;
579 if (isset($worksheet->Table->Row)) {
580 $additionalMergedCells = 0;
581 foreach($worksheet->Table->Row as $rowData) {
582 $rowHasData = false;
583 $row_ss = $rowData->attributes($namespaces['ss']);
584 if (isset($row_ss['Index'])) {
585 $rowID = (integer) $row_ss['Index'];
586 }
587// echo '<b>Row '.$rowID.'</b><br />';
588
589 $columnID = 'A';
590 foreach($rowData->Cell as $cell) {
591
592 $cell_ss = $cell->attributes($namespaces['ss']);
593 if (isset($cell_ss['Index'])) {
594 $columnID = PHPExcel_Cell::stringFromColumnIndex($cell_ss['Index']-1);
595 }
596 $cellRange = $columnID.$rowID;
597
598 if ($this->getReadFilter() !== NULL) {
599 if (!$this->getReadFilter()->readCell($columnID, $rowID, $worksheetName)) {
600 continue;
601 }
602 }
603
604 if ((isset($cell_ss['MergeAcross'])) || (isset($cell_ss['MergeDown']))) {
605 $columnTo = $columnID;
606 if (isset($cell_ss['MergeAcross'])) {
607 $additionalMergedCells += (int)$cell_ss['MergeAcross'];
608 $columnTo = PHPExcel_Cell::stringFromColumnIndex(PHPExcel_Cell::columnIndexFromString($columnID) + $cell_ss['MergeAcross'] -1);
609 }
610 $rowTo = $rowID;
611 if (isset($cell_ss['MergeDown'])) {
612 $rowTo = $rowTo + $cell_ss['MergeDown'];
613 }
614 $cellRange .= ':'.$columnTo.$rowTo;
615 $objPHPExcel->getActiveSheet()->mergeCells($cellRange);
616 }
617
618 $cellIsSet = $hasCalculatedValue = false;
619 $cellDataFormula = '';
620 if (isset($cell_ss['Formula'])) {
621 $cellDataFormula = $cell_ss['Formula'];
622 // added this as a check for array formulas
623 if (isset($cell_ss['ArrayRange'])) {
624 $cellDataCSEFormula = $cell_ss['ArrayRange'];
625// echo "found an array formula at ".$columnID.$rowID."<br />";
626 }
627 $hasCalculatedValue = true;
628 }
629 if (isset($cell->Data)) {
630 $cellValue = $cellData = $cell->Data;
631 $type = PHPExcel_Cell_DataType::TYPE_NULL;
632 $cellData_ss = $cellData->attributes($namespaces['ss']);
633 if (isset($cellData_ss['Type'])) {
634 $cellDataType = $cellData_ss['Type'];
635 switch ($cellDataType) {
636 /*
637 const TYPE_STRING = 's';
638 const TYPE_FORMULA = 'f';
639 const TYPE_NUMERIC = 'n';
640 const TYPE_BOOL = 'b';
641 const TYPE_NULL = 'null';
642 const TYPE_INLINE = 'inlineStr';
643 const TYPE_ERROR = 'e';
644 */
645 case 'String' :
646 $cellValue = self::_convertStringEncoding($cellValue,$this->_charSet);
647 $type = PHPExcel_Cell_DataType::TYPE_STRING;
648 break;
649 case 'Number' :
650 $type = PHPExcel_Cell_DataType::TYPE_NUMERIC;
651 $cellValue = (float) $cellValue;
652 if (floor($cellValue) == $cellValue) {
653 $cellValue = (integer) $cellValue;
654 }
655 break;
656 case 'Boolean' :
657 $type = PHPExcel_Cell_DataType::TYPE_BOOL;
658 $cellValue = ($cellValue != 0);
659 break;
660 case 'DateTime' :
661 $type = PHPExcel_Cell_DataType::TYPE_NUMERIC;
662 $cellValue = PHPExcel_Shared_Date::PHPToExcel(strtotime($cellValue));
663 break;
664 case 'Error' :
665 $type = PHPExcel_Cell_DataType::TYPE_ERROR;
666 break;
667 }
668 }
669
670 if ($hasCalculatedValue) {
671// echo 'FORMULA<br />';
672 $type = PHPExcel_Cell_DataType::TYPE_FORMULA;
673 $columnNumber = PHPExcel_Cell::columnIndexFromString($columnID);
674 if (substr($cellDataFormula,0,3) == 'of:') {
675 $cellDataFormula = substr($cellDataFormula,3);
676// echo 'Before: ',$cellDataFormula,'<br />';
677 $temp = explode('"',$cellDataFormula);
678 $key = false;
679 foreach($temp as &$value) {
680 // Only replace in alternate array entries (i.e. non-quoted blocks)
681 if ($key = !$key) {
682 $value = str_replace(array('[.','.',']'),'',$value);
683 }
684 }
685 } else {
686 // Convert R1C1 style references to A1 style references (but only when not quoted)
687// echo 'Before: ',$cellDataFormula,'<br />';
688 $temp = explode('"',$cellDataFormula);
689 $key = false;
690 foreach($temp as &$value) {
691 // Only replace in alternate array entries (i.e. non-quoted blocks)
692 if ($key = !$key) {
693 preg_match_all('/(R(\[?-?\d*\]?))(C(\[?-?\d*\]?))/',$value, $cellReferences,PREG_SET_ORDER+PREG_OFFSET_CAPTURE);
694 // Reverse the matches array, otherwise all our offsets will become incorrect if we modify our way
695 // through the formula from left to right. Reversing means that we work right to left.through
696 // the formula
697 $cellReferences = array_reverse($cellReferences);
698 // Loop through each R1C1 style reference in turn, converting it to its A1 style equivalent,
699 // then modify the formula to use that new reference
700 foreach($cellReferences as $cellReference) {
701 $rowReference = $cellReference[2][0];
702 // Empty R reference is the current row
703 if ($rowReference == '') $rowReference = $rowID;
704 // Bracketed R references are relative to the current row
705 if ($rowReference{0} == '[') $rowReference = $rowID + trim($rowReference,'[]');
706 $columnReference = $cellReference[4][0];
707 // Empty C reference is the current column
708 if ($columnReference == '') $columnReference = $columnNumber;
709 // Bracketed C references are relative to the current column
710 if ($columnReference{0} == '[') $columnReference = $columnNumber + trim($columnReference,'[]');
711 $A1CellReference = PHPExcel_Cell::stringFromColumnIndex($columnReference-1).$rowReference;
712 $value = substr_replace($value,$A1CellReference,$cellReference[0][1],strlen($cellReference[0][0]));
713 }
714 }
715 }
716 }
717 unset($value);
718 // Then rebuild the formula string
719 $cellDataFormula = implode('"',$temp);
720// echo 'After: ',$cellDataFormula,'<br />';
721 }
722
723// echo 'Cell '.$columnID.$rowID.' is a '.$type.' with a value of '.(($hasCalculatedValue) ? $cellDataFormula : $cellValue).'<br />';
724//
725 $objPHPExcel->getActiveSheet()->getCell($columnID.$rowID)->setValueExplicit((($hasCalculatedValue) ? $cellDataFormula : $cellValue),$type);
726 if ($hasCalculatedValue) {
727// echo 'Formula result is '.$cellValue.'<br />';
728 $objPHPExcel->getActiveSheet()->getCell($columnID.$rowID)->setCalculatedValue($cellValue);
729 }
730 $cellIsSet = $rowHasData = true;
731 }
732
733 if (isset($cell->Comment)) {
734// echo '<b>comment found</b><br />';
735 $commentAttributes = $cell->Comment->attributes($namespaces['ss']);
736 $author = 'unknown';
737 if (isset($commentAttributes->Author)) {
738 $author = (string)$commentAttributes->Author;
739// echo 'Author: ',$author,'<br />';
740 }
741 $node = $cell->Comment->Data->asXML();
742// $annotation = str_replace('html:','',substr($node,49,-10));
743// echo $annotation,'<br />';
744 $annotation = strip_tags($node);
745// echo 'Annotation: ',$annotation,'<br />';
746 $objPHPExcel->getActiveSheet()->getComment( $columnID.$rowID )
747 ->setAuthor(self::_convertStringEncoding($author ,$this->_charSet))
748 ->setText($this->_parseRichText($annotation) );
749 }
750
751 if (($cellIsSet) && (isset($cell_ss['StyleID']))) {
752 $style = (string) $cell_ss['StyleID'];
753// echo 'Cell style for '.$columnID.$rowID.' is '.$style.'<br />';
754 if ((isset($this->_styles[$style])) && (!empty($this->_styles[$style]))) {
755// echo 'Cell '.$columnID.$rowID.'<br />';
756// print_r($this->_styles[$style]);
757// echo '<br />';
758 if (!$objPHPExcel->getActiveSheet()->cellExists($columnID.$rowID)) {
759 $objPHPExcel->getActiveSheet()->getCell($columnID.$rowID)->setValue(NULL);
760 }
761 $objPHPExcel->getActiveSheet()->getStyle($cellRange)->applyFromArray($this->_styles[$style]);
762 }
763 }
764 ++$columnID;
765 while ($additionalMergedCells > 0) {
766 ++$columnID;
767 $additionalMergedCells--;
768 }
769 }
770
771 if ($rowHasData) {
772 if (isset($row_ss['StyleID'])) {
773 $rowStyle = $row_ss['StyleID'];
774 }
775 if (isset($row_ss['Height'])) {
776 $rowHeight = $row_ss['Height'];
777// echo '<b>Setting row height to '.$rowHeight.'</b><br />';
778 $objPHPExcel->getActiveSheet()->getRowDimension($rowID)->setRowHeight($rowHeight);
779 }
780 }
781
782 ++$rowID;
783 }
784 }
785 ++$worksheetID;
786 }
787
788 // Return
789 return $objPHPExcel;
790 }
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_Cell\columnIndexFromString
static columnIndexFromString($pString='A')
Column index from string.
Definition: Cell.php:782
PHPExcel_DocumentProperties\PROPERTY_TYPE_DATE
const PROPERTY_TYPE_DATE
Definition: DocumentProperties.php:42
PHPExcel_DocumentProperties\PROPERTY_TYPE_BOOLEAN
const PROPERTY_TYPE_BOOLEAN
constants
Definition: DocumentProperties.php:39
PHPExcel_DocumentProperties\PROPERTY_TYPE_UNKNOWN
const PROPERTY_TYPE_UNKNOWN
Definition: DocumentProperties.php:44
PHPExcel_DocumentProperties\PROPERTY_TYPE_FLOAT
const PROPERTY_TYPE_FLOAT
Definition: DocumentProperties.php:41
PHPExcel_DocumentProperties\PROPERTY_TYPE_INTEGER
const PROPERTY_TYPE_INTEGER
Definition: DocumentProperties.php:40
PHPExcel_DocumentProperties\PROPERTY_TYPE_STRING
const PROPERTY_TYPE_STRING
Definition: DocumentProperties.php:43
PHPExcel_Reader_Abstract\getReadFilter
getReadFilter()
Read filter.
Definition: Abstract.php:173
PHPExcel_Reader_Excel2003XML\_parseRichText
_parseRichText($is='')
Definition: Excel2003XML.php:801
PHPExcel_Shared_Date\PHPToExcel
static PHPToExcel($dateValue=0, $adjustToTimezone=FALSE, $timezone=NULL)
Convert a date from PHP to Excel.
Definition: Date.php:185
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_Border\BORDER_MEDIUM
const BORDER_MEDIUM
Definition: Border.php:46
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
$key
$key
Definition: croninfo.php:18
$type
$type
Definition: proxy_ylocal.php:10

References $key, $objPHPExcel, $style, $type, $worksheet, $xml, _convertStringEncoding(), _parseRichText(), PHPExcel_Style_Border\BORDER_MEDIUM, canRead(), PHPExcel_Cell\columnIndexFromString(), PHPExcel_Settings\getLibXmlLoaderOptions(), 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\PHPToExcel(), PHPExcel_DocumentProperties\PROPERTY_TYPE_BOOLEAN, PHPExcel_DocumentProperties\PROPERTY_TYPE_DATE, PHPExcel_DocumentProperties\PROPERTY_TYPE_FLOAT, PHPExcel_DocumentProperties\PROPERTY_TYPE_INTEGER, PHPExcel_DocumentProperties\PROPERTY_TYPE_STRING, PHPExcel_DocumentProperties\PROPERTY_TYPE_UNKNOWN, PHPExcel_Reader_Abstract\securityScan(), 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().

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

Field Documentation

◆ $_charSet

PHPExcel_Reader_Excel2003XML::$_charSet = 'UTF-8'
protected

Definition at line 59 of file Excel2003XML.php.

◆ $_styles

PHPExcel_Reader_Excel2003XML::$_styles = array()
protected

Definition at line 52 of file Excel2003XML.php.

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