12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 |
- --TEST--
- Check for vtiful presence
- --SKIPIF--
- <?php
- require __DIR__ . '/include/skipif.inc';
- skip_disable_reader();
- ?>
- --FILE--
- <?php
- $config = ['path' => './tests'];
- $excel = new \Vtiful\Kernel\Excel($config);
- $filePath = $excel->fileName('tutorial.xlsx')
- ->header(['', 'Cost'])
- ->data([
- [],
- ['viest', '']
- ])
- ->output();
- $data = $excel->openFile('tutorial.xlsx')
- ->openSheet('Sheet1', \Vtiful\Kernel\Excel::SKIP_EMPTY_CELLS)
- ->getSheetData();
- var_dump($data);
- $data = $excel->openFile('tutorial.xlsx')
- ->openSheet('Sheet1', \Vtiful\Kernel\Excel::SKIP_EMPTY_ROW)
- ->getSheetData();
- var_dump($data);
- $data = $excel->openFile('tutorial.xlsx')
- ->openSheet('Sheet1', \Vtiful\Kernel\Excel::SKIP_EMPTY_CELLS|\Vtiful\Kernel\Excel::SKIP_EMPTY_ROW)
- ->getSheetData();
- var_dump($data);
- ?>
- --CLEAN--
- <?php
- @unlink(__DIR__ . '/tutorial.xlsx');
- ?>
- --EXPECT--
- array(3) {
- [0]=>
- array(1) {
- [1]=>
- string(4) "Cost"
- }
- [1]=>
- array(0) {
- }
- [2]=>
- array(1) {
- [0]=>
- string(5) "viest"
- }
- }
- array(2) {
- [0]=>
- array(2) {
- [0]=>
- string(0) ""
- [1]=>
- string(4) "Cost"
- }
- [1]=>
- array(2) {
- [0]=>
- string(5) "viest"
- [1]=>
- string(0) ""
- }
- }
- array(2) {
- [0]=>
- array(1) {
- [1]=>
- string(4) "Cost"
- }
- [1]=>
- array(1) {
- [0]=>
- string(5) "viest"
- }
- }
|