Breaking Changes in the Open XML SDK v2 April 2009 CTP

Breaking Changes in the Open XML SDK v2 April 2009 CTP | ASP NET Hosting

Breaking Changes in the Open XML SDK v2 April 2009 CTP | ASP NET Hosting — Tue, 19 May 2009 19:56:29 GMT

PingBack from http://asp-net-hosting.simplynetdev.com/breaking-changes-in-the-open-xml-sdk-v2-april-2009-ctp/

re: Breaking Changes in the Open XML SDK v2 April 2009 CTP

asklein — Mon, 25 May 2009 20:46:04 GMT

Brian,

I am struggling to find a solution to an issue that I am having that is relevant to your blogs. I am trying to to get a cells background color value. This is not at all straight forward and a sample code would go a long way. I don't understand how to access this information? Is this embedded in the sytles.xml and somehow this has a per-cell relation to the cell of interest? Your expertise on shedding some light on this issue would be so great.

Many thanks,

Adam

re: Breaking Changes in the Open XML SDK v2 April 2009 CTP

Zeyad Rajabi — Tue, 26 May 2009 21:52:19 GMT

Adam,

Are you interested in figuring out the cell background color for Excel or Word files?

re: Breaking Changes in the Open XML SDK v2 April 2009 CTP

Angel Rodriguez — Wed, 27 May 2009 15:09:06 GMT

Fine Thanks,

But a get NullPointerException with,

SdtBlock sdt = mainPart.Document.Descendants<SdtBlock>()

.Where(s =>

s.GetFirstChild<SdtProperties>().GetFirstChild<Alias>().Val.Value

.Equals(sdtName)).First();

I maked my self method

private static SdtBlock GetSdtBlock(OpenXmlElement row, string tagName) {

IEnumerable<SdtBlock> sdtBlocks = row.Descendants<SdtBlock>();

foreach (SdtBlock sdtBlock in sdtBlocks) {

IEnumerable<SdtProperties> sdtProperties = sdtBlock.Descendants<SdtProperties>();

foreach (SdtProperties sdtProperty in sdtProperties) {

IEnumerable<Tag> tags = sdtProperty.Descendants<Tag>();

foreach (Tag tag in tags) {

if (tag.Val.Value == tagName) {

return sdtBlock;

}

return null;

}

re: Breaking Changes in the Open XML SDK v2 April 2009 CTP

Zeyad Rajabi — Thu, 28 May 2009 00:58:52 GMT

As you noted in your code sample, you get the null exception if you have a content control that doesn't have the specified child element. You can workaround this issue by checking to see if the child element is null. If not, then you can check it's children.