mirror of
https://github.com/sbroenne/mcp-server-excel.git
synced 2026-09-19 07:53:08 +08:00
Stefan Broenner
2a08a04a35
Complete refactoring of Power Query API with Phase 1 atomic operations, Phase 2 integrations, and comprehensive cleanup. **Phase 1 - Atomic Operations (6 methods):** - ✅ Create: Import + load in single atomic operation - ✅ UpdateMCode: Update M code without refresh - ✅ Unload: Convert to connection-only - ✅ UpdateAndRefresh: Update M code + refresh atomically - ✅ RefreshAll: Refresh all queries in one operation - ❌ ValidateSyntax: Removed (Excel COM doesn't support) **Phase 2 - Integration:** - ✅ MCP Server: All 6 Phase 1 actions functional - ✅ CLI: All 6 commands implemented - ✅ 25/25 integration tests passing (100% success rate) **Phase 3 - Documentation & Cleanup:** - ✅ All MCP prompts updated for Phase 1 consistency - ✅ Removed non-functional Errors action (COM API limitation) - ✅ 10 files cleaned across Core, MCP Server, and CLI layers **Quality Verification:** - ✅ All pre-commit checks passing (COM leaks, coverage, naming, success flags, smoke test) - ✅ Build passing (0 warnings, 0 errors) - ✅ 100% test success rate maintained - ✅ Coverage: 101.9% (154 Core methods → 157 enum values) **Breaking Changes:** - Removed ValidateSyntax action (never worked - Excel COM limitation) - Removed Errors action (returned hardcoded messages - COM doesn't expose error details) Ready for production use.
40 lines
2.3 KiB
XML
40 lines
2.3 KiB
XML
<Project>
|
|
<!-- Central Package Management for consistent versions across solution -->
|
|
<PropertyGroup>
|
|
<ManagePackageVersionsCentrally>true</ManagePackageVersionsCentrally>
|
|
<CentralPackageTransitivePinningEnabled>true</CentralPackageTransitivePinningEnabled>
|
|
</PropertyGroup>
|
|
<ItemGroup>
|
|
<!-- Analysis Services (TOM - Tabular Object Model) - Updated to non-deprecated packages -->
|
|
<!-- NOTE: Microsoft.AnalysisServices.NetCore.retail.amd64 is deprecated (retired mid-2024) -->
|
|
<!-- Migrated to Microsoft.AnalysisServices which is the new multi-runtime package -->
|
|
<PackageVersion Include="Microsoft.AnalysisServices" Version="19.106.1" />
|
|
<!-- UI Framework -->
|
|
<PackageVersion Include="Spectre.Console" Version="0.53.0" />
|
|
<!-- Microsoft Extensions for MCP Server -->
|
|
<PackageVersion Include="Microsoft.Extensions.Hosting" Version="9.0.10" />
|
|
<PackageVersion Include="Microsoft.Extensions.Logging" Version="9.0.10" />
|
|
<PackageVersion Include="Microsoft.Extensions.Configuration" Version="9.0.10" />
|
|
<PackageVersion Include="Microsoft.Extensions.DependencyInjection" Version="9.0.10" />
|
|
<PackageVersion Include="Microsoft.Extensions.ObjectPool" Version="9.0.10" />
|
|
<PackageVersion Include="System.Text.Json" Version="9.0.10" />
|
|
<!-- NuGet API Client -->
|
|
<PackageVersion Include="NuGet.Protocol" Version="6.12.1" />
|
|
<PackageVersion Include="NuGet.Versioning" Version="6.12.1" />
|
|
<!-- MCP (Model Context Protocol) -->
|
|
<!-- MCP SDK -->
|
|
<PackageVersion Include="ModelContextProtocol" Version="0.4.0-preview.2" />
|
|
<!-- Testing Framework -->
|
|
<PackageVersion Include="Microsoft.NET.Test.Sdk" Version="18.0.0" />
|
|
<PackageVersion Include="System.Net.Http" Version="4.3.5" />
|
|
<PackageVersion Include="System.Text.RegularExpressions" Version="4.3.2" />
|
|
<PackageVersion Include="xunit" Version="2.9.3" />
|
|
<PackageVersion Include="xunit.runner.visualstudio" Version="3.1.5" />
|
|
<PackageVersion Include="coverlet.collector" Version="6.1.0" />
|
|
<!-- Code Analysis and Security -->
|
|
<PackageVersion Include="Microsoft.CodeAnalysis.Analyzers" Version="3.3.5" />
|
|
<PackageVersion Include="Microsoft.CodeAnalysis.NetAnalyzers" Version="9.0.0" />
|
|
<PackageVersion Include="SecurityCodeScan.VS2019" Version="5.7.0" />
|
|
</ItemGroup>
|
|
</Project>
|