ASPOSE :How to Remove a Cell in ASPOSE

Question

How to remove a specific cell from a row in aspose?

The equivalent method of RemoveCell() in NPOI

Answer 1

You may try to use Worksheet.Cells.DeleteRange() method to remove cell(s) accordingly, see the sample code below: e.g Sample code:

Workbook workbook = new Workbook("e:\\test2\\Book1.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
//Delete the range A1:N36 and shifts the cells upwards.
worksheet.Cells.DeleteRange(0, 0, 35, 13, ShiftType.Up);
workbook.Save("e:\\test2\\out1.xlsx");

I am working as Support developer/ Evangelist at Aspose