Maarten Balliauw's Blog: OpenXML in Healthcare in PHP

Mon, 29 Oct 2007 15:29:36 -0500

Maarten Balliauw points out a new blog post he's made today showing how to take the methods described in this article on the MSDN and convert it to a more PHP way of thinking, parsing the OpenXML info of the patients.

The scenario for the article is quite simple: Contoso provides a central medical records database. Whenever a physician has to register a new patient, he downloads a Word 2007 document from the Contoso server, fills it out, and uploads it back. Contoso then strips out the necessary data and saves it back in their systems.

This Word 2007 document is crafted around embedded custom XML data, which is displayed and edited using Word 2007. In short: to do the above exercise, you just need to strip out the custom XML and you're done.

Don't worry, Maarten includes his code and a demo to show the functionality in action. Check out the original article for more information as well.

Maarten Balliauw's Blog: Office 2007 SpreadsheetML classes in PHP

Fri, 15 Dec 2006 07:16:57 -0600

On the Zend Developer Zone today, there's a new post from Maarten Balliauw about a set of PHP classes he's created to work with Office 2007 SpreadsheetML documents (yay! another format!).

I finished my first goals (some basic XLSX writing), and I want to share this set of classes to the community. [...] Each cell supports the following data formats: string, number, formula, boolean. Visual formatting is not implemented, but I'll get to that later.

Features supported currently include the creation of the Spreadsheet object, adding worksheets, adding cells, and exporting the object to the Excel 2007 OpenXML format.

You can check out the project and the latest version over on his blog.

PHPDeveloper.org

Maarten Balliauw's Blog: OpenXML in Healthcare in PHP

Maarten Balliauw's Blog: Office 2007 SpreadsheetML classes in PHP