Hello, thank you in advance for your help.
I am having an issue using DeleteRange(). I currently have a spreadsheet where based on specific conditions, i want to delete a specific range of cells and shift the remaining cells left. This is done row by row. However, as i apply the deleteRange call, the cells are not deleting. Do i need to remove all data, formats, styles etc prior to using this method?
Here is the code:
getCells = commWorkbook.Worksheets[SheetPage2].Cells;
getCells.DeleteRange(IntRangeVal, 8, IntRangeVal, 9, shiftCellsLeft);
IntRangeVal = integer Value representing the row where cells are to be deleted
shiftCellsLeft = variable declared Globally as the following
tExcel.ShiftType shiftCellsLeft = tExcel.ShiftType.Left;
Where tExcel is declared as:
using tExcel = Aspose.Cells;
This message was posted using Aspose.Live 2 Forum