csvTest.php 712 B

1234567891011121314151617181920212223242526272829303132333435
  1. <?php
  2. /**
  3. * Csv test
  4. *
  5. * @author Janson
  6. * @create 2017-11-25
  7. */
  8. require __DIR__ . '/../autoload.php';
  9. $start = microtime(true);
  10. $memory = memory_get_usage();
  11. $reader = Asan\PHPExcel\Excel::load('files/02.csv', function(Asan\PHPExcel\Reader\Csv $reader) {
  12. $reader->setRowLimit(5);
  13. $reader->setColumnLimit(10);
  14. $reader->ignoreEmptyRow(true);
  15. //$reader->setInputEncoding('UTF-8');
  16. $reader->setDelimiter("\t");
  17. });
  18. foreach ($reader as $row) {
  19. var_dump($row);
  20. }
  21. $reader->seek(2);
  22. $count = $reader->count();
  23. //$reader->seek(1);
  24. $current = $reader->current();
  25. $time = microtime(true) - $start;
  26. $use = memory_get_usage() - $memory;
  27. var_dump($current, $count, $time, $use/1024/1024);