แชร์ผ่าน

dnrTV: Showing off the Open XML SDK and LINQ

  • บทความ

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!

Comments

  • Anonymous
    April 07, 2009
    The latest .NET Rocks! TV video includes an interview with Beth Massi where she shows how to use the

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

  • Anonymous
    August 21, 2009
    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

  • Anonymous
    August 21, 2009
    Hi Raj, I uploaded the code here: http://code.msdn.microsoft.com/openxmlvb Cheers, -B

  • Anonymous
    August 22, 2009
    Hi Beth, Thank you very very much for the quick response, really appreciate it very much. Thanks again. Raj

  • Anonymous
    April 16, 2013
    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