Error: Could not load file or assembly EPPlus with activity ConvertDataTableToXlsx

Ken Bergers

12 mai 2026 10:40 Modifié

Hi,

I run a simple server workflow that does the following:

1) Run SQL Query

2) Convert Data Table To XLSX. The Data Table out of the Run SQL Query activity is used as input here. 

Unfortunately I run into below error when the workfow is run. 

Failed to execute activity 15 with action gcx:wf:xlsx::ConvertDataTableToXlsx: Could not load file or assembly 'EPPlus, Version=4.5.3.3, Culture=neutral, PublicKeyToken=ea159fdaa78159a1'

Re-installing VertiGIS Studio Workflows hasn't solved the issue.
The output from the Run SQL Query activity is not corrupt as the workflow runs fine if the Data Table is converted to FeatureSet. 

I'm running VS Workflows v5.50.0 on-premise.

Any ideas on how I can fix this? 

0

• Commentaire officiel

  

  Ken Lyon

  12 mai 2026 15:32

  Short answer - try uninstalling and re-installing Workflow Server. Your data directory will not be lost during this process.

  Long version…

  In Workflow 5.49 we downgraded the version of EPPlus used by workflow. For some reason, this caused issues in the upgrade process. Normally, when you upgrade an installation of Workflow, the versions of dependencies are automatically changed to the versions in the new release.

  In this case, we have had a number of reports of this error from customers. Uninstalling and performing a fresh install of Workflow > 5.48 seems to eliminate the problem.
• 

  Bryan Price

  12 mai 2026 08:24

  I'm having the exact same issue with converting SQL Queries to excel using Workflow v5.50.0.

  A simple workflow will cause the error to occur. JSON Example below.

  {"_properties":{"isServerWorkflow":true},"components":[{"id":2,"steps":[{"id":3,"inputs":{},"position":"0,0","purpose":"start","title":"Start","transitions":[{"id":9,"position":"90,60 90,120","sourceConnector":"bottom","target":{"id":6},"targetConnector":"top"}]},{"action":"gcx:wf:server::SqlQuery","id":6,"inputs":{"commandText":"SELECT TOP (1000) * FROM <MY TABLE>","connectionString":"Server=<SERVER\\INSTANCE>; Database=<DATABASE>; User Id=<USER ID>; Password=<PASSWORD>; TrustServerCertificate=True;","providerName":"Microsoft SQL Server"},"name":"sqlQuery1","position":"-30,120","title":"Run SQL Query","transitions":[{"id":10,"position":"90,180 90,240","sourceConnector":"bottom","target":{"id":8},"targetConnector":"top"}]},{"action":"gcx:wf:core::ConvertDataTableToFeatureSet","id":8,"inputs":{"dataTable":{"accessors":["$sqlQuery1"],"annotations":[{"count":10,"index":0,"kind":"idref"}],"code":"$sqlQuery1.dataTable","source":"$sqlQuery1.dataTable"}},"name":"convertDataTableToFeatureSet1","position":"-30,240","title":"Convert Data Table To Feature Set","transitions":[{"id":22,"position":"90,300 90,360","sourceConnector":"bottom","target":{"id":13}}]},{"action":"gcx:wf:xlsx::ConvertDataTableToXlsx","description":"Export to Excel doesn't work","id":13,"inputs":{"dataTable":{"accessors":["$sqlQuery1"],"annotations":[{"count":10,"index":0,"kind":"idref"}],"code":"$sqlQuery1.dataTable","source":"$sqlQuery1.dataTable"}},"name":"convertDataTableToXlsx1","position":"-30,360","title":"Convert Data Table To XLSX","transitions":[{"id":19,"inputs":{},"position":"90,450 90,510","sourceConnector":"bottom","target":{"id":15}}]},{"action":"gcx:wf:server::CreateDownload","id":15,"inputs":{"content":{"accessors":["$convertDataTableToXlsx1"],"annotations":[{"count":24,"index":0,"kind":"idref"}],"code":"$convertDataTableToXlsx1.result","source":"$convertDataTableToXlsx1.result"},"contentType":"application/excel","filename":"Example.xlsx"},"name":"createDownload1","position":"-30,510","title":"Create Download","transitions":[{"id":21,"inputs":{},"position":"90,570 90,620","target":{"id":17}}]},{"action":"gcx:wf:core::SetWorkflowOutput","id":17,"inputs":{"name":"downloadUrl","value":{"accessors":["$createDownload1"],"annotations":[{"count":16,"index":0,"kind":"idref"}],"code":"$createDownload1.url","source":"$createDownload1.url"}},"position":"-30,620","title":"Set Workflow Output"}]}],"designerVersion":"5.50.0+14","licenseInfo":{"licenseUrl":"https://acura.kmc.nsw.gov.au/vertigisstudio/workflow/service/auth/license"},"start":{"id":3}}

  I think there must be a bug. 

  0
• 

  Nico Burgerhart

  12 mai 2026 10:28

  I think this is a problem with an underlying EPPlus spreadsheet library https://www.epplussoftware.com, would advice you to create a support request https://support.vertigis.com/hc/en-us/requests/new

  0
• 

  Bryan Price

  13 mai 2026 04:19

  Thanks Nico Burgerhart and Ken Lyon, The solution was to uninstall and then reinstall Vertigis Studio Workflow v5.50.0. Cheers, Bryan

  0

Vous devez vous connecter pour laisser un commentaire.