xlsTest.php 677 B

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