When working with Excel documents, developers usually use raw XML or rely on the Office Automation libraries. But the Office Automation library is not appropriate for servers and working with XML can be quite tedious. ClosedXML bridges the gap by providing an easy to use Office-like API without the overhead of COM. To introduce this library we spoke with Manuel De Leon of the ClosedXML project.
Open XML SDK 2.0 offers a moderately high level API for manipulating Open XML documents using strongly typed classes. It includes the Open XML SDK v2.0 Productivity Tool, which can reverse engineer a Word, PowerPoint, or Excel document and display the C# code needed to recreate it.
The growth of Open APIs both in numbers and volume has surpassed any expectations over the last decade. John Musser from the ProgrammableWeb presented his analysis of the Open APIs State of the Market for 2011.
The WCF Data Services Team have recently been doing a series on the available authentication mechanisms for client/OData service authentication.
On Wednesday, the Apache Foundation announced the release of Apache FOP 1.0, a project that has been a decade in the making. Apache FOP, or Formatting Objects Processor, provides a means to turn XML documents into a variety of print-ready formats, such as PDF, PostScript, or even PNG
The Open Data Protocol (OData) specification opens up possibilities to a lot of interesting collaborative use-cases and scenarios. Some of which are highlighted by Douglas Purdy, Pablo Castro and Jon Udell.
IBM have released a feature pack which adds support for Xpath 2.0, XSLT 2.0 and XQuery 1.0 making WebSphere Application Server 7 the first application server with complete support for this most recent set of W3C XML standards. InfoQ talks IBM's Andrew Spyker, Chief Architect for the feature pack.
The final release of JRuby 1.4 is now available, with many performance, Java integration and other improvements. It also adds a native launcher for Windows, which works around some problems with the BAT-based launcher. Also: the Hpricot 0.8.2 release fixes problems with Hpricot on JRuby.
Duncan Cragg explains his idea/pattern for a purely GET based REST integration pattern, which turns out to be very similar to the vision of Microsoft's FeedSync Specification.
With the sudden disappearance of _why, some popular libraries as Markaby, Hpricot and others are orphaned. We look at the effort to find maintainers for some, and at replacements for other libraries.
Christian Weyer of Thinktecture, announced the release of WSCF.blue a Visual Studio Add-in that enables contract first development of web services using WCF.
LINQ to XSD is the long awaited follow-up to LINQ to XML. Its primary purpose is to produce LINQ-compatible object models from XSD files, giving developers some measure of static type checking while accessing XML data.
In this session recorded at QCon SF 2008, Chris Berry & Bryon Jacob presented the Atom Syndication Format, the Atom Publishing Protocol, the Atom Categories, the Atom Stores, the AtomServer and how they can be used by giving a concrete example.
JRuby 1.3 will allow to reduce startup times in some situations using Nailgun. Nokogiri, a popular XML library, now runs on the latest JRuby thanks to ruby-ffi. Finally: Ruby 1.9.1-p129 is a new release that fixes a few bugs and security issues.