apps-script-samples icon indicating copy to clipboard operation
apps-script-samples copied to clipboard

Update spreadsheet_snippets.gs to include Sheets.newAppendCellsRequest() & update the range param definition

Open Yagisanatode opened this issue 9 months ago • 0 comments

Uses Sheets.newAppendCellsRequest() in request for the rows and sheet id. Updates the range parameter description to to the one found in the documentation. Updates the _values param to correct JSdoc format.

Description

  1. Includes the Sheets.newAppendCellsRequest() properties into the request. Previously they were not used in the script.
  2. Updates the range param definition to more clearly explain what the range is doing. Here, I copied the definition from the documentation. See
  3. Changes the list<string> param value to correct JSdoc format.

Fixes # (522)

Is it been tested?

  • [x] Development testing done

Checklist

  • [x] My code follows the style guidelines of this project
  • [x] I have performed a self-review of my own code
  • [ ] I have performed a peer-reviewed with team member(s)
  • [x] I have commented my code, particularly in hard-to-understand areas
  • [ ] I have made corresponding changes to the documentation
  • [x] My changes generate no new warnings
  • [ ] Any dependent changes have been merged and published in downstream modules

Yagisanatode avatar Feb 14 '25 08:02 Yagisanatode