using System.Reflection;
using Sbroenne.ExcelMcp.CLI.Commands;
using Sbroenne.ExcelMcp.CLI.Daemon;
using Sbroenne.ExcelMcp.CLI.Infrastructure;
using Sbroenne.ExcelMcp.Core.Models.Actions;
using Spectre.Console;
using Spectre.Console.Cli;
namespace Sbroenne.ExcelMcp.CLI;
internal sealed class Program
{
private static readonly string[] VersionFlags = ["--version", "-v"];
private static readonly string[] QuietFlags = ["--quiet", "-q"];
private static async Task<int> Main(string[] args)
{
Console.OutputEncoding = System.Text.Encoding.UTF8;
// Handle daemon run command before Spectre.Console
if (args.Length >= 2 && args[0] == "daemon" && args[1] == "run")
{
return await RunDaemonAsync();
}
// Determine if we should show the banner:
// - Not when --quiet/-q flag is passed
// - Not when output is redirected (piped to another process or file)
var isQuiet = args.Any(arg => QuietFlags.Contains(arg, StringComparer.OrdinalIgnoreCase));
var isPiped = Console.IsOutputRedirected;
var showBanner = !isQuiet && !isPiped;
// Remove --quiet/-q from args before passing to Spectre.Console.Cli
var filteredArgs = args.Where(arg => !QuietFlags.Contains(arg, StringComparer.OrdinalIgnoreCase)).ToArray();
if (filteredArgs.Length == 0)
{
if (showBanner) RenderHeader();
AnsiConsole.MarkupLine("[dim]No command supplied. Use [green]--help[/] for usage examples.[/]");
return 0;
}
if (filteredArgs.Any(arg => VersionFlags.Contains(arg, StringComparer.OrdinalIgnoreCase)))
{
return await HandleVersionAsync();
}
if (showBanner) RenderHeader();
var app = new CommandApp();
app.Configure(config =>
{
config.SetApplicationName("excelcli");
config.SetApplicationVersion(GetCurrentVersion());
config.SetExceptionHandler((ex, _) =>
{
AnsiConsole.MarkupLine($"[red]Unhandled error:[/] {ex.Message.EscapeMarkup()}");
});
// Daemon commands
config.AddBranch("daemon", branch =>
{
branch.SetDescription("Daemon management. The daemon holds Excel sessions across CLI invocations.");
branch.AddCommand<DaemonStartCommand>("start")
.WithDescription("Start the daemon in the background.");
branch.AddCommand<DaemonStopCommand>("stop")
.WithDescription("Stop the daemon.");
branch.AddCommand<DaemonStatusCommand>("status")
.WithDescription("Show daemon status and active sessions.");
});
// Session commands
config.AddBranch("session", branch =>
{
branch.SetDescription("Session management. WORKFLOW: open -> use sessionId -> close (--save to persist).");
branch.AddCommand<SessionCreateCommand>("create")
.WithDescription("Create a new Excel file, open it, and create a session.");
branch.AddCommand<SessionOpenCommand>("open")
.WithDescription("Open an Excel file and create a session.");
branch.AddCommand<SessionCloseCommand>("close")
.WithDescription("Close a session. Use --save to persist changes.");
branch.AddCommand<SessionListCommand>("list")
.WithDescription("List active sessions.");
branch.AddCommand<SessionSaveCommand>("save")
.WithDescription("Save a session without closing it.");
});
// Sheet commands
config.AddCommand<SheetCommand>("sheet")
.WithDescription(DescribeActions(
"Worksheet operations.",
ActionValidator.GetValidActions<WorksheetAction>()
.Concat(ActionValidator.GetValidActions<WorksheetStyleAction>())));
// Range commands
config.AddCommand<RangeCommand>("range")
.WithDescription(DescribeActions(
"Range operations.",
ActionValidator.GetValidActions<RangeAction>()
.Concat(ActionValidator.GetValidActions<RangeEditAction>())
.Concat(ActionValidator.GetValidActions<RangeFormatAction>())
.Concat(ActionValidator.GetValidActions<RangeLinkAction>())));
// Table commands
config.AddCommand<TableCommand>("table")
.WithDescription(DescribeActions(
"Table operations.",
ActionValidator.GetValidActions<TableAction>()));
// PowerQuery commands
config.AddCommand<PowerQueryCommand>("powerquery")
.WithDescription(DescribeActions(
"Power Query operations.",
ActionValidator.GetValidActions<PowerQueryAction>()));
// PivotTable commands
config.AddCommand<PivotTableCommand>("pivottable")
.WithDescription(DescribeActions(
"PivotTable operations.",
ActionValidator.GetValidActions<PivotTableAction>()));
// Chart commands
config.AddCommand<ChartCommand>("chart")
.WithDescription(DescribeActions(
"Chart operations.",
ActionValidator.GetValidActions<ChartAction>()));
// ChartConfig commands
config.AddCommand<ChartConfigCommand>("chartconfig")
.WithDescription(DescribeActions(
"Chart configuration.",
ActionValidator.GetValidActions<ChartConfigAction>()));
// Connection commands
config.AddCommand<ConnectionCommand>("connection")
.WithDescription(DescribeActions(
"Connection operations.",
ActionValidator.GetValidActions<ConnectionAction>()));
// Calculation mode commands
config.AddCommand<CalculationModeCommand>("calculationmode")
.WithDescription(DescribeActions(
"Calculation mode operations.",
ActionValidator.GetValidActions<CalculationModeAction>()));
// NamedRange commands
config.AddCommand<NamedRangeCommand>("namedrange")
.WithDescription(DescribeActions(
"Named range operations.",
ActionValidator.GetValidActions<NamedRangeAction>()));
// ConditionalFormat commands
config.AddCommand<ConditionalFormatCommand>("conditionalformat")
.WithDescription(DescribeActions(
"Conditional formatting.",
ActionValidator.GetValidActions<ConditionalFormatAction>()));
// VBA commands
config.AddCommand<VbaCommand>("vba")
.WithDescription(DescribeActions(
"VBA operations.",
ActionValidator.GetValidActions<VbaAction>()));
// DataModel commands
config.AddCommand<DataModelCommand>("datamodel")
.WithDescription(DescribeActions(
"Data Model operations.",
ActionValidator.GetValidActions<DataModelAction>()));
// DataModel relationship commands
config.AddCommand<DataModelRelCommand>("datamodelrel")
.WithDescription(DescribeActions(
"Data Model relationship operations.",
ActionValidator.GetValidActions<DataModelRelAction>()));
// Slicer commands
config.AddCommand<SlicerCommand>("slicer")
.WithDescription(DescribeActions(
"Slicer operations.",
ActionValidator.GetValidActions<SlicerAction>()));
});
try
{
return app.Run(filteredArgs);
}
catch (CommandRuntimeException ex)
{
AnsiConsole.MarkupLine($"[red]Command error:[/] {ex.Message.EscapeMarkup()}");
return -1;
}
catch (Exception ex)
{
AnsiConsole.MarkupLine($"[red]Fatal error:[/] {ex.Message.EscapeMarkup()}");
if (AnsiConsole.Profile.Capabilities.Ansi)
{
AnsiConsole.WriteException(ex, ExceptionFormats.ShortenEverything);
}
return -1;
}
}
private static async Task<int> RunDaemonAsync()
{
using var daemon = new ExcelDaemon();
// Handle Ctrl+C and process termination gracefully
Console.CancelKeyPress += (_, e) =>
{
e.Cancel = true; // Prevent immediate termination
daemon.RequestShutdown();
};
AppDomain.CurrentDomain.ProcessExit += (_, _) =>
{
daemon.RequestShutdown();
};
try
{
await daemon.RunAsync();
return 0;
}
catch (InvalidOperationException ex) when (ex.Message.Contains("already running"))
{
Console.Error.WriteLine("Daemon is already running.");
return 1;
}
catch (Exception ex)
{
Console.Error.WriteLine($"Daemon error: {ex.Message}");
return 1;
}
}
private static void RenderHeader()
{
AnsiConsole.Write(new FigletText("Excel CLI").Color(Spectre.Console.Color.Blue));
AnsiConsole.MarkupLine("[dim]Excel automation powered by ExcelMcp Core[/]");
AnsiConsole.MarkupLine("[yellow]Workflow:[/] [green]session open <file>[/] → run commands with [green]--session <id>[/] → [green]session close --save[/].");
AnsiConsole.MarkupLine("[dim]A background daemon manages sessions for performance.[/]");
AnsiConsole.WriteLine();
}
private static string DescribeActions(string baseDescription, IEnumerable<string> actions)
{
var actionList = string.Join(", ", actions);
return $"{baseDescription} Actions: {actionList}.";
}
private static async Task<int> HandleVersionAsync()
{
var currentVersion = GetCurrentVersion();
var latestVersion = await NuGetVersionChecker.GetLatestVersionAsync();
var updateAvailable = latestVersion != null && CompareVersions(currentVersion, latestVersion) < 0;
// Always show banner for version output
RenderHeader();
// Show friendly update message if available
if (updateAvailable)
{
AnsiConsole.MarkupLine($"[yellow]⚠ Update available:[/] [dim]{currentVersion}[/] → [green]{latestVersion}[/]");
AnsiConsole.MarkupLine($"[cyan]Run:[/] [white]dotnet tool update --global Sbroenne.ExcelMcp.CLI[/]");
AnsiConsole.MarkupLine($"[cyan]Release notes:[/] [blue]https://github.com/sbroenne/mcp-server-excel/releases/latest[/]");
}
else if (latestVersion != null)
{
AnsiConsole.MarkupLine($"[green]✓ You're running the latest version:[/] [white]{currentVersion}[/]");
}
else
{
AnsiConsole.MarkupLine($"[yellow]⚠ Could not check for updates[/]");
AnsiConsole.MarkupLine($"[dim]Current version: {currentVersion}[/]");
}
return 0;
}
private static string GetCurrentVersion()
{
var assembly = Assembly.GetExecutingAssembly();
var informational = assembly.GetCustomAttribute<AssemblyInformationalVersionAttribute>()?.InformationalVersion;
// Strip git hash suffix (e.g., "1.2.0+abc123" -> "1.2.0")
return informational?.Split('+')[0] ?? assembly.GetName().Version?.ToString() ?? "0.0.0";
}
private static int CompareVersions(string current, string latest)
{
if (Version.TryParse(current, out var currentVer) && Version.TryParse(latest, out var latestVer))
return currentVer.CompareTo(latestVer);
return string.Compare(current, latest, StringComparison.Ordinal);
}
}
