Delete banded range - Automate.ax

googleSheets.deleteBandedRange() removes an ordinary banded range and preserves every cell value in its range.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Remove report banding", () => {
  onDashboardRun({ title: "Remove report banding" })

  googleSheets.deleteBandedRange({
    spreadsheet: "spreadsheet-id",
    bandedRangeId: 184302910,
  })
})

Inputs

Provide spreadsheet and the integer bandedRangeId. You can obtain the ID from getSpreadsheet() or a banded-range action. Reference-only banded ranges can’t use this action. Second argument { account } selects the Google Account. This action removes formatting and preserves values. In contrast, deleteTable() also deletes cell contents.

Output

Returns the deleted banded range’s former ID, zero-based range, and row or column colors.