title: Process bulk XLS in PHP
body: <p>I am trying to process more than 1,00,000 XLS rows with PHP script (using PHPEXCEL library <a href="http://phpexcel.codeplex.com/releases/view/107442" rel="nofollow">http://phpexcel.codeplex.com/releases/view/107442</a>) and insert into MYSQL but every time it gives me timeout. So I have changed the memory limits, execution limit and post size limit    </p>
  
  <pre><code>set_time_limit(1800);
  ini_set('memory_limit','-1');
  ini_set('upload_max_filesize', '512M');
  ini_set('post_max_size','250M');    
  </code></pre>
  
  <p>Timeout problem was sorted but now I am getting server reset while loading of EXCEL file with PHPEXCEL library.        </p>
  
  <pre><code>PHPExcel_Cell::setValueBinder( new PHPExcel_Cell_AdvancedValueBinder() );
  $objReader = PHPExcel_IOFactory::createReader($inputFileType);
  $objReader-&gt;setLoadSheetsOnly($sheetname);
  $objPHPExcel = $objReader-&gt;load($inputFileName);
  </code></pre>
  
  <p><strong>I am getting server reset here.</strong> </p>
  
  <pre><code>$objPHPExcel-&gt;getProperties()-&gt;setCreator("Maarten Balliauw")
              -&gt;setLastModifiedBy("Maarten Balliauw")
              -&gt;setTitle("Office 2007 XLSX  Document")
              -&gt;setSubject("Office 2007 XLSX  Document")
              -&gt;setDescription(" Document for Office 2007 XLSX, generated using PHP classes.")
              -&gt;setKeywords("office 2007 openxml php")-&gt;setCategory("php result file");
  $this-&gt;dump($objPHPExcel);
  // to iterate sheets
  foreach ($objPHPExcel-&gt;getWorksheetIterator() as $worksheet)
      // to iterate rows
      foreach ($worksheet-&gt;getRowIterator() as $row) 
      {
         $cellIterator = $row-&gt;getCellIterator();
         $cellIterator-&gt;setIterateOnlyExistingCells(false);
         // to iterate cells
         foreach ($cellIterator as $cell =&gt; $val) {
  </code></pre>
  
  <p>Unfortunately never got any script or tutorial to handle bulk data parsing in php.    </p>
  
  <p>Please help</p>