| 1234567891011121314151617181920212223242526272829 |
- <?php
- use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- require __DIR__ . '/../../Header.php';
- $category = 'Engineering';
- $functionName = 'BESSELK';
- $description = 'Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments';
- $helper->titles($category, $functionName, $description);
- // Create new PhpSpreadsheet object
- $spreadsheet = new Spreadsheet();
- $worksheet = $spreadsheet->getActiveSheet();
- for ($n = 0; $n <= 5; ++$n) {
- for ($x = 0; $x <= 5; $x = $x + 0.25) {
- Calculation::getInstance($spreadsheet)->flushInstance();
- $worksheet->setCellValue('A1', "=BESSELK({$x}, {$n})");
- $helper->log(sprintf(
- '%s = %f',
- $worksheet->getCell('A1')->getValue(),
- $worksheet->getCell('A1')->getCalculatedValue()
- ));
- }
- }
|