dnrTV: Showing off the Open XML SDK and LINQ

dnrTV: Showing off the Open XML SDK and LINQ

  • Comments 6

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 parts so that you can query structured data from unstructured documents using Visual Basic’s LINQ to XML. What’s really cool about the Open XML format is that you don’t need Office installed at all – no COM Interop needed. You’re working with the file formats directly. And it’s super simple using VB’s XML literals and LINQ with the SDK.

Unfortunately I didn’t have a lot of time when I did the show with Carl and I couldn’t finish my demos. So this morning I filmed another quick episode that shows how to create documents from database data directly, so keep on the lookout for the follow up show :-).

dnrTV Show: Beth Massi on the Open XML SDK

And here are the links from the show:

[UPDATE: Here's code samples (also includes a presentation pptx)] 

Enjoy!

Leave a Comment
  • Please add 4 and 1 and type the answer here:
  • Post
  • The latest .NET Rocks! TV video includes an interview with Beth Massi where she shows how to use the

  • In the latest episode of CodeCast , Ken interviews me about my role on the Visual Studio Community Team.

  • Hi Beth,

    This was really very very useful for me as I am presently working on a project to read data from a word doc and dump it in to SQL server. can you please send me the complete code set? Thanks in advance.

    Raj

  • Hi Raj,

    I uploaded the code here: http://code.msdn.microsoft.com/openxmlvb

    Cheers,

    -B

  • Hi Beth,

    Thank you very very much for the quick response, really appreciate it very much. Thanks again.

    Raj

  • Dear All,

    I Am trying to read a word file and store it in the sql server database. my word file contains questions, different options and explanation . The main Issue is when i use chemical formula, all the subscript and superscript we just lost. I tried to replace that part with image but i am unable to get the image.

    Plz reply me on niraj.swt10@gmail.com  

Page 1 of 1 (6 items)