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: * 25.02.2013 16:06
37: */
38: namespace MOC\Module\Office\Document\Excel\Cell;
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: /** @var string $Coordinate */
77: private static $Coordinate = '';
78:
79: /**
80: * @param string $Name
81: * @return \MOC\Module\Office\Document\Excel
82: */
83: public function ByName( $Name = 'A1' ) {
84: self::$Coordinate = $Name;
85: return Api::Module()->Office()->Document()->Excel();
86: }
87:
88: /**
89: * @param int $X 0..n
90: * @param int $Y 1..n
91: * @return \MOC\Module\Office\Document\Excel
92: */
93: public function ByIndex( $X = 0, $Y = 1 ) {
94: self::$Coordinate = \PHPExcel_Cell::stringFromColumnIndex( $X ).$Y;
95: return Api::Module()->Office()->Document()->Excel();
96: }
97:
98: /**
99: * @return string
100: */
101: public function Current() {
102: return self::$Coordinate;
103: }
104: }
105: