How can I solve the missing Office Reference when building on DevOps?

Asked Jul 27 '21 at 08:06

Active Jul 27 '21 at 08:06

Viewed 410 times

I'm trying to compile a c# project on azure DevOPS but I get this error on the Build Solution step of the pipeline:

##[error]AddColumnLSCT\MainWindow.xaml.cs(3,22): Error CS0234: The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

If I try to locally build the project it works correctly without any error or warnings. I've already added the Microsoft.Office.Interop.Excel as you can see in the attached image References, and the corresponding NuGet Package as you can see in this attached image NuGet Packages. How can i fix this?

asked Jul 27 '21 at 08:06

TemoZat

In your .csproj file, what is the path to the Microsoft.Office.Interop.Exce DLL? – Matthew Watson Jul 27 '21 at 08:21
I could not find the .dll relating to Microsoft.Office.Interop.Exce DLL in the .csproj file. I've only found these lines: `COMReference Include="Microsoft.Office.Core"> {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52} 2 8 0 primary False True ` – TemoZat Jul 27 '21 at 09:07
have you tried to remove this dependency and to re-add it pointing to nuget package? – Giovanni Esposito Jul 27 '21 at 10:45
@GiovanniEsposito how can I see if it point the nuget package or not? – TemoZat Jul 27 '21 at 12:51
@TemoZat I don't know but you should just select the dll in pkg folder – Giovanni Esposito Jul 27 '21 at 12:52
@GiovanniEsposito the packages folder actually is empty, anyway locally the project compiles correctly. – TemoZat Jul 27 '21 at 13:28

How can I solve the missing Office Reference when building on DevOps?

0 Answers0