Issue in reading config file

[sayali_gujarathi1 (sayali gujarathi)]

Hi All,

I am facing issue while reading config file in UiPath RE framework. I have added asset in that as well. but geeting below issue. can anyone assist?

Read range (Settings and Constants sheets): Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

[lrtetala (Lakshman Reddy)]

Hi @sayali_gujarathi1

Check on this

Error While Reading config File

@Chetan1809 We will use this “InitAllSettings.xaml” file in Init state to read config.xlsx file and then will store result in argument of type Dictionary and say ‘out_Config’ and specifying direction as ‘Out’. [image] And then we are storing this output argument value in ‘Config’ Variable and specifying scope as ‘General Business Process’ i.e. we can access this variable from any state in the process. [image] Now all config excel file values are stored in variable of type Dictionary and w…

I hope it helps!!

[Gokul001 (Gokul Balaji)]

HI @sayali_gujarathi1

Check out this thread

Cannot load assembly: ClosedXML.dll : System.IO.FileLoadException: Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0

For future references: The issue was withing the NuGet package OpenXmlPowerTools. Once removed I had no further issues (except the custom code wasn’t working) I fixed this by adding the dll of OpenXmlPowerTools directly to my custom NuGet package.

[mkankatala (Mahesh Kankatala)]

Hi @sayali_gujarathi1

1. Check UiPath Project Dependencies: Ensure that your UiPath project is using the correct version of the “DocumentFormat.OpenXml” assembly. You can verify this by checking the “Dependencies” of your UiPath project.a. In UiPath Studio, go to “Project” > “Manage Dependencies” to view the project dependencies. b. Look for the “DocumentFormat.OpenXml” entry in the list and make sure it matches the version (2.5.5631.0) mentioned in the error message.
2. Remove Duplicate Assemblies: Check your project and system for any duplicate or conflicting versions of the “DocumentFormat.OpenXml” assembly. Having multiple versions can lead to conflicts.a. In your UiPath project, ensure that there are no duplicate references to the “DocumentFormat.OpenXml” assembly. b. Check the packages installed in your project for any duplicate versions.
3. Clear NuGet Cache: Clear the NuGet cache to ensure that UiPath fetches the correct versions of the required assemblies.a. In UiPath Studio, go to “Tools” > “Options” > “NuGet” > “General.” b. Click on the “Clear Cache” button to clear the NuGet cache.

Hope it helps!!

[sayali_gujarathi1 (sayali gujarathi)]

Hi @lrtetala ,

I read this post but everything is correct while passing argument .
but Process is failing at initallsetting.xaml workflow. Its not moving ahead in next state.

[ushu (Usha kiranmai)]

Hi @sayali_gujarathi1 - can you try below points

→ Can you please try to upgrade or downgrade excel activities and see how that goes
→ Go to Tools > Repair Tools for Microsoft Office > Excel > Generate repair plan (check below screenshot)
→ Can you reading a sample excel file and see you’re getting the same issue

[lrtetala (Lakshman Reddy)]

@sayali_gujarathi1

Check UiPath Project Settings: Verify that the UiPath project settings, including the project.json file, are correctly configured with the appropriate dependencies.

[pravallikapaluri]

Hi @sayali_gujarathi1

1. Check the version of DocumentFormat.OpenXml referenced in your project:

• In UiPath Studio, go to the “Project Dependencies” panel (View tab > Project Dependencies).
• Look for DocumentFormat.OpenXml in the list and check its version.

2. Ensure that all dependencies and activities in your project are compatible with the version of DocumentFormat.OpenXml you have referenced.
3. Update the DocumentFormat.OpenXml package:

• If the version referenced in your project is outdated, consider updating the DocumentFormat.OpenXml package to a compatible version.

4. Check dependencies of your activities and libraries:

• If you are using custom libraries or activities that have dependencies on DocumentFormat.OpenXml, make sure they are compatible with the version you have in your project.

Hope it helps!!