I am having problems getting my C # build solution on my build server. Basically, we have a box with continuous integration in which Jenkins works. I have a job at Jenkins that uses MSBuild to create my solution. When trying to build, MSBuild reports unknown or missing build references.
error CS0234: The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) error CS0246: The type or namespace name 'Worksheet' could not be found (are you missing a using directive or an assembly reference?)
My solution has a function that uses some objects from Excel.
The question is, do I really need to install Microsoft Office so that my build server can just build the solution? The build server will not use my application, I just need to build it.
I read similar posts here in StackOverflow with the same problem, but there seem to be some conflicting answers saying, "Yes, you must have Office installed." While other answers say "No, you can just install PIA redistributable."
Examples :: Gallery What link do I need to use Microsoft.Office.Interop.Excel in .NET?
Microsoft.Office.Interop.Excel reference on the build server
Does the build machine need to install Microsoft Office 2007?
How to use Microsoft.Office.Interop.Excel on a computer without MS Office installed?
On the server, I looked at the download / installation process of the redistributable primary collectors of the second found here :: http://www.microsoft.com/en-us/download/details.aspx?id=3508
But that doesn't fix anything.
Of course, the solution actually works great on our development machines, because we all have Microsoft Office installed.
Of course, we don’t need to purchase another Microsoft Office license and install it on our build server to just build our solution, right? Or will we?
Thank you for reading.