If you’ve ever needed to read Office files using PHP, ShareOffice (a free library that is bundled with BadBlue) lets you read Word, Excel and Access files into your PHP variables in a single function call. The ShareOffice library comes with all PHP source-code and can retrieve files on your local or remote PCs.
The new version of ShareOffice adds Word support. You can now perform the following functions with a single function call:
– Read an entire Word document into a string variable from a local or remote PC
– read an Excel spreadsheet into an array from a local or a remote PC
– read an Access table or query into an array from a local or a remote PC
– update an Excel spreadsheet 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 cells A1..K35 from an Excel workbook and
// display 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