This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I’m going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we’ve done a pretty good job hiding it since Excel 2007 by putting it on the Developer tab of the Ribbon.
Continued here:
Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 1
Watch this visual how-to video as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)
Here is the original post:
Video: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Explore the code in this visual how-to article as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)
Here is the original:
Sample: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0
Watch this video as you learn to create a BCS external content type for Office 2010 based on a Windows Communication Foundation (WCF) service.
The rest is here:
Video: Connecting to a WCF Service Using Business Connectivity Services in Office 2010
This is the twenty-sixth in a series of blog posts I’m doing on the VS 2010 and .NET 4 release.
Read more:
Debugging Tips with Visual Studio 2010
Watch this visual how-to video as you learn to build Office solutions that target both .NET Framework 3.5 and .NET Framework 4.
Read more here:
Video: Deploying an Office 2007 .NET 3.5 project and an Office 2010 NET 4.0 Project
Watch this visual how-to video as you learn to change the target version from .NET Framework 3.5 to .NET Framework 4.
Read more:
Video: Retargeting a Word 2007 Add-In that uses Smart Tags from .NET 3.5 to .NET 4.0
Watch this visual how-to video as you learn to use the strongly-typed classes in the Open XML SDK 2.0 to retrieve the value of a cell in an Excel 2007 or Excel 2010 document.
More:
Video: Retrieving the Values of Cells in Excel 2010 Workbooks by Using the Open XML SDK 2.0
To continue the theme of landing external data in Office 2010, I’ve taken a demo excerpt from a session I presented at a conference last week to show how easy it is to land OData information in an add-in. In this sample I simply use the Northwind Database which is a publicly available OData producer .
Original post:
Accessing an OData Producer using an Office 2010 Add-in
Today we published a few Office 2010 object model references on the MSDN Library: Access 2010 Developer Reference Excel 2010 Developer Reference Outlook 2010 Developer Reference Project 2010 Developer Reference Word 2010 Developer Reference These versions are currently the most up-to-date developer references for the corresponding Office 2010 client applications. Developer References for Office 2010 (APIs shared across Office client applications), PowerPoint 2010, Publisher 2010, and Visio 2010 will be forthcoming shortly.
Here is the original:
A Few Office 2010 Object Model References Live on MSDN!