Search... Ctrl + K

Clear Row (gsheets)
One script reply has been approved by the moderators Verified

Created by rossmccrann 127 days ago Used 38 times 1 Point

No comments yet

Points: 0
deno
One script reply has been approved by the moderators
Ap­pro­ved
import * as wmill from "https://deno.land/x/windmill@v1.24.1/mod.ts";

export async function main(gsheets_auth: wmill.Resource<"gsheets">,
    spreadsheetId: string,
    sheetId: number,
    start_index: number,
    end_index: number
) {

    const token = gsheets_auth["token"];

    const DELETE_ROWS_URL =
        `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}:batchUpdate`;

    const body = {
        "requests": [
            {
                "deleteDimension": {
                    "range": {
                        "sheetId": sheetId,
                        "dimension": "ROWS",
                        "startIndex": start_index,
                        "endIndex": end_index
                    }
                }
            },
        ],
    };
    const response = await fetch(DELETE_ROWS_URL, {
        method: "POST",
        body: JSON.stringify(body),
        headers: {
            Authorization: "Bearer " + token,
            "Content-Type": "application/json",
        },
    });
    const text = await response.json()

    return 'Rows deleted.';
}

Submitted by rossmccrann 127 days ago

Edited 127 days ago

No comments yet