Delete Range of Cells


#1

Is it possible to delete a range of cells from the template Excel sheet? If so, how are the cells shifted (left, up)?

Thanks!


#2

In the latest hofix, you can use the following approaches to delete a range of cells.

1.Use Cells.DeleteColumn method to delete cells in a column. Other cells on the right will be shifted left.

2. Use Cells.DeleteRow method to delete cells in a row. Other cells on the bottom will be shifted up.

3. Use Cells.ClearContents to clear contents of a range. No shift to other cells.

4. Use Cell.ClearRange to clear contents and formatting of a range. No shift to other cells.


#3

Is there an equivalent to selecting a range of cells in Excel and deleting it, having the cells either to the right or below shift up or left, respectively? Deleting an entire column is not really an option and neither is just clearing the cells.

Thanks for the prompt reply,
Fluid Media


#4

Now there isn’t such a method. We will add in the next release.


#5

Hi Fluid,

Now it’s available. Please download the latest hotfix and try Cells.DeleteRange method.