123456789101112131415161718192021222324252627282930 |
- --TEST--
- Check for vtiful presence
- --SKIPIF--
- <?php if (!extension_loaded("xlswriter")) print "skip"; ?>
- --FILE--
- <?php
- $config = ['path' => './tests'];
- $excel = new \Vtiful\Kernel\Excel($config);
- $freeFile = $excel->fileName("tutorial01.xlsx")
- ->header(['name', 'money']);
- for($index = 1; $index < 10; $index++) {
- $freeFile->insertText($index, 0, 'vikin');
- $freeFile->insertText($index, 1, 10);
- }
- $freeFile->insertText(12, 0, "Total");
- $freeFile->insertFormula(12, 1, '=SUM(B2:B11)');
- $filePath = $freeFile->output();
- var_dump($filePath);
- ?>
- --CLEAN--
- <?php
- @unlink(__DIR__ . '/tutorial01.xlsx');
- ?>
- --EXPECT--
- string(23) "./tests/tutorial01.xlsx"
|