PHP ShareOffice library for Excel and Access

by: Dave Minor

July 1, 2002

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

Comment and Contribute

0 Comments (click to add your comment)

Your comment has been submitted and is pending approval.

Author:

Dave Minor

Comment:

Name/nickname:
Email:

Comment:

(Maximum characters: 1200). You have characters left.