November 2008 - Posts
Visual Basic 9.0 added many language features that allow us to write in the functional style in a natural and expressive way. The value of programming in the functional style has been apparent to me for some time. VB developers can realize the benefits
Read More...
[Blog Map] I recently posted some code that allows you to use LINQ to query Excel tables . The source for these queries is the Open XML document – you don’t need to involve the Excel application to query the data in these tables. In that post, I presented
Read More...
The ISO announced today the publication of the final text of ISO/IEC 29500, the Office Open XML specification. Doug Mahugh’s post on this has some relevant links regarding the process going forward. As those who have followed my blog know, I’ve had the
Read More...
[Blog Map] This post contains a detailed description of each of the PowerTools for Open XML cmdlets. For an overview and screen cast of PowerTools for Open XML, see Automated Processing of Open XML Documents using PowerShell . For more information on
Read More...
[Blog Map] Excel has a very cool feature where you can declare that a range of cells is a table. It is a feature that allows you to use Excel very much like a database. You can add new rows as necessary, sort the table by columns, do some simple filtering,
Read More...
[Blog Map] When writing queries, just as you sometimes want to skip the first n items in a collection, on occasion you want to skip the last n items. You could certain count the items remaining in the collection, and use the Take operator to take all
Read More...
The Enterprise Engineering Center (EEC) has put together a paper on running SharePoint on Hyper-V . It has a lot of great information, including links to required reading on Hyper-V, configuring and optimizing Hyper-V, key updates to install, and disk
Read More...
Monday evening, I’ll attend the ATE reception. Wednesday 11/12 at 13:30, I’ll be presenting OFC206 - Open XML SDK Version 2 Overview and Architecture. Attend this talk to see what the Open XML SDK makes possible. Thursday 11/13 at 9:00, I’ll be presenting
Read More...
[Blog Map] Debugging LINQ queries can be problematic. One of the reasons is that quite often, you write a large query as a single expression, and you can’t set a breakpoint mid-expression. Writing large queries in expression context is particularly powerful
Read More...
Here's a cool offer. SharePoint developers are most effective when developing on Windows Server 2008, but it costs money. When customers take any of three select Windows Server 2008 instructor-led training courses through a participating Microsoft Learning
Read More...
[Blog Map] A convenient way to explore Open XML markup is to create a small document, modify the document slightly in the Word user interface, save it, and then compare it with the Open XML Diff utility that comes with the Open XML SDK V2 . However, Word
Read More...
[Blog Map] (Update Feb 6, 2009 - The code to move/insert/delete paragraphs has been completed. This post introduces the code, and tells where to download the code from the PowerTools for Open XML project.) (Update March 24, 2009 - This post was updated
Read More...
