1: <?php
  2: /**
  3:  * LICENSE (BSD)
  4:  *
  5:  * Copyright (c) 2013, Gerd Christian Kunze
  6:  * All rights reserved.
  7:  *
  8:  * Redistribution and use in source and binary forms, with or without
  9:  * modification, are permitted provided that the following conditions are
 10:  * met:
 11:  *
 12:  *  * Redistributions of source code must retain the above copyright
 13:  *    notice, this list of conditions and the following disclaimer.
 14:  *
 15:  *  * Redistributions in binary form must reproduce the above copyright
 16:  *    notice, this list of conditions and the following disclaimer in the
 17:  *    documentation and/or other materials provided with the distribution.
 18:  *
 19:  *  * Neither the name of Gerd Christian Kunze nor the names of the
 20:  *    contributors may be used to endorse or promote products derived from
 21:  *    this software without specific prior written permission.
 22:  *
 23:  * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
 24:  * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
 25:  * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 26:  * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 27:  * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 28:  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 29:  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 30:  * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 31:  * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 32:  * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 33:  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 34:  *
 35:  * Select
 36:  * 18.06.2013 13:26
 37:  */
 38: namespace MOC\Module\Office\Document\Excel\Worksheet;
 39: use MOC\Api;
 40: use MOC\Generic\Device\Module;
 41: 
 42: /**
 43:  *
 44:  */
 45: class Select implements Module {
 46:     /**
 47:      * Get Changelog
 48:      *
 49:      * @static
 50:      * @return \MOC\Core\Changelog
 51:      */
 52:     public static function InterfaceChangelog() {
 53:         return Api::Core()->Changelog()->Create( __CLASS__ );
 54:     }
 55: 
 56:     /**
 57:      * Get Dependencies
 58:      *
 59:      * @static
 60:      * @return \MOC\Core\Depending
 61:      */
 62:     public static function InterfaceDepending() {
 63:         return Api::Core()->Depending();
 64:     }
 65: 
 66:     /**
 67:      * Get Singleton/Instance
 68:      *
 69:      * @static
 70:      * @return Select
 71:      */
 72:     public static function InterfaceInstance() {
 73:         return new Select();
 74:     }
 75: 
 76:     /**
 77:      * @param string $Name
 78:      * @return \MOC\Module\Office\Document\Excel
 79:      */
 80:     public function ByName( $Name ) {
 81:         /** @noinspection PhpParamsInspection */
 82:         Api::Extension()->Excel()->Current()->setActiveSheetIndex(
 83:             Api::Extension()->Excel()->Current()->getIndex(
 84:                 Api::Extension()->Excel()->Current()->getSheetByName( $Name )
 85:             )
 86:         );
 87:         return Api::Module()->Office()->Document()->Excel();
 88:     }
 89: 
 90:     /**
 91:      * @param int $Index 0..n
 92:      * @return \MOC\Module\Office\Document\Excel
 93:      */
 94:     public function ByIndex( $Index = 0 ) {
 95:         /** @noinspection PhpParamsInspection */
 96:         Api::Extension()->Excel()->Current()->setActiveSheetIndex( $Index );
 97:         return Api::Module()->Office()->Document()->Excel();
 98:     }
 99: 
100: }
101: