<?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/>
Html, JAVA,DOTNET,Javascript, PHP, and JQuery Scripts and its issues with solutions
Showing posts with label read data excel. Show all posts
Showing posts with label read data excel. Show all posts
Wednesday, 3 September 2014
How to read data from excel file using php?
Subscribe to:
Posts (Atom)