node-google-spreadsheet

node-google-spreadsheet copied to clipboard

Module not found: Can't resolve 'child_process'

1

I am trying to save form data to a spreadsheet in Next.js but I keep getting this error which appears as soon as I import `google-spreadsheet` Error Bellow is what...

dieudonneAwa

Error: Cannot read property 'rowCount' of undefined for google spreadsheets that contain Chart sheets

1

Using a multi-tab spreadsheet that contains a chart as one of the tabs: Example code: ```js function getCells(worksheet) { const { title, index } = (worksheet || {})._rawProperties try {...

johnbeech

Single quotes being added to DATE at the beginning in spreadsheet

5

Hi @theoephraim , When **Dates** are added to the spreadsheet they are preceded with a ' but this should not happen. Is there any way to prevent by adding '...

vinodhreddygs

I would like to set verticalAlignment and wrapStrategy defaultFormat is in GoogleSpreadsheet ``` GoogleSpreadsheet.defaultFormat = { verticalAlignment: 'TOP', wrapStrategy: 'WRAP' }; ``` Says not to try and set directly, fair...

macasas

Date is storing has a String

7

Hi @theoephraim , When ever I try to store EST date (like 06/19/2020) in the sheet cell, it stores as `String format using cell based API` but` if try to...

vinodhreddygs

Getting value of merged cells having one of the cells

3

Hey guys! I have some cells merged in the range B2:B6. I got one of the cells using `getCellByA1`: ``` const cell = sheet.getCellByA1('B3') ``` Is there any way I...

LeoDoldan7

Check API status / Automated retry logic

5

Hello! Is it possible to check the API status? How? For example how many request are made, if i have other available requests, the rate limit per hour, etc? Thank...

Romans96

using loadCells with GridRangeObject. Data inside GRO seems to get "lost"

4

*** post complete *** So I have trapped the uncaught error, and am writing this from the output: the stack looks like (top at the top): ``` (anonymous) arrayEach forEach...

christopherreay

Add toJson functionality for SpreadsheetRow objects

2

Functionality that would convert the instance of SpreadsheetRow to just it's data with the signature [columnname]: value would be super helpful

davidholyko

row.delete() not working on data from google forms

1

I seem to be having an issue with row.delete(); here is my code ```const config: processType = await configData(); let temp = row; if (temp['Last Live (GMT)']) { if (temp.Status...

physk