Ignore empty cells PHPExcel

by

If your problem is in getting empty columns that go after real data, and you would like to avoid these, you could do something like this:

$maxCell = $sheet->getHighestRowAndColumn();
$data = $sheet->rangeToArray('A1:' . $maxCell['column'] . $maxCell['row']);

This will return array representing only the area containing real data.

More Related Contents:

  1. PHPExcel — Color part of XLSX table
  2. Alternative for PHP_excel
  3. PHPExcel runs out of 256, 512 and also 1024MB of RAM
  4. phpexcel to download
  5. How to fix memory getting exhausted with PHPExcel?
  6. PHPExcel auto size column width
  7. PHPExcel download using ajax call
  8. How to use phpexcel to read data and insert into database?
  9. How to read large worksheets from large Excel files (27MB+) with PHPExcel?
  10. Correct format for strings / numbers beginning with zero?
  11. phpexcel Allowed memory size of 134217728 bytes exhausted [duplicate]
  12. Removing eval from PHP function [closed]
  13. Route to image in Laravel [closed]
  14. SELECT COUNT(*) AS count – How to use this count
  15. String comparison using ‘==’ vs. ‘strcmp()’
  16. How to upload images into MySQL database using PHP code
  17. Preparing for removal of Mcrypt in PHP 7.2
  18. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  19. How to get directory size in PHP
  20. How to login in with Curl and SSL and cookies
  21. Remove all the line breaks from the html source
  22. PHPUnit Mock Objects and Static Methods
  23. Pushnotification Server side Implementation
  24. Is it possible to protect from downloading a video from a site
  25. How to prevent the cron job execution, if it is already running
  26. PHP – Convert File system path to URL
  27. getting the full url including the query string after hash
  28. Convert a big integer to a full string in PHP
  29. Difference between set_time_limit() and ini_set(‘max_execution_time’, …)
  30. When and why should $_REQUEST be used instead of $_GET / $_POST / $_COOKIE?

Leave a Comment