ExternalData is causing dotnet build to fail - cannot deploy to Azure DevOps

[alekstamatov]

SpecFlow Version

3.9.40

Which test runner are you using?

SpecFlow+ Runner

Test Runner Version Number

17.0.0

.NET Implementation

.NET Core 3.1

Project Format of the SpecFlow project

Classic project format using <PackageReference> tags

.feature.cs files are generated using

SpecFlow.Tools.MsBuild.Generation NuGet package

Test Execution Method

TFS/VSTS/Azure DevOps – Task – PLEASE SPECIFY THE NAME OF THE TASK

SpecFlow Section in app.config or content of specflow.json

No response

Issue Description

Hello,

I have a problem with deploying the project to Azure DevOps because of the ExternalData. On my local machine, VS can build the project and tests work fine.

But, when I try to build the project with the command dotnet build as it does on AzureDevops, it fails. Error that I get: Generation error: Message: Unable to load Excel file from pathToProject\Features\GetCompany.xlsx': Could not load file or assembly 'ExcelDataReader, Version=3.6.0.0, Culture=neutral, PublicKeyToken=93517dbe6a4012fa'. The system cannot find the file specified.

The same happens with CSV file, only it says CSVHelper instead of ExcelDataReader. I tried to install ExcelDataReader and nothing changed. I tried to manually copy ExcelDataReader.dll to my bin folder and then add it's dependency and still nothing changed.

Can you please help? This is a vital part of our tests, to be able to use Excel or CSV files for test data.

Steps to Reproduce

Add Excel file with test data to Features folder

In the feature file add @DataSource:GetCompany.xlsx

Try to build project with dotnet build

It fails

Link to Repro Project

No response

[bzhechkov]

Hello Folks, Any updates on this issue?

[SabotageAndi]

This is fixed with version 3.9.52.

[github-actions[bot]]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.