node-google-spreadsheet

node-google-spreadsheet copied to clipboard

I am able to successfully use the library under the NodeJS environment and works very well. But I do have a use-case where I would like pure-browser access to google...

rrrepos

Passing Empty String as value causes addRow to overwrite row 1

4

I have a spreadsheet with a protected **first row** (1:1 range), which contains the header values I reference in dot notation when adding rows to my spreadsheet. I discovered today...

jwhiteaei

Unknown name "headerValues" at 'requests[0].update_sheet_properties.properties'

1

However I tried to add header values to a sheet, I get this error. ``` { code: 400, message: `Invalid JSON payload received. Unknown name "headerValues" at 'requests[0].update_sheet_properties.properties': Cannot find...

kbariotis

Implement Sort range

2

Implements the sortRange() method. I implemented a shorthand for the sortSpecs, but that can be changed if needed. Also, I should probably add docs about this somewhere.

cincodenada

addRow type is not properly defined in @types/google-spreadsheet

1

TS Error: Property addRow does not exist on type GoogleSpreadsheet

denisatfn

Developer metadata

1

How do you add\read\update\delete metadata using this library?

sergey-shablenko

Support getRangeByName()

4

Please add support getRangeByName(named_range)

alberttra

Is it possible to update formatting options of google sheet?

1

I know this is a very far fetched question. But still, I would like to know. I want to do Formatting -> Text Wrapping -> Wrap through the code. Is...

ramseth001

Saving a column to all empty values throws a TypeError error

3

I am trying to save a row with all empty records. However, the `save()` function in GoogleSpreadsheetRow.js has this at the very end: this._rawData = response.data.updatedData.values[0]; Since there are no...

lilsweetkara

Service Account security issues

1

## Context I was testing this Google spreadsheet package and I realized I could make use of my service account. After setting up my config I was playing around with...

supasheva