How to include the reference of DocumentFormat OpenXml dll on Mono2 10

Question

I am using C  net Windows Desktop Application I want to run these application with other platform also  So  i am using Mono 2 10 as a cross compiler While running unexpectedly my Application is terminated by saying the error message like    Error Could not open the selected folder  Could not load a file or assembly  DocumentFormat OpenXml dll version 2 0 5022 0  culture neutral  PublicKeyToken 31bf3856ad364e35  or one of its dependencies     I don t know what is problem here   I have installed openxml sdk2 0 on c  program files open xml sdk v2 lib DocumentFormat OpenXml dll   and also put my application eXe on on the same place for testing purpose     Please guide me to solve this issue

User · Answer

I found that when mixed with PCL libraries the above problem presented itself, and whilst it is true that the WindowsBase library contains System.IO.Packaging I was using the OpenXMLSDK-MOT 2.6.0.0 library which itself provides it's own copy of the physical System.IO.Packaging library. The reference that was missing for me could be found as follows in the csharp project

<Reference Include="System.IO.Packaging, Version=1.0.0.0, Culture=neutral, processorArchitecture=MSIL">
  <HintPath>..\..\..\..\packages\OpenXMLSDK-MOT.2.6.0.0\lib\System.IO.Packaging.dll</HintPath>
  <Private>True</Private>
</Reference>

I downgraded my version of the XMLSDK to 2.6 which then seemed to fix this problem up for me. But you can see there is a physical assembly System.IO.Packaging.dll

User · Answer

After viewing and changed the properties to DocumentFormat OpenXml  I also had to change the Specific Version to false

User · Answer

You should also ensure you set a reference to WindowsBase  This is required to use the SDK as it handles System IO Packaging  which is used for unzipping and opening the compressed  docx  xlsx  pptx as an OPC document

User · Answer

Being new to this myself  here s what I did   I m using MS Visual Studio 2010 Pro    Download and install the OpenXML SDK Within my project in Visual Studio  select  Project  then  Add Reference  Select the  Browse  tab In the  Look in   pull down  navigate to  C  Program Files x86  Open XML SDK V2 0 lib  and select the  DocumentFormat OpenXml dll Hit OK In the  Solution Explorer   on the right for me   the  References  folder now shows the DocumentFormat OpenXML library  Right-click on it and select Properties In the Properties panel  change  Copy Local  to  True     You should be off and running now using the DocumentFormat classes

User · Answer

What worked for me    Add a folder to the project call it ThirdParty  Add in the ThirdParty folder both DocumentFormat OpenXML dll and  WindowsBase dll Make sure the the project uses the ThirdParty dir as reference for both the DLLs  Build and published to an external server

User · Answer

You need to have DocumentFormat OpenXML dll in the same folder as your application - or in the  bin  path if you are developing an ASP NET application   However  I m not certain that the OpenXML SDK is supported on non-Windows operating systems - you may need to look into a third-party solution   Yes  this answer is right  the only difference is that you copy your  dll into bin folder of the project

User · Answer

The issue for me was that DocumentFormat OpenXml dll existed in the Global Assembly Cache  GAC  on my Win7 development box  So when publishing my project in VS2013  it found the file in the GAC and therefore omitted it from being copied to the publish folder   Solution  remove the DLL from the GAC    Open the GAC root in Windows Explorer  Win7   windir  Microsoft NET assembly  Search for OpenXml Delete any appropriate folders  or to be safe  cut them out to your desktop in case you should want to restore them    There may be a more proper way to remove a GAC file  below   but that is what I did and it worked  gacutil    u DocumentFormat OpenXml dll  Hope that helps

User · Answer

Well  In my applications I just need to Add a reference to  DocumentFormat OpenXml  under  Net tab and both references  DocumentFormat OpenXml and WindowsBase  are always added automatically  But They are not included within the Bin folder  So when the Application is published to an external server I always place DocumentFormat OpenXml dll under the Bin folder manually  Or set the reference  Copy Local  property to true

User · Answer

Goto Nuget Package manager and search for openxml  And install DocumentFormat OpenXml

User · Answer

select DocumentFormat OpenXml under references   view it s properties  and set the Copy Local option to True so that it copies it to the output folder  That worked for me

[c#] How to include the reference of DocumentFormat.OpenXml.dll on Mono2.10?

Examples related to c#

Examples related to mono

Examples related to openxml-sdk

Examples related to moma