Browse by Tags

• ADO.NET Data Services
• Article
• Community
• Data
• DevCenter
• Entity Framework
• LINQ
• OBA
• SharePoint
• Speaking
• Visual Basic
• VS2008
• VSTO
• WPF

Merging Text & Photos into a Word Document using Open XML SDK
24 September 09 02:55 PM

Yesterday I posted about how we could create a letter generator (mail merge) that took data from a database to create a Word 2007 document using the System.IO.Packaging class. I showed how to take data from Northwind using a single LINQ query to create Read More...

Postedby Beth Massi | 0 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, VSTO

Mail Merging Into a Single Word Document Using XML Literals
23 September 09 04:18 PM

With the release of Microsoft Office 2007 we can work with a much simpler, standard, XML format called Open XML which opens the door for many types of applications that cannot work via COM. What if you needed to build a scalable web service that processes Read More...

Postedby Beth Massi | 5 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

DevProConnections Article: Taking Advantage of LINQ and XML in Microsoft Office 2007
17 August 09 10:05 AM

This month I have an article on DevProConnections: Taking Advantage of LINQ and XML in Microsoft Office 2007 In this article, I talk about how a lot of applications that need to take advantage of Microsoft Office can do so without going through COM. Many Read More...

Postedby Beth Massi | 0 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

Using Windows Presentation Foundation in Office Clients
10 August 09 05:31 PM

I was cleaning up my desk today and in the piles of mail and gobs of paper I found the SDN Magazine “Women in Technology” issue 101 that featured an article I wrote that was released in print back in May. Well, I just noticed today that near the end of Read More...

Postedby Beth Massi | 5 Comments    

Filed under: WPF, VS2008, DevCenter, Article, XML, Office, ADO.NET Data Services, VSTO, OBA

dnrTV: Showing off the Open XML SDK and LINQ
07 April 09 03:05 PM

Yesterday Carl posted another dnrTV show with yours truly . This time I’m talking about the Open XML SDK , something that I’ve written and spoken about many times . In this episode I show how to use Word 2007 content controls and map them to custom XML Read More...

Postedby Beth Massi | 5 Comments    

Filed under: Visual Basic, VS2008, Community, DevCenter, XML, Office, VSTO

OBA Part 3 - Storing and Reading Data in Word Documents
12 February 09 05:55 PM

In my last few posts we've been building a simple Office Business Application (OBA) for the new Northwind Traders. If you missed them: OBA Part 1 - Exposing Line-of-Business Data OBA Part 2 - Building and Outlook Client against LOB Data In this post I'm Read More...

Postedby Beth Massi | 6 Comments    

Filed under: Visual Basic, VS2008, DevCenter, Article, XML, Office, Data, ADO.NET Data Services, SharePoint, OBA

First Day at SDN Conference
07 October 08 03:28 AM

I'm here in the Netherlands in a town called Noordwijkerhout near Amsterdam at the SDN Conference with a lot of great speakers and sessions . I took these shots while the attendees were in session. There's good food, great vendors and lots of entertainment Read More...

Postedby Beth Massi | 4 Comments    

Filed under: Visual Basic, Speaking, LINQ, Community, DevCenter, XML, Office, Entity Framework

Attachment(s):SDCDay1.zip

Comparing Two Open XML Packages with Open XML Diff
31 July 08 04:18 PM

Yesterday I received an email from another employee here at Microsoft to check out this tool called Open XML Diff that he was working on. His name is Pranav Wagh and he just released another drop of the tool which you can read about oh his blog . You Read More...

Postedby Beth Massi | 2 Comments    

Filed under: Community, XML, Office

Accessing Open XML Document Parts with the Open XML SDK
30 July 08 07:30 PM

About a month ago the Open XML SDK 1.0 (June 08 update) was released . The SDK provides strongly typed document part access to Word 2007, Excel 2007 and PowerPoint 2007 documents. The SDK has been a CTP for a while, but last month version 1.0 was finally Read More...

Postedby Beth Massi | 4 Comments    

Filed under: Visual Basic, LINQ, DevCenter, Article, XML, Office

Mail Merging with Word, LINQ and XML Literals in VB
06 December 07 05:50 PM

I've mentioned before that you can use XML literals in VB 9 to do text merging so I figured it should be pretty easy to do some mail merging in Word the same way. Word 2007 (and Excel, etc) now uses a standard XML format called Office Open XML to describe Read More...

Postedby Beth Massi | 20 Comments    

Filed under: Visual Basic, LINQ, DevCenter, Article, XML, Office

Attachment(s):WordMailMerge.zip

Quickly Import and Export Excel Data with LINQ to XML
30 October 07 08:00 PM

One really handy thing to do with relational data is to import and export it to Excel. This can be a total snap using LINQ to XML in Visual Basic 2008. For example, let's say I want to import data from an Excel spreadsheet into a local database file like Read More...

Postedby Beth Massi | 69 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, Data

Attachment(s):ImportExportExcel.zip