Skip to content

Instantly share code, notes, and snippets.

@theredstapler

theredstapler/PHPExcel Tutorial - Download and read xlsx file.php

Created April 13, 2016 13:23
Show Gist options
  • Save theredstapler/23ea3c92dab40e4426a6553860f3c15b to your computer and use it in GitHub Desktop.
Save theredstapler/23ea3c92dab40e4426a6553860f3c15b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PHPExcel Tutorial - Download and read xlsx file.php
<!doctype>
<html>
<head>
</head>
<body>
<?php
require_once "Classes/PHPExcel.php";
//$tmpfname = "test.xlsx";
$url = "http://spreadsheetpage.com/downloads/xl/worksheet%20functions.xlsx";
$filecontent = file_get_contents($url);
$tmpfname = tempnam(sys_get_temp_dir(),"tmpxls");
file_put_contents($tmpfname,$filecontent);
$excelReader = PHPExcel_IOFactory::createReaderForFile($tmpfname);
$excelObj = $excelReader->load($tmpfname);
$worksheet = $excelObj->getSheet(0);
$lastRow = $worksheet->getHighestRow();
echo "<table>";
for ($row = 1; $row <= $lastRow; $row++) {
echo "<tr><td>";
echo $worksheet->getCell('A'.$row)->getValue();
echo "</td><td>";
echo $worksheet->getCell('B'.$row)->getValue();
echo "</td><tr>";
}
echo "</table>";
?>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment