I can not read spreadsheets with formulas and filters

Topics: Developer Forum, Project Management Forum, User Forum
Dec 27, 2014 at 9:03 PM
Hello guys, I can not read data from a spreadsheet that has filters, formatting and formulas, to remove the formatting, filters and formulas can read.

Could someone help me to capture data from spreadsheets without having to remove filters or formulas?


CODE

<? php
require_once 'Classes / PHPExcel / IOFactory.php';
$ objPHPExcel = PHPExcel_IOFactory :: load ("teste.xlsx");
$ objPHPExcel-> setActiveSheetIndex (0);
for ($ line = 2; $ row <20; ++ $ line)
{
         @ $ r = utf8_decode ($ objPHPExcel-> getActiveSheet () -> getCellByColumnAndRow (2, $ line) -> getValue ());
         echo $ r "Subject".;
}
?>

ERROR

Fatal error: Maximum execution time of 30 seconds exceeded in C: \ Program Files (x86) \ EasyPHP-5.3.8.1 \ www \ 1.7.6 \ Classes \ PHPExcel \ Cell.php on line 240