The Office Integration Pack enables Visual Studio LightSwitch developers to work with data in Microsoft Office 2010. With this extension, users are able to create documents, spreadsheets, and PDFs; send Outlook appointments and emails; and move data to and from Excel.
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.
Three months ago Microsoft released the Outlook PST Specification documentation allowing developers to create server/desktop applications processing PST content without having to install Outlook. On May 24th, Microsoft announced two new open source projects, PST Data Structure View Tool and PST File Format SDK, making the creation of such applications even easier.
Microsoft has published the Outlook PST file format specification in order to "facilitate interoperability and enable customers and vendors to access the data in .pst files on a variety of platforms" as promised in October last year.
Visual Basic for Applications is a dead-end and Visual Studio for Applications isn’t ready for prime time, leaving developers in the uncomfortable position of trying to mix .NET code with legacy VBA macros. Fortunately Visual Studio Tools for Office makes it relatively painless.
Apache have released version 3.5 of the POI library for working with Microsoft Office documents. The latest version adds support for the OOXML format used by Office 2007 and higher. InfoQ spoke to Apache's Yegor Kozlov, release manager for POI 3.5, POI project founder Andrew Oliver, and Robert Duffner and Vijay Rajagopalan of Microsoft to find out more about the project.
A Texan judge has ordered Microsoft to stop selling MS Word in US because it infringes on a patent hold by i4i.
Microsoft wants to take Office 2010 to the web offering some lightweight Office applications running inside the browser.
MindTouch announces the ability to publish content from any Microsoft Desktop application to its collaborative industrial wiki. New user functionality includes: one-click publishing from any MS application and in-place editing of Microsoft Office. The new functionality is delivered as, Aurelia Reporter, Desktop Connector, and MS Word and MS Outlook connectors.
Microsoft has released significant updates for SQL Server 2008, including 2008 Service Pack 1, Express Edition Service Pack 1, large Feature Pack, Upgrade Advisor, SRS Report Builder 2.0, SharePoint integration, and data mining Office add-ins.
Ted Neward points us towards a solid piece by Bruce Wilson about increasing the power and usability of enterprise applications by using Microsoft Office as your client instead of a browser. And as Ted points out, this strategy can be a great option even if your backend is Java or any other Web Service aware platform.
Microsoft Office developers have long bragged about their ability to control pretty much anything in Office via COM automation. But unbeknownst to most, OpenOffice developers have a few tricks up their sleeve.
In a surprise announcement, SpringSource CEO Rod Johnson announced that SpringSource has agreed to be acquired by Microsoft. InfoQ interviewed Johnson to learn more about this acquisition and what it will mean for the future of both Spring and the .Net Framework.
Microsoft has announced that it will release the OOXML SDK despite the fact that ISO did not approve OOXML as an open standard last September.