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 }