| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\Calculation\Calculation; |
| 4 |
use PhpOffice\PhpSpreadsheet\Spreadsheet; |
| 5 |
|
| 6 |
require __DIR__ . '/../Header.php'; |
| 7 |
|
| 8 |
// List functions |
| 9 |
$helper->log('List implemented functions'); |
| 10 |
$calc = Calculation::getInstance(); |
| 11 |
print_r($calc->getImplementedFunctionNames()); |
| 12 |
|
| 13 |
// Create new Spreadsheet object |
| 14 |
$helper->log('Create new Spreadsheet object'); |
| 15 |
$spreadsheet = new Spreadsheet(); |
| 16 |
|
| 17 |
// Add some data, we will use some formulas here |
| 18 |
$helper->log('Add some data'); |
| 19 |
$spreadsheet->getActiveSheet()->setCellValue('A14', 'Count:'); |
| 20 |
|
| 21 |
$spreadsheet->getActiveSheet()->setCellValue('B1', 'Range 1'); |
| 22 |
$spreadsheet->getActiveSheet()->setCellValue('B2', 2); |
| 23 |
$spreadsheet->getActiveSheet()->setCellValue('B3', 8); |
| 24 |
$spreadsheet->getActiveSheet()->setCellValue('B4', 10); |
| 25 |
$spreadsheet->getActiveSheet()->setCellValue('B5', true); |
| 26 |
$spreadsheet->getActiveSheet()->setCellValue('B6', false); |
| 27 |
$spreadsheet->getActiveSheet()->setCellValue('B7', 'Text String'); |
| 28 |
$spreadsheet->getActiveSheet()->setCellValue('B9', '22'); |
| 29 |
$spreadsheet->getActiveSheet()->setCellValue('B10', 4); |
| 30 |
$spreadsheet->getActiveSheet()->setCellValue('B11', 6); |
| 31 |
$spreadsheet->getActiveSheet()->setCellValue('B12', 12); |
| 32 |
|
| 33 |
$spreadsheet->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)'); |
| 34 |
|
| 35 |
$spreadsheet->getActiveSheet()->setCellValue('C1', 'Range 2'); |
| 36 |
$spreadsheet->getActiveSheet()->setCellValue('C2', 1); |
| 37 |
$spreadsheet->getActiveSheet()->setCellValue('C3', 2); |
| 38 |
$spreadsheet->getActiveSheet()->setCellValue('C4', 2); |
| 39 |
$spreadsheet->getActiveSheet()->setCellValue('C5', 3); |
| 40 |
$spreadsheet->getActiveSheet()->setCellValue('C6', 3); |
| 41 |
$spreadsheet->getActiveSheet()->setCellValue('C7', 3); |
| 42 |
$spreadsheet->getActiveSheet()->setCellValue('C8', '0'); |
| 43 |
$spreadsheet->getActiveSheet()->setCellValue('C9', 4); |
| 44 |
$spreadsheet->getActiveSheet()->setCellValue('C10', 4); |
| 45 |
$spreadsheet->getActiveSheet()->setCellValue('C11', 4); |
| 46 |
$spreadsheet->getActiveSheet()->setCellValue('C12', 4); |
| 47 |
|
| 48 |
$spreadsheet->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)'); |
| 49 |
|
| 50 |
$spreadsheet->getActiveSheet()->setCellValue('D1', 'Range 3'); |
| 51 |
$spreadsheet->getActiveSheet()->setCellValue('D2', 2); |
| 52 |
$spreadsheet->getActiveSheet()->setCellValue('D3', 3); |
| 53 |
$spreadsheet->getActiveSheet()->setCellValue('D4', 4); |
| 54 |
|
| 55 |
$spreadsheet->getActiveSheet()->setCellValue('D5', '=((D2 * D3) + D4) & " should be 10"'); |
| 56 |
|
| 57 |
$spreadsheet->getActiveSheet()->setCellValue('E1', 'Other functions'); |
| 58 |
$spreadsheet->getActiveSheet()->setCellValue('E2', '=PI()'); |
| 59 |
$spreadsheet->getActiveSheet()->setCellValue('E3', '=RAND()'); |
| 60 |
$spreadsheet->getActiveSheet()->setCellValue('E4', '=RANDBETWEEN(5, 10)'); |
| 61 |
|
| 62 |
$spreadsheet->getActiveSheet()->setCellValue('E14', 'Count of both ranges:'); |
| 63 |
$spreadsheet->getActiveSheet()->setCellValue('F14', '=COUNT(B2:C12)'); |
| 64 |
|
| 65 |
// Calculated data |
| 66 |
$helper->log('Calculated data'); |
| 67 |
$helper->log('Value of B14 [=COUNT(B2:B12)]: ' . $spreadsheet->getActiveSheet()->getCell('B14')->getCalculatedValue()); |
| 68 |
|
| 69 |
$helper->logEndingNotes(); |
| 70 |
|
