<?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 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?
Subscribe to:
Comments (Atom)
Feet/Inches to Meters Converter & Lbs to Kgs Converter
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Feet/Inches ⇄...
-
<?php $to = "somebody@example.com, somebodyelse@example.com"; $subject = "HTML email"; $message = " <h...
-
document.onkeydown = myKeyDownHandler; function myKeyDownHandler(event){ alert(event.keyCode) }
-
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Feet/Inches ⇄...