format_border.phpt 825 B

1234567891011121314151617181920212223242526272829303132333435363738
  1. --TEST--
  2. Check for vtiful presence
  3. --SKIPIF--
  4. <?php if (!extension_loaded("xlswriter")) print "skip"; ?>
  5. --FILE--
  6. <?php
  7. $config = ['path' => './tests'];
  8. $fileObject = new \Vtiful\Kernel\Excel($config);
  9. $fileObject = $fileObject->fileName('format_border.xlsx');
  10. $fileHandle = $fileObject->getHandle();
  11. $data = [
  12. ['viest1', 21, 100, "A"],
  13. ['viest2', 20, 80, "B"],
  14. ['viest3', 22, 70, "C"],
  15. ];
  16. $format = new \Vtiful\Kernel\Format($fileHandle);
  17. $borderStyle = $format
  18. ->border(\Vtiful\Kernel\Format::BORDER_THIN)
  19. ->toResource();
  20. $filePath = $fileObject->header(['name', 'age', 'score', 'level'])
  21. ->data($data)
  22. ->setRow('A1', 20, $borderStyle)
  23. ->output();
  24. var_dump($filePath);
  25. ?>
  26. --CLEAN--
  27. <?php
  28. @unlink(__DIR__ . '/format_border.xlsx');
  29. ?>
  30. --EXPECT--
  31. string(26) "./tests/format_border.xlsx"