Recent Posts

Open XML Developer workshop content

Over the last few months, Doug, Wouter, Brian and lots of other people delivered a series of OpenXML workshops around the globe. Those who were there, and those who weren't, can now download all content of these workshops from OpenXMLdeveloper.org. There are some interesting slideshows available for those of you who... Read more »

PHP zip:// and parse_url…

After having a few months of problems using PHP and fopen('zip://something.xlsx#xl/worksheets/sheet1.xml', 'r'), I finally found the reason of that exact line of code giving errors on some PC's... Assuming this uses a call to parse_url under the hood, I tried parsing this, resulting in the follo... Read more »

My job?

Seems that, according to <A href="http://en.wikipedia.org/wiki/Office_Open_XML" target=_blank mce_href="http://en.wikipedia.org/wiki/Office_Open_XML">this Wikipedia entry</A>, I work at <A href="http://www.microsoft.com/" target=_blank mce_href="http://www.microsoft.com/">Microsoft</A>: <I... Read more »

NHibernate 1.2.0 - Unexpected row count: 0; expected: 1

Great... I've been working with NHibernate and MySQL for a while now, without having any strange problems. For a project I'm working on, I'm using SqlClient instead of MySQL now, and strangeness occurs. When I try to Flush() a NHibernate session, here's what is thrown: Unexpected row count: 0; exp... Read more »

Enable sitemap security trimming in ASP.NET 2.0

Want to enable security trimming for your ASP.NET sitemap? Here's how... First of all, you need a new section in your web.config system.web element: [code:xml] <system.web>   <!-- ... other system.web configuration stuff ... -->   <siteMap defaultProvider="XmlSiteMapProvider&... Read more »

VSTS Project methodology

A quick linkdump of some VSTS project methodology templates: RUP - http://www.osellus.com/solutions/microsoft/rup-vsts_solutions.htmlScrum - http://www.scrumforteamsystem.comMacroscope - http://www.fujitsu.com/us/services/consulting/method/macroscope/index_p2.html  This is an imported post. It was importe... Read more »

Team Foundation Server - Subversion bridge

Here's the thing: for my private development work (a.k.a. PHPExcel 8-)), I've been using Subversion as my source-control server (and client). As the PHPExcel is hosted on CodePlex, one would suspect I would be using the Team Foundation hosted service which is provided for free. Not really... Here... Read more »

PHPExcel 1.3.5 released

Just a quick note on the new PHPExcel 1.3.5 release. There are some cool new features included! One of the new features is rich text: one can now write coloured and styled text in a cell. Here's an example of how the feature demo result file looks: This is of course not all. Jakub had a couple of sleepless nights, ... Read more »

ASP.NET URL rewrites using .htaccess-like syntax

Having a PHP background, I've been using .htaccess mod_rewrite in Apache for ages. ASP.NET allows rewriting too, but using a different syntax than mod_rewrite. Using the attached library, you can now use mod_rewrite syntax to perform rewrites on your ASP.NET application. Here's how... First of all, you ne... Read more »

Enlisting an ADO.NET command in an NHibernate transaction

For everyone who has read my article on NHibernate, here's a story for you... When building an application, everyone comes to a point where one needs to batch-update records in a database table, based on one or more criteria. Let's say, for example, there's a table "User" containing an activ... Read more »