mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 14:03:47 +00:00
Mark Baker
70f372d88c
* Start refactoring the Lookup and Reference functions - COLUMN(), COLUMNS(), ROW() and ROWS() - LOOKUP(), VLOOKUP() and HLOOKUP() - Refactor TRANSPOSE() and ADDRESS() functions into their own classes * Additional unit tests - LOOKUP() - TRANSPOSE() - ADDRESS()
33 lines
526 B
PHP
33 lines
526 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
[
|
|
['Jan', 'Feb', 'Mar', 'Apr'],
|
|
[100, 200, 150, 300],
|
|
],
|
|
[
|
|
['Jan', 100],
|
|
['Feb', 200],
|
|
['Mar', 150],
|
|
['Apr', 300],
|
|
],
|
|
],
|
|
[
|
|
[
|
|
['a', 'aa'],
|
|
['b', 'ab'],
|
|
['c', 'ac'],
|
|
['d', 'ad'],
|
|
],
|
|
[
|
|
['a', 'b', 'c', 'd'],
|
|
['aa', 'ab', 'ac', 'ad'],
|
|
],
|
|
],
|
|
[
|
|
[[3.14]],
|
|
3.14,
|
|
],
|
|
];
|