Forum Discussion

MarcusH's avatar
MarcusH
Valued Contributor
3 years ago

Re: Create Excel spreadsheet from Business Rules

Thank you so much for that. I will test it next week and post an update.

4 Replies

  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    3 years ago

    Also add these references in your BR

    C:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\bin\DocumentFormat.OpenXml.dll; C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.0\WindowsBase.dll

     

    • MarcusH's avatar
      MarcusH
      Valued Contributor
      3 years ago

      Works really well. Thank you for sharing your code.

    • Sridhar_M's avatar
      Sridhar_M
      Contributor
      2 years ago

      We're upgrading to OneStream version 8.2.2 and encountering issues with code compilation due to changes in .NET 8. I've managed to fix many errors by updating the Open XML DLL path to:

      C:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\DocumentFormat.OpenXml.dll

      However, I'm still facing the following error:

      "Reference required to assembly 'System.IO.Packaging, Version=4.0.5.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' containing the type 'Package'. Add one to your project."

      Has anyone found a solution to this problem?

    • Sridhar_M's avatar
      Sridhar_M
      Contributor
      2 years ago

      Never mind, I found the System.IO.Packaging.dll at this location, which resolved all the problems:

      C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App\8.0.7\System.IO.Packaging.dll