Cacher is the code snippet organizer for pro developers

		// create an object representation of the XML file
		$xmlFile = $this->readFile('xl/workbook.xml');
		$xmlObject = new SimpleXMLElement($xmlFile);

		// extract worksheet names
		foreach ($xmlObject->sheets->sheet as $sheetObject)
			$sheetnames[] = (string) $sheetObject->attributes()->name;

		// debug($sheetnames);





		$resource = xml_parser_create();
        xml_parse_into_struct($resource, $xmlFile, $xmlStructure);
        xml_parser_free($resource);

        // debug($xmlStructure);

        // read all sheet names into array
        foreach ($xmlStructure as $key => $xmlTag) {

        	if ($xmlTag["tag"] == "SHEET") {
        		echo 'Yes ';
        	}

        	debug($xmlTag);
        }