node-google-spreadsheet

node-google-spreadsheet copied to clipboard

cell backgroundColor doesn't work as expected

3

Node version: v16.13.0 NPM version: 8.1.0 Package version: 3.3.0 What I do, cell.backgroundColor = { alpha: 1, red: 234, green: 179, blue: 138 } Color I expect to get: #EAB38A...

nonacc

set backgroundColor for the new row

2

Hello, I am trying to add backgroundColor when the new row creates, but I can't make it work. I was able to set backgroundColor when I make some cell updates...

y-maslouskaya

There is a TypeError saying URL is not a constructor, from gaxios dependency. Someone please help me.

14

I have used google-auth-library, JWT auth for auth. Just yesterday it was working, today it is not. https://theoephraim.github.io/node-google-spreadsheet/ Followed everything that was there in this docs. Also I’m using nextjs.

ManojaD2004

sheets.useServiceAccountAuth is not a function

1

I am using this code from last year but after some updates in library it shows useServiceAccountAuth is not a function ``` const { GoogleSpreadsheet } = require("google-spreadsheet"); const creds...

VasuDev8110

feat(worksheet): enable add data validation call

1

closes https://github.com/theoephraim/node-google-spreadsheet/issues/566 example of using it to create a dropdown field in screenshot: 

uladkasach

fix documentation typo

guilhermemalfatti

Error: Request to googleapis.com/oauth2/v4/token Failed When Using Google Spreadsheet npm Package with VPN in China (Works Fine in Morocco)

1

I'm currently working on a project where I need to access Google Sheets using the google-spreadsheet npm package. Due to restrictions, I'm based in China and using a VPN to...

Adoo2401

theoephraim

How can I handle for example a socket hang up error ? Thanks.

cipas

Question: How to force load cells?

1

Currently, using `loadCells()` will discard some columns if the first cell in the column is empty. Example below:  doing `await sheet.loadCells('A1:C4');` would only load the first 2 columns. How...

Tiffceet