Deletes the Range object.
Name | Type | Description |
shift | string | Specifies how to shift cells to replace the deleted cells ("up", "left"). |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); oWorksheet.GetRange("B4").SetValue("1"); oWorksheet.GetRange("C4").SetValue("2"); oWorksheet.GetRange("D4").SetValue("3"); oWorksheet.GetRange("C5").SetValue("5"); var oRange = oWorksheet.GetRange("C4"); oRange.Delete("up"); builder.SaveFile("xlsx", "Delete.xlsx"); builder.CloseFile();