Missing file error EPPlus, Version=4.1.1.0

[QuiltyGal]

Greetings, Am exporting 6100 records and all seems to go well until the tool tries to write to Excel. I get the following message:

** Exception Text ** System.IO.FileNotFoundException: Could not load file or assembly 'EPPlus, Version=4.1.1.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' or one of its dependencies. The system cannot find the file specified. File name: 'EPPlus, Version=4.1.1.0, Culture=neutral, PublicKeyToken=ea159fdaa78159a1' at Ryr.ExcelExport.ExcelExportPlugin.WriteToExcel(List1 headers, List1 rows, String fileName) at Ryr.ExcelExport.ExcelExportPlugin.<>c__DisplayClass14_0.b__0(BackgroundWorker w, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

and with this error is a list of loaded assemblies ( i have removed the version data but could provide if needed)

AndyPopkin.BulkDeleteTool

Anonymously Hosted DynamicMethods Assembly BulkAddressVerifier BulkAttachmentManagementPlugin Carfup.XTBPlugins.PersonalViewsMigration Colso.Xrm.DashboardTransferTool DamSim.SolutionTransferTool DamSim.ViewTransferTool DescriptionAndTags EPPlus GapConsulting.PowerBIOptionSetAssistant ICSharpCode.TextEditor ITLecChartGuy.AdvancedChartEditor Javista.XrmToolBox.ImportNN McTools.StopAdvertisement McTools.Xrm.Connection McTools.Xrm.Connection.WinForms MetadataViewProxies_8f5ffea6-942d-43fc-98db-9e68d09bb2eb Microsoft.Crm.Sdk.Proxy Microsoft.GeneratedCode Microsoft.IdentityModel Microsoft.IdentityModel.Clients.ActiveDirectory Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms Microsoft.VisualBasic Microsoft.Xrm.Sdk Microsoft.Xrm.Sdk.Deployment Microsoft.Xrm.Sdk.Workflow Microsoft.Xrm.Tooling.Connector Microsoft.Xrm.Tooling.CrmConnectControl Microsoft.Xrm.Tooling.Ui.Styles mscorlib MsCrmTools.AccessChecker MsCrmTools.AssemblyRecoveryTool MsCrmTools.AttributeBulkUpdater MscrmTools.AttributeUsageInspector MsCrmTools.AuditCenter MsCrmTools.ChartManager MscrmTools.CrmTraceReader MsCrmTools.DocumentTemplatesMover MsCrmTools.FetchXmlTester MsCrmTools.FlsBulkUpdater MsCrmTools.FormRelated MsCrmTools.Iconator MscrmTools.ManagedSolutionDeletionTool MsCrmTools.MetadataBrowser MsCrmTools.MetadataDocumentGenerator MscrmTools.PortalCodeEditor MscrmTools.PortalRecordsMover MsCrmTools.SampleTool MsCrmTools.ScriptsFinder MsCrmTools.SecurityRelated MsCrmTools.SiteMapEditor MsCrmTools.SolutionComponentsMover MsCrmTools.SolutionImport MscrmTools.SyncFilterManager MsCrmTools.SynchronousEventOrderEditor MsCrmTools.Translator MsCrmTools.UserSettingsUtility MsCrmTools.ViewLayoutReplicator MscrmTools.WebresourcesManager MsDyn.Contrib.CloneFieldDefinitions Newtonsoft.Json Norriq.XrmToolBox.Facilities Norriq.XrmToolBox.Facilities.Tooling Norriq.XrmToolBox.Facilities.Xrm Norriq.XrmToolBox.Facilities.Xrm.Tooling Norriq.XrmToolBox.YourEntityAttributeMappingsCustomized NuGet.Core NZ.XrmToolbox.PersonalArtefactManager Personalview PresentationCore PresentationFramework Rappen.XTB.FXB Ryr.ExcelExport SMDiagnostics System System.ComponentModel.Composition System.ComponentModel.DataAnnotations System.Configuration System.Core System.Data System.Data.Services.Client System.Deployment System.Design System.Drawing System.IdentityModel System.IdentityModel.Selectors System.IO.Compression.FileSystem System.Net.Http System.Runtime.Serialization System.Security System.ServiceModel System.ServiceModel.Channels System.ServiceModel.Internals System.Web System.Web.Services System.Windows.Forms System.Xaml System.Xml System.Xml.Linq Thrives.XrmToolBox.EntityUsage ViewRoleConfiguration WeifenLuo.WinFormsUI.Docking WeifenLuo.WinFormsUI.Docking.ThemeVS2015 WindowsBase XrmToolBox XrmToolBox.Extensibility XrmToolbox.JavascriptValidator XrmToolBox.PluginsStore

I am provided the option to Continue or Quit.
If I continue, i do not get an export file ad nothing else happens. This is the fetch, but I believe it is ok.

Thank you in advance for looking into this. QuiltyGal

[QuiltyGal]

Also, I have tried various batch size values but that has not helped.

[rajyraman]

Can you check on the XrmToolBox storage folder whether you have the EPPlus assembly?

[rajyraman]

I am not sure why it is missing as the assembly is definitely in the nuget package.

[AndreCavaca]

EPPlus Version 4.1.1.0 has a dependency on ole32.dll which is not deployed with the nuget package. A quickfix to this issue is to copy this dll from Windows folder. Actually in my windows folder there were many versions of this dll, I've used the one with 23.1KB:

Copy it and paste it in XrmToolBox plugin folder ~\Users\YourUser\AppData\Roaming\MscrmTools\XrmToolBox\Plugins and the error goes away.

The most recent version of EPPlus, which at the time I'm writing this is v4.5.3.2, no longer has this dependency.

[EHulburd]

I've just downloaded, and also having this issue. @AndreCavaca 's fix worked, but I also needed to restart XrmToolbox first.

[seanmcne]

Is there an intent to fix this bug?

[rajyraman]

Thank you for identifying the underlying issue @AndreCavaca. I have now updated EPPlus to the latest version. The licence of EPPlus has changed https://www.epplussoftware.com/Home/LgplToPolyform @seanmcne, @EHulburd.

I will push this to nuget later in the day.

[rajyraman]

You should be able to update the tool now.