using Sbroenne.ExcelMcp.ComInterop;
using Sbroenne.ExcelMcp.ComInterop.Session;
using Sbroenne.ExcelMcp.Core.Models;
namespace Sbroenne.ExcelMcp.Core.Commands.Range;
/// <summary>
/// Range editing operations (clear, copy, insert/delete cells/rows/columns)
/// </summary>
public partial class RangeCommands
{
// === CLEAR OPERATIONS ===
/// <summary>
/// Clears all content (values, formulas, formats) from range
/// Excel COM: Range.Clear()
/// </summary>
public OperationResult ClearAll(IExcelBatch batch, string sheetName, string rangeAddress)
{
return ClearRange(batch, sheetName, rangeAddress, "clear-all", r => r.Clear());
}
/// <inheritdoc />
public OperationResult ClearContents(IExcelBatch batch, string sheetName, string rangeAddress)
{
return ClearRange(batch, sheetName, rangeAddress, "clear-contents", r => r.ClearContents());
}
/// <inheritdoc />
public OperationResult ClearFormats(IExcelBatch batch, string sheetName, string rangeAddress)
{
return ClearRange(batch, sheetName, rangeAddress, "clear-formats", r => r.ClearFormats());
}
// === COPY OPERATIONS ===
/// <inheritdoc />
public OperationResult Copy(IExcelBatch batch, string sourceSheet, string sourceRange, string targetSheet, string targetRange)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "copy" };
return batch.Execute((ctx, ct) =>
{
dynamic? srcRange = null;
dynamic? tgtRange = null;
try
{
srcRange = RangeHelpers.ResolveRange(ctx.Book, sourceSheet, sourceRange, out string? srcError);
if (srcRange == null)
{
throw new InvalidOperationException(srcError ?? RangeHelpers.GetResolveError(sourceSheet, sourceRange));
}
tgtRange = RangeHelpers.ResolveRange(ctx.Book, targetSheet, targetRange, out string? tgtError);
if (tgtRange == null)
{
throw new InvalidOperationException(tgtError ?? RangeHelpers.GetResolveError(targetSheet, targetRange));
}
srcRange.Copy(tgtRange);
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref srcRange);
ComUtilities.Release(ref tgtRange);
}
});
}
/// <inheritdoc />
public OperationResult CopyValues(IExcelBatch batch, string sourceSheet, string sourceRange, string targetSheet, string targetRange)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "copy-values" };
return batch.Execute((ctx, ct) =>
{
dynamic? srcRange = null;
dynamic? tgtRange = null;
try
{
srcRange = RangeHelpers.ResolveRange(ctx.Book, sourceSheet, sourceRange, out string? srcError);
if (srcRange == null)
{
throw new InvalidOperationException(srcError ?? RangeHelpers.GetResolveError(sourceSheet, sourceRange));
}
tgtRange = RangeHelpers.ResolveRange(ctx.Book, targetSheet, targetRange, out string? tgtError);
if (tgtRange == null)
{
throw new InvalidOperationException(tgtError ?? RangeHelpers.GetResolveError(targetSheet, targetRange));
}
srcRange.Copy();
tgtRange.PasteSpecial(-4163); // xlPasteValues
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref srcRange);
ComUtilities.Release(ref tgtRange);
}
});
}
/// <inheritdoc />
public OperationResult CopyFormulas(IExcelBatch batch, string sourceSheet, string sourceRange, string targetSheet, string targetRange)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "copy-formulas" };
return batch.Execute((ctx, ct) =>
{
dynamic? srcRange = null;
dynamic? tgtRange = null;
try
{
srcRange = RangeHelpers.ResolveRange(ctx.Book, sourceSheet, sourceRange, out string? srcError);
if (srcRange == null)
{
throw new InvalidOperationException(srcError ?? RangeHelpers.GetResolveError(sourceSheet, sourceRange));
}
tgtRange = RangeHelpers.ResolveRange(ctx.Book, targetSheet, targetRange, out string? tgtError);
if (tgtRange == null)
{
throw new InvalidOperationException(tgtError ?? RangeHelpers.GetResolveError(targetSheet, targetRange));
}
srcRange.Copy();
tgtRange.PasteSpecial(-4123); // xlPasteFormulas
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref srcRange);
ComUtilities.Release(ref tgtRange);
}
});
}
// === INSERT/DELETE OPERATIONS ===
/// <inheritdoc />
public OperationResult InsertCells(IExcelBatch batch, string sheetName, string rangeAddress, InsertShiftDirection shift)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "insert-cells" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
int shiftConst = shift == InsertShiftDirection.Down ? -4121 : -4161; // xlShiftDown : xlShiftToRight
range.Insert(shiftConst);
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref range);
}
});
}
/// <inheritdoc />
public OperationResult DeleteCells(IExcelBatch batch, string sheetName, string rangeAddress, DeleteShiftDirection shift)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "delete-cells" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
int shiftConst = shift == DeleteShiftDirection.Up ? -4162 : -4159; // xlShiftUp : xlShiftToLeft
range.Delete(shiftConst);
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref range);
}
});
}
/// <inheritdoc />
public OperationResult InsertRows(IExcelBatch batch, string sheetName, string rangeAddress)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "insert-rows" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
dynamic? rows = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
rows = range.EntireRow;
rows.Insert();
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref rows);
ComUtilities.Release(ref range);
}
});
}
/// <inheritdoc />
public OperationResult DeleteRows(IExcelBatch batch, string sheetName, string rangeAddress)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "delete-rows" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
dynamic? rows = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
rows = range.EntireRow;
rows.Delete();
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref rows);
ComUtilities.Release(ref range);
}
});
}
/// <inheritdoc />
public OperationResult InsertColumns(IExcelBatch batch, string sheetName, string rangeAddress)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "insert-columns" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
dynamic? columns = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
columns = range.EntireColumn;
columns.Insert();
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref columns);
ComUtilities.Release(ref range);
}
});
}
/// <inheritdoc />
public OperationResult DeleteColumns(IExcelBatch batch, string sheetName, string rangeAddress)
{
var result = new OperationResult { FilePath = batch.WorkbookPath, Action = "delete-columns" };
return batch.Execute((ctx, ct) =>
{
dynamic? range = null;
dynamic? columns = null;
try
{
range = RangeHelpers.ResolveRange(ctx.Book, sheetName, rangeAddress, out string? specificError);
if (range == null)
{
throw new InvalidOperationException(specificError ?? RangeHelpers.GetResolveError(sheetName, rangeAddress));
}
columns = range.EntireColumn;
columns.Delete();
result.Success = true;
return result;
}
finally
{
ComUtilities.Release(ref columns);
ComUtilities.Release(ref range);
}
});
}
// === FIND/REPLACE OPERATIONS ===
}
