.NET4Office

A developer on my team was recently trying to set the contents of a small column of excel cells to an array of values. This is a desirable thing to do—if you are setting a range of values in Excel, it is much better to create an array and make one...

VSTO 2.0 has a feature that allows you to embed any WinForms control you want into an Excel spreadsheet or Word document. This lets you use lots of powerful WinForms controls in your Office solution. When you add a managed control to your document (by...

Have you ever looked at the Excel PIA “Microsoft.Office.Interop.Excel” using the object browser in Visual Studio and just been blown away and confused by what you see there? For example, consider what .NET Interop does to the simple...

When you look at the Excel PIA in the object browser in Visual Studio, you will quickly notice what appears to be method centric name calling: a slew of methods with the text “Dummy” in them. There's even an interface called IDummy (implement...

You may be aware that there isn't documentation available right now for the Office PIA's (Microsoft.Office.Interop.Word.dll, Microsoft.Office.Interop.Excel.dll, and Microsoft.Office.Core.dll). There will be official Microsoft documentation available at...

Hi all. I'm spending the weekend doing some Outlook managed add-in stuff, so I decided to generate some wiki pages on OfficeWiki.NET for the Outlook PIAs to help me in that effort. I also updated the other wiki pages for Word and Excel and Core to...

Paul Cornell blogs about the VSTO 2.0 Data Story including lots of pretty pictures . Tasty! All that's missing is a this.List1.DataBodyRange.Columns.AutoFit(); -- that would make the columns in the last picture size to fit the contents. Also, in...

There are a bunch of people going down to Tech-Ed from my team. I was originally going to be one of them, but things have gotten too busy trying to get VSTO 2.0 shipped, and I got bumped from the list because of my responsibilities here at work. Waaah...

There's another live webcast by Kathleen McGrath on VSTO 2.0 and Word this Wednesday. This is the same content as the one I blogged about earlier and that Chris Kunicki blogged about . If you didn't catch the first live webcast, check this one out...