Browse by Tags

• Data
• DevCenter
• Visual Basic
• VS2008
• VSTO
• XML

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

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