open_xlsx_get_data_skip_hidden_rows.phpt 955 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. --TEST--
  2. Check for vtiful presence
  3. --SKIPIF--
  4. <?php
  5. require __DIR__ . '/include/skipif.inc';
  6. skip_disable_reader();
  7. ?>
  8. --FILE--
  9. <?php
  10. $config = ['path' => './tests/xlsx'];
  11. $excel = new \Vtiful\Kernel\Excel($config);
  12. $data = $excel->openFile('hidden_row.xlsx')
  13. ->openSheet('Sheet1')
  14. ->getSheetData();
  15. var_dump($data);
  16. $data = $excel->openFile('hidden_row.xlsx')
  17. ->openSheet('Sheet1', \Vtiful\Kernel\Excel::SKIP_HIDDEN_ROW|\Vtiful\Kernel\Excel::SKIP_EMPTY_ROW)
  18. ->getSheetData();
  19. var_dump($data);
  20. ?>
  21. --CLEAN--
  22. <?php
  23. @unlink(__DIR__ . '/tutorial.xlsx');
  24. ?>
  25. --EXPECT--
  26. array(4) {
  27. [0]=>
  28. array(1) {
  29. [0]=>
  30. string(4) "name"
  31. }
  32. [1]=>
  33. array(1) {
  34. [0]=>
  35. string(8) "ZhangSan"
  36. }
  37. [2]=>
  38. array(1) {
  39. [0]=>
  40. string(4) "LiSi"
  41. }
  42. [3]=>
  43. array(1) {
  44. [0]=>
  45. string(6) "WangWu"
  46. }
  47. }
  48. array(2) {
  49. [0]=>
  50. array(1) {
  51. [0]=>
  52. string(4) "name"
  53. }
  54. [1]=>
  55. array(1) {
  56. [0]=>
  57. string(6) "WangWu"
  58. }
  59. }