Need to read Office files using PHP? ShareOffice can help…
The free BadBlue PHP web server for Windows now includes the PHP ShareOffice library – with source code – that makes it easy to:
– read an entire Excel spreadsheet into an array in a single function call from a local or even a remote PC
– read an Access table or query in a single call from a local or a remote PC
– update an Excel spreadhseet cell with a single call on a local or a remote PC
– read a web page (even password-protected) in a single call
Free download and complete info at http://badblue.com/helpphpo.htm
Here’s an example of how easy it is to use:
// Read Excel workbook and grab data from cells A3 and D17...
//
$arrayExcelData = array();
$errmsg = SOExcel(
"127.0.0.1", "path3", "Invoices.xls", 1,
$arrayExcelData, "A1", "K35"
);
if (strlen($errmsg)) {
echo("SOExcel Error: ".$errmsg);
} else {
echo("Cell A3: ".$arrayExcelData["A3"]);
echo("Cell D17: ".$arrayExcelData["D17"]);
}
Free download and complete info at http://badblue.com/helpphpo.htm
