Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Wednesday 3 September 2014

How to read data from excel file using php?

<?php
include 'reader.php';
$excel = new Spreadsheet_Excel_Reader();
?>
<table  border="1">
<?php
$excel->read('sample.xls');//set the excel file name here   
$x=1;
while($x<=$excel->sheets[0]['numRows']) { // reading row by row 
echo "\t<tr>\n";
$y=1;
while($y<=$excel->sheets[0]['numCols']) {// reading column by column 
$cell = isset($excel->sheets[0]['cells'][$x][$y])?$excel->sheets[0]['cells'][$x][$y] :'';
if($cell)
echo "\t\t<td>$cell</td>\n";  // get each cells values
$y++;
}  
echo "\t</tr>\n";
$x++;
}
?>    
</table><br/>