using System.ComponentModel;
using System.Text.Json;
using ModelContextProtocol.Server;
using Sbroenne.ExcelMcp.Core.Commands;
namespace Sbroenne.ExcelMcp.McpServer.Tools;
/// <summary>
/// MCP tool for Excel conditional formatting operations.
/// </summary>
[McpServerToolType]
public static partial class ExcelConditionalFormatTool
{
/// <summary>
/// Conditional formatting - visual rules based on cell values.
/// TYPES: cell-value (requires operatorType+formula1), expression (formula only).
/// FORMAT: interiorColor/fontColor #RRGGBB, fontBold/Italic, borderStyle/Color.
/// </summary>
/// <param name="action">Action to perform</param>
/// <param name="excelPath">Excel file path (.xlsx or .xlsm)</param>
/// <param name="sessionId">Session ID from excel_file 'open' action</param>
/// <param name="sheetName">Worksheet name (required for add-rule and clear-rules actions)</param>
/// <param name="rangeAddress">Range address to apply conditional formatting (e.g., 'A1:D10', required for add-rule and clear-rules)</param>
/// <param name="ruleType">Rule type: 'cell-value' or 'expression' (required for add-rule)</param>
/// <param name="operatorType">Comparison operator: 'equal', 'not-equal', 'greater', 'less', 'greater-equal', 'less-equal', 'between', 'not-between' (required for cell-value rules)</param>
/// <param name="formula1">First formula/value for comparison (required for add-rule)</param>
/// <param name="formula2">Second formula/value (required for 'between' and 'not-between' operators)</param>
/// <param name="interiorColor">Interior fill color (#RRGGBB hex or color index, e.g., '#FF0000' for red)</param>
/// <param name="interiorPattern">Interior fill pattern: 'solid', 'gray75', 'gray50', 'gray25', 'horizontal', 'vertical', 'down', 'up', 'checker', 'semi-gray75', 'light-horizontal', 'light-vertical', 'light-down', 'light-up', 'grid', 'crisscross', 'gray16', 'gray8'</param>
/// <param name="fontColor">Font color (#RRGGBB hex or color index, e.g., '#0000FF' for blue)</param>
/// <param name="fontBold">Font bold (true/false)</param>
/// <param name="fontItalic">Font italic (true/false)</param>
/// <param name="borderStyle">Border line style: 'continuous', 'dash', 'dot', 'dash-dot', 'dash-dot-dot', 'slant-dash-dot', 'double'</param>
/// <param name="borderColor">Border color (#RRGGBB hex or color index, e.g., '#000000' for black)</param>
[McpServerTool(Name = "excel_conditionalformat", Title = "Excel Conditional Formatting")]
[McpMeta("category", "structure")]
[McpMeta("requiresSession", true)]
public static partial string ExcelConditionalFormat(
ConditionalFormatAction action,
string excelPath,
string sessionId,
[DefaultValue(null)] string? sheetName,
[DefaultValue(null)] string? rangeAddress,
[DefaultValue(null)] string? ruleType,
[DefaultValue(null)] string? operatorType,
[DefaultValue(null)] string? formula1,
[DefaultValue(null)] string? formula2,
[DefaultValue(null)] string? interiorColor,
[DefaultValue(null)] string? interiorPattern,
[DefaultValue(null)] string? fontColor,
[DefaultValue(null)] bool? fontBold,
[DefaultValue(null)] bool? fontItalic,
[DefaultValue(null)] string? borderStyle,
[DefaultValue(null)] string? borderColor)
{
return ExcelToolsBase.ExecuteToolAction(
"excel_conditionalformat",
action.ToActionString(),
excelPath,
() =>
{
var conditionalFormattingCommands = new ConditionalFormattingCommands();
// Switch directly on enum for compile-time exhaustiveness checking (CS8524)
return action switch
{
ConditionalFormatAction.AddRule => AddRuleAsync(
conditionalFormattingCommands, sessionId, sheetName, rangeAddress, ruleType, operatorType,
formula1, formula2, interiorColor, interiorPattern, fontColor, fontBold, fontItalic,
borderStyle, borderColor),
ConditionalFormatAction.ClearRules => ClearRulesAsync(
conditionalFormattingCommands, sessionId, sheetName, rangeAddress),
_ => throw new ArgumentException($"Unknown action: {action} ({action.ToActionString()})", nameof(action))
};
});
}
private static string AddRuleAsync(
ConditionalFormattingCommands commands,
string sessionId,
string? sheetName,
string? rangeAddress,
string? ruleType,
string? operatorType,
string? formula1,
string? formula2,
string? interiorColor,
string? interiorPattern,
string? fontColor,
bool? fontBold,
bool? fontItalic,
string? borderStyle,
string? borderColor)
{
// Validate required parameters
if (string.IsNullOrEmpty(sheetName))
throw new ArgumentException("sheetName is required for add-rule action", nameof(sheetName));
if (string.IsNullOrEmpty(rangeAddress))
throw new ArgumentException("rangeAddress is required for add-rule action", nameof(rangeAddress));
if (string.IsNullOrEmpty(ruleType))
throw new ArgumentException("ruleType is required for add-rule action", nameof(ruleType));
if (string.IsNullOrEmpty(formula1))
throw new ArgumentException("formula1 is required for add-rule action", nameof(formula1));
ExcelToolsBase.WithSession(
sessionId,
batch =>
{
commands.AddRule(
batch,
sheetName,
rangeAddress,
ruleType,
operatorType,
formula1,
formula2,
interiorColor,
interiorPattern,
fontColor,
fontBold,
fontItalic,
borderStyle,
borderColor);
return 0; // Dummy return value for WithSession
});
return JsonSerializer.Serialize(new
{
success = true,
message = "Conditional formatting rule added successfully"
}, ExcelToolsBase.JsonOptions);
}
private static string ClearRulesAsync(
ConditionalFormattingCommands commands,
string sessionId,
string? sheetName,
string? rangeAddress)
{
if (string.IsNullOrEmpty(sheetName))
throw new ArgumentException("sheetName is required for clear-rules action", nameof(sheetName));
if (string.IsNullOrEmpty(rangeAddress))
throw new ArgumentException("rangeAddress is required for clear-rules action", nameof(rangeAddress));
ExcelToolsBase.WithSession(
sessionId,
batch =>
{
commands.ClearRules(batch, sheetName, rangeAddress);
return 0; // Dummy return value for WithSession
});
return JsonSerializer.Serialize(new
{
success = true,
message = "All conditional formatting rules removed from range"
}, ExcelToolsBase.JsonOptions);
}
}
