none
Adding External Relationships RRS feed

  • Question

  • Hi all,

    I'm fairly new to developing in office and I'm very new to the open office SDK. I'm attempting to use the SDK to add external relationships to an existing workbook. The reference doesn't provide any examples of how one might accomplish this. Can I add an external relationship to the workbook itself? Or does it need to be a specific drawing/worksheet/some other object? I'm just looking for some guidance as to how the AddExternalRelationship method is used and what has to be true of the spreadsheet for it to work without corrupting the file. 

    Thanks!

    Thursday, July 2, 2015 7:05 PM

Answers

  • Have you tried creating the link manually and then opening the workbook in the Open XML SDK Productivity Tool for Microsoft Office and look at the code it generates?

    The code it generates creates a new document, but does give you some ideas about how to amend a workbook.

    https://www.microsoft.com/en-au/download/details.aspx?id=5124

    Friday, July 3, 2015 12:50 AM