public void RemoveCells()
{
#region radspreadsheet-insert-delete_1
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();
CellRange range = new CellRange(1, 1, 10, 10);
CellSelection selection = worksheet.Cells[range];
if (selection.CanInsertOrRemove(range, ShiftType.Up))
{
selection.Remove(RemoveShiftType.Up);
}
#endregion
}
public void InsertCells()
{
#region radspreadprocessing-working-with-cells-insert-remove-cells_0
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();
CellRange range = new CellRange(1, 1, 10, 10);
CellSelection selection = worksheet.Cells[range];
if (selection.CanInsertOrRemove(range, ShiftType.Right))
{
selection.Insert(InsertShiftType.Right);
}
#endregion
}