Oliver Bell’s Weblog » Blog Archive » Eric White has too much to say!

Fri, 24 Oct 2008 09:40:52 GMT

PingBack from http://osrin.net/2008/10/eric-white-has-too-much-to-say/

re: Eric White's Blog Map

krishnaramuu — Wed, 11 Mar 2009 15:58:10 GMT

Hi Eric,

I have gone through some of your blogs related to openxml and they really helped me alot to learn and use openxml concepts in my current project that i'm working on. I have few issues in coding to extract embedded objects like excel, ppt from word document using openxml, C# and linQ.

var runs = from l_run in paragraph.Runs

let l_run_styleNode = l_run

.Elements(w + "rPr")

.FirstOrDefault()

let l_run_inheritStyle = l_run

.Elements(w + "rPr")

.Elements(w + "rStyle")

.FirstOrDefault()

let l_run_graphics = l_run

.Elements(w + "drawing")

let l_run_Objects=l_run

.Elements(w + "object")

select new

{

Run = l_run,

RunType = l_run.Name.LocalName,

CssStyles = l_run_styleNode != null ? CreateCssProperties(l_run_styleNode.CreateReader()) : "",

CssClass = l_run_inheritStyle != null ? (string)l_run_inheritStyle.Attribute(w + "val") : "",

Text = l_run.Descendants(w + "t").StringConcatenate(element => (string)element),

BreakBefore = l_run.Element(w + "br") != null,

ExternalRelationId = (l_run.Name == w_hyperlink ? (string)l_run.Attribute(rels + "id") : ""),

Graphics = l_run_graphics,

Excels=l_run_Objects

};

.....

by using above query i could able to fetch the object from the document.xml file but retrieving the actual object from that is not working ... the code is here...

foreach (var run in runs)

{

var excels = from l_excels in run.Excels

let l_excels_oleobject = l_excels

.Descendants(a + "imagedata")

.Where(xlz => xlz.Attributes(rels + "id") != null)

.FirstOrDefault()

select new

{

XLExternalRelationId = l_excels_oleobject != null ? (object)l_excels_oleobject.Attributes(rels + "id") : ""

};

}

the above query didn't return any data from it...so can you plz guide me on this....

Thanks,

Ramakrishna

re: Eric White's Blog Map

krishnaramuu — Wed, 11 Mar 2009 15:59:39 GMT

XNamespace w = "http://schemas.openxmlformats.org/wordprocessingml/2006/main";

XNamespace rels = "http://schemas.openxmlformats.org/officeDocument/2006/relationships";

XNamespace a = "http://schemas.openxmlformats.org/drawingml/2006/main";

these are the namespaces i'm using....for the above post...