Good day! I use PHPExcel for a large file, about 20 MB in size, to bypass the memory limit, I have to use SetReadFilter and ChunkReadFilter to read in chunks. But in this case, determining the number of rows per sheet (GetHighestRow) does not work. Those. it works, but it is always equal to the number of lines in the selected piece of the file (that is, if I read 100 lines each, it is always 100, if I read 10 each, it is always 10). Is it possible to still get the full number of lines per sheet? Thank!

    1 answer 1

    Found a solution:

    $FilePath = PATH_TO_FILE; $objReader = PHPExcel_IOFactory::CreateReaderForFile($FilePath); $arSheetsInfo = $objReader->ListWorksheetInfo($FilePath); print_r($arSheetsInfo);