The file formats used by Microsoft Word, Excel, and PowerPoint have been fully opened source via the latest release of Microsoft's OpenXML SDK. This provides developers with the familiar Apache 2.0 License, providing an easier path to incorporating support for these documents into their own projects.
Microsoft recently announced the initial release of the OneNote API, which enables programmatic integration of its free-form information gathering and multi-user collaboration tool across different programming languages and platforms like Windows, Windows Phone, iOS, Mac OS, Android and the web.
Appcelerator, maker of the Titanium Mobile Development Environment, has recently announced Appcelerator Insights as part of its Appcelerator Analytics product.Insights promises to deliver real-time aggregated analytics aiming at measuring higher-level metrics like user acquisition and retention, engagement, and app performance.
Microsoft in collaboration with Google has recently released an app for Android based phone for users with a valid Office 365 subscription.
Microsoft updated several tools for developers targeting SQL Server, SharePoint, and Office. The Business Intelligence tools support analysis, integration, and reporting for SQL Server. The Office/SharePoint tools suite bring support for the 2013 versions of each and .NET Framework 4.5.
Few months back, Microsoft announced HDInsight, Microsoft’s Hadoop distribution for managing, analysing and making sense out of large volumes of data. InfoQ connected with Val Fontama, Senior Product Marketing Manager for SQL Server, to know more about how the Enterprise Big Data @ Microsoft story is panning out.
The addition of the app store to Office and SharePoint 2013 provides new opportunities for both users and developers. These new features provide greater awareness for Internet data sources and bring customization to users.
OpenXML SDK 2.0 for MS Office provides strongly typed part classes to manipulate Open XML documents. WorddocGenerator, an open source utility for generating template driven word files is one example of what can be done with this SDK. InfoQ got in touch with Atul Verma the developer of this utility to ask him a few questions about this project.
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.