Excel MCP Server (uses Excel App, 100% Compatibility)

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <TargetFramework>net10.0-windows</TargetFramework>
    <UseWindowsForms>true</UseWindowsForms>
    <NoWarn>$(NoWarn);CS1591;CA1707</NoWarn>
    <LangVersion>latest</LangVersion>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
    <IsPackable>false</IsPackable>
    <IsTestProject>true</IsTestProject>

    <!-- Assembly and Namespace Configuration -->
    <AssemblyName>Sbroenne.ExcelMcp.McpServer.Tests</AssemblyName>
    <RootNamespace>Sbroenne.ExcelMcp.McpServer.Tests</RootNamespace>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="xunit" />
    <!-- Note: Microsoft.ApplicationInsights comes transitively from McpServer's WorkerService SDK -->
    <PackageReference Include="xunit.runner.visualstudio">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include="Microsoft.NET.Test.Sdk" />
    <PackageReference Include="Microsoft.CodeAnalysis.NetAnalyzers">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers</IncludeAssets>
    </PackageReference>
  </ItemGroup>

  <ItemGroup>
    <ProjectReference Include="..\..\src\ExcelMcp.McpServer\ExcelMcp.McpServer.csproj" />
    <ProjectReference Include="..\..\src\ExcelMcp.Core\ExcelMcp.Core.csproj" />
    <ProjectReference Include="..\..\src\ExcelMcp.CLI\ExcelMcp.CLI.csproj" />
  </ItemGroup>

  <!-- Golden files for API contract tests -->
  <ItemGroup>
    <None Include="TestData\**\*.json">
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
    </None>
  </ItemGroup>

  <!-- Copy CLI executable to test output for integration tests -->
  <!-- CLI is built by McpServer project (as dependency), we just copy the output -->
  <Target Name="CopyCliToTestOutput" AfterTargets="Build">
    <PropertyGroup>
      <CliOutputDir>$(MSBuildThisFileDirectory)..\..\src\ExcelMcp.CLI\bin\$(Configuration)\net10.0-windows\</CliOutputDir>
    </PropertyGroup>
    <ItemGroup>
      <CliFiles Include="$(CliOutputDir)excelcli.exe" />
      <CliFiles Include="$(CliOutputDir)excelcli.dll" />
      <CliFiles Include="$(CliOutputDir)excelcli.runtimeconfig.json" />
      <CliFiles Include="$(CliOutputDir)excelcli.deps.json" />
      <CliFiles Include="$(CliOutputDir)Spectre.Console*.dll" />
    </ItemGroup>
    <Copy SourceFiles="@(CliFiles)"
          DestinationFolder="$(OutputPath)"
          SkipUnchangedFiles="true"
          Condition="Exists('$(CliOutputDir)excelcli.exe')" />
    <Message Text="Copied CLI files to test output for integration tests" Importance="Normal" />
  </Target>

</Project>