format_border_of_the_four_sides_1.phpt 1.1 KB

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