Dienstag, 26. Februar 2013

E_ACCESSDENIED with Office Interop

Hi,
once upon a time, I had a nice little function which would open an Word-Document via Microsoft-Interop, export all bookmarks as a Dictionary<BookmarkName, StringBookmarkValue>, I would modify this dictionary and by pass it on to another little function, which would afterwards set all the values of the bookmarks. This worked very well until .... One day the server was upgraded to Windows 2012 and Office 2010 and since than nothing seemed to work any more.

After getting the following error:
System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
   at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
   at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
   at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)

...and spending roughly an our on the Internet I found following link: http://support.microsoft.com/kb/257757/en-us

Since non of the mentioned solutions worked for me in Word 2012 I decided to let Interop be and switch to OpenXML.... here you can read how to do the same function to replace bookmarks in OpenXML with the OpenXML SDK

Handling Bookmarks in OpenXML Word-Documents

Hi,

I needed to reimplement my function of exporting all bookmarks of a word-document into a dictionary and than setting them based on the changes in the dictionary from Word-Interop to OpenXML SDK.

I've found a very helpful answer on stackoverflow suggesting the following solution:

IDictionary<string, BookmarkStart> bookmarkMap = new Dictionary<string, BookmarkStart>();

foreach (BookmarkStart bookmarkStart in file.MainDocumentPart.RootElement.Descendants<BookmarkStart>())
{
    bookmarkMap[bookmarkStart.Name] = bookmarkStart;
}

foreach (BookmarkStart bookmarkStart in bookmarkMap.Values)
{
    Run bookmarkText = bookmarkStart.NextSibling<Run>();
    if (bookmarkText != null)
    {
        bookmarkText.GetFirstChild<Text>().Text = "blah";
    }
}

Seems very easy, right? It was a great starting point however only a starting point.

First thing I discovered...


There are HIDDEN bookmarks. This was weird in the beginning however you can see quickly the pattern, all of them start with an _ (underscore) and after finding this trustworthy page as the first answer from Google, to confirm if my assumption was correct, I didn't bother looking further, so just add

bookmarkStart.Name.StartsWith("_")

and the problem is solved.

Next Problem occurred...


You can define bookmarks for CELLs and than they behave totally different. So how do they behave? 
They are all stuck in the first cell of each row.
So how do I know to which cell they belong? Word seems to know it.
BookmarkStart has a property ColumnFirst. Normally the value is NULL, however in this case it has the 0-based index of the column it refers to. If your bookmarks stretch over multiple cells, there is also a ColumnLast (for my case ColumnFirst == ColumnLast).
However retrieving the data now is a bit tougher, so let's take a step back. First I created some Extension-Methods to  make my functions smaller:

public static T GetFirstDescendant<T>(this OpenXmlElement parent) where T : OpenXmlElement
{
    var descendants = parent.Descendants<T>();

    if (descendants != null)
        return descendants.FirstOrDefault();
    else
        return null;
}

public static T GetParent<T>(this OpenXmlElement child) where T : OpenXmlElement
{
    while (child != null)
    {
        child = child.Parent;

        if (child is T)
            return (T)child;
    }

    return null;
}

Now having those helpful methods let's start solving the actual problem.
First we need to add another condition.

if (bookmarkStart.ColumnFirst != null)
    return FindTextInColumn(bookmarkStart);

And actually implement FindTextInColumn

private Text FindTextInColumn(BookmarkStart bookmark)
{
    var cell = bookmark.GetParent<TableRow>().GetFirstChild<TableCell>();

    for (int i = 0; i < bookmark.ColumnFirst; i++)
    {
        cell = cell.NextSibling<TableCell>();
    }

    return cell.GetFirstDescendant<Text>();
}

As you can see, I'm looking for the Parent of type TableRow and take the first TableCell-child of this row. Afterwards I take the NextSibling of type TableCell until I reach the necessary column. Than I just need to return the first Text which can be found in this column. I myself don't really care how many texts exist, since I need only one to replace the content and keep the formatting. Later you will see that I delete additional Text-elements.

So, problem solved one more time. What else could there be?

While it's not a problem to read bookmark-values, it is one, when you are trying to set them:

Bookmarks can be empty - not having any element...


However once you figured out that the bookmark really is empty it is quite easy and straight forward to add a simple Run with a Text after the BookmarkStart, the following function takes care of this very easily:

private void InsertBookmarkText(BookmarkStart bookmark, string value)
{
    bookmark.Parent.InsertAfter(new Run(new Text(value)), bookmark);
}

This is solved very easily, however as I suggested, the problem is not to insert the value, but to figure out if it needs to be inserted. For this I present you the last problem I've found and solved for retrieving the values from bookmarks:

How to find Text and Run if they are not siblings of the bookmark as suggested by the initial solution?


For this, I expanded the simple search for Run from the initial solution into something more sophisticated. I don't know the specification of OpenXML-Documents so it might be unnecessary, but it provides also the information if the bookmark as such is empty.

First, here are 2 new helping Extension-Methods, I will use later on:

public static bool IsEndBookmark(this OpenXmlElement element, BookmarkStart startBookmark)
{
    return IsEndBookmark(element as BookmarkEnd, startBookmark);
}

public static bool IsEndBookmark(this BookmarkEnd endBookmark, BookmarkStart startBookmark)
{
    if (endBookmark == null)
        return false;

    return endBookmark.Id == startBookmark.Id;
}

And now the little magic...

var run = bookmarkStart.NextSibling<Run>();

if (run != null)
    // I've found a run and suppose it has a Text
    return run.GetFirstChild<Text>(); 
else
{
    // I will go through all the siblings and try to find any Text
    Text text = null;
    var nextSibling = bookmarkStart.NextSibling();
    while (text == null && nextSibling != null)
    {
        if (nextSibling.IsEndBookmark(bookmarkStart))
            // I've reached the end of the bookmark and couldn't find any Text
            return null;

        text = nextSibling.GetFirstDescendant<Text>();
        nextSibling = nextSibling.NextSibling();
    }

    return text;
}

Having this defined I managed to retrieve and replace correctly all bookmarks. We just forgot to solve the last issue - removing unnecessary Text-elements. In the following function, I want to remove all Text-elements within my bookmark except the parameter keep:

private void RemoveOtherTexts(BookmarkStart bookmark, Text keep)
{
    if (bookmark.ColumnFirst != null) return;

    Text text = null;
    var nextSibling = bookmark.NextSibling();
    while (text == null && nextSibling != null)
    {
        if (nextSibling.IsEndBookmark(bookmark))
            break;

        foreach (var item in nextSibling.Descendants<Text>())
        {
            if (item != keep)
                item.Remove();
        }
        nextSibling = nextSibling.NextSibling();
    }
}

Now all my problems are SOLVED :)
Hope it could help you as well, here you can find the whole code with all the functions, I used:

Montag, 7. Januar 2013

Problem Adding Ribbon-Control to Office AddIn Projects

ThisRibbonCollection' does not contain a definition for 'GetRibbon'....

If you see this error, don't panic, the solution is rather simple:
To make matters easier for you, Office AddIns have a partial class "ThisRibbonCollection" which is automatically used to define your Ribbon Control as the MainRibbonControl of the application. This might seem, after the creation and a first run rather as magic, unless of course, you want to have all your application controls in a separate folder and therefore separate namespace from ThisAddIn.cs. (thx for the hint to http://qa.social.msdn.microsoft.com/Forums/en-SG/vsto/thread/3b117e7a-e3d5-4f10-8262-358b04494230)

However there is also a solution to this, allowing you to keep your RibbonControl in a separated folder and namespace:
  1. Open <RibbonControl>Designer.cs
  2. Go to the end of the file where you see partial class ThisRibbonCollection
  3. Create at the end of the file a new namespace section, with the root-namespace of your AddIn
  4. Move the class into the new namespace
  5. Since you are in a different namespace now, don't forget to add the necessary usings
Happy Coding...