PHPBuilder - BadBlue adds PHP library for MS Office files



RSS Twitter
News Setup And Installation

BadBlue adds PHP library for MS Office files

by: Dave Minor
|
September 3, 2002

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

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Dave Minor

Comment:



Comment:

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