How to hide all rows in a worksheet

Jul 7, 2010 at 12:43 PM
Edited Jul 7, 2010 at 12:46 PM
I generate a simple report and I have to hide all rows below it. Is there a simple way to hide these rows or I have to cycle through all rows and hide them with getRowDimension($i)->setVisible(false); The problem with the second method is that when there are more sheets the script runs out of memory. One more thing - the script reads from a template file where all unnecessary cols and rows are hidden but when the new file is generated only the cols remain hidden and rows are displayed. Do the template file is not properly formatted or this is normal behaviour of phpexcel?