title: Excel Data Display in PHP Automatic show of set of rows
body: <p>Hi I am  having issue in Displaying data in PHP
  My Requirement  is I would like to Display excel Data in Table and Column 
  with refresh in Data </p>
  
  <p>I would like to Show  sets of  5 Rows at a time
  refresh table and show next set of Rows  </p>
  
  <p>I am working on PHP with PHPExcel Objects already included </p>
  
  <pre><code>  &lt;?php
               require_once 'Classes/PHPExcel.php';
  //$excel = PHPExcel_IOFactory::load('N:\\DASH_BOARD_EXCEL.xls');
  session_start();
  
  $excel = PHPExcel_IOFactory::load('DASH_BOARD_EXCEL_2.xls');
  $excel-&gt;setActiveSheetIndex(0);
  
  $i = 2;
  while($excel-&gt;getActiveSheet()-&gt;getCell('A' .$i)-&gt;getValue()!="")
  
  for ($row = $i;$row &lt;= 8 ;$row++) 
    {
  {
  $Chassis_Number =$excel-&gt;getActiveSheet()-&gt;getCell('A' .$i)-&gt;getValue();
  $Inducted =$excel-&gt;getActiveSheet()-&gt;getCell('B' .$i)-&gt;getValue();
  $Kit_Trolley =$excel-&gt;getActiveSheet()-&gt;getCell('C' .$i)-&gt;getValue();
  $cell = $excel-&gt;getActiveSheet()-&gt;getCell('D' . $i);  //Date Format change 
  $Kit_SM_Parts= $cell-&gt;getValue();
  if(PHPExcel_Shared_Date::isDateTime($cell)) {
       $Kit_SM_Parts = date($format = "d-M-Y", PHPExcel_Shared_Date::ExcelToPHP($Kit_SM_Parts)); 
  }
  else {$Kit_SM_Parts =$excel-&gt;getActiveSheet()-&gt;getCell('D' .$i)-&gt;getValue();}
  
  $Seats =$excel-&gt;getActiveSheet()-&gt;getCell('E' .$i)-&gt;getValue();
  $i++;
  
  }
  
  ?&gt;
  &lt;?php
  echo "&lt;table border=1 bgcolor='#00CCFF' cellpadding=0 cellspacing=0  style='border-collapse:
   collapse;table-layout:fixed ;width:721pt'   text-align'=justify'   ; &gt;";
  echo "&lt;td  height=15  align='center'   bgcolor='#003366' style='height:50.0pt'&gt;" .$Chassis_Number. "&lt;/td&gt;   ";
  echo $cnt;
  
  
  if ($Inducted == 'Yes' ||  $Inducted == 'Null' ){ echo "&lt;td bgcolor='#003366' align='center' ; &gt;Yes&lt;/td&gt;"; } else{echo "&lt;td bgcolor='#FF6600' align='center' &gt;Work in Progress&lt;/td&gt;";}  
  
  if ($Kit_Trolley == 'Yes' ||  $Kit_Trolley == 'Null' ){ echo "&lt;td bgcolor='#003366' align='center'&gt;Yes&lt;/td&gt;"; } else{echo "&lt;td bgcolor='#FF6600' align='center' &gt;Work in Progress&lt;/td&gt;";}
  
  if ($Kit_SM_Parts == 'Yes' ||  $Kit_SM_Parts == 'Null' ){ echo "&lt;td bgcolor='#003366' align='center' ; &gt;Yes&lt;/td&gt;"; } else{echo "&lt;td bgcolor='#FF6600'&gt;Work in Progress&lt;/td&gt;";}      
  
  if ($Seats == 'Yes' ||  $Seats == 'Null' ){ echo "&lt;td bgcolor='#003366' align='center';&gt;Yes&lt;/td&gt;"; } else{echo "&lt;td bgcolor='#FF6600' align='center'&gt;Work in Progress&lt;/td&gt;";}   
  echo "&lt;/table&gt;";
  } 
  
  ?&gt;
  
       &lt;/tr&gt;
          &lt;/table&gt;
  
        &lt;/div&gt;
      &lt;/div&gt;
     &lt;/div&gt;
    &lt;/section&gt;
  </code></pre>
  
  <p>Code mentioned above is the Fetch from the  Excel Sheet already  getting displayed for 7 Rows   </p>
  
  <p>But  I would like to  Show next  8 and So on till the End of the rows and Again repeat the  same with   first 8 </p>
  
  <p>there are no error so far </p>
  
  <p>Would like to Show set of  records /Rows Continuously -Automatically  changing after every set of  Rows</p>
  
  <h1>My Excel sheet date :</h1>
  
  <p>1 CHDWD250819001    Yes  Yes    Yes Yes</p>
  
  <p>2 CHDWD250819002    Yes         </p>
  
  <p>3 CHDWD250819003    Yes  Yes    Yes Yes</p>
  
  <p>4 CHDWD250819004    Yes  Yes    Yes Yes</p>
  
  <p>5 CHDWD250819005    Yes </p>