xlsx_to_csv_skip_rows.phpt 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  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'];
  11. $excel = new \Vtiful\Kernel\Excel($config);
  12. $filePath = $excel->fileName('xlsx_to_csv_skip_rows.xlsx', 'TestSheet1')
  13. ->header(['Item', 'Cost'])
  14. ->data([
  15. ['Item_1', 'Cost_1', 10, 10.9999995],
  16. ['Item_2', 'Cost_2', 10, 10.9999995],
  17. ['Item_3', 'Cost_3', 10, 10.9999995],
  18. ])
  19. ->output();
  20. $fp = fopen('./tests/file.csv', 'w');
  21. $csvResult = $excel->openFile('xlsx_to_csv_skip_rows.xlsx')
  22. ->openSheet()
  23. ->setSkipRows(1)
  24. ->putCSV($fp);
  25. fclose($fp);
  26. var_dump($csvResult);
  27. var_dump(file_get_contents('./tests/file.csv'));
  28. $fp = fopen('./tests/file.csv', 'w');
  29. $csvResult = $excel->openFile('xlsx_to_csv_skip_rows.xlsx')
  30. ->openSheet()
  31. ->setSkipRows(2)
  32. ->putCSV($fp);
  33. fclose($fp);
  34. var_dump($csvResult);
  35. var_dump(file_get_contents('./tests/file.csv'));
  36. ?>
  37. --CLEAN--
  38. <?php
  39. @unlink(__DIR__ . '/xlsx_to_csv_skip_rows.xlsx');
  40. @unlink(__DIR__ . '/file.csv');
  41. ?>
  42. --EXPECT--
  43. bool(true)
  44. string(84) "Item_1,Cost_1,10,10.9999995
  45. Item_2,Cost_2,10,10.9999995
  46. Item_3,Cost_3,10,10.9999995
  47. "
  48. bool(true)
  49. string(56) "Item_2,Cost_2,10,10.9999995
  50. Item_3,Cost_3,10,10.9999995
  51. "