node-google-spreadsheet

node-google-spreadsheet copied to clipboard

autoResizeDimensions is not supported

1

I tried to call autoResizeDimensions(), but it does not adjust any columns in my sheet.

tonprince

Error trying to use in a Cloudflare Pages

4

I deployed my app to Cloudflare page but got this error ``` TypeError: globalThis.XMLHttpRequest is not a constructor ``` I think it's because Cloudflare uses Fetch API instead of XMLHttpRequest....

HuyAms

Keeping formatting in text cells

6

Hello ! First, thanks for this module, it's very handy and the documentation really helped me understand how to fetch a gsheet for my app. I have a question though...

AxelTerizaki

Delete Dimension

3

I was trying to delete some rows, but it didn't work for me, on spectating the function in the core file i.e GoogleSpreadsheetWorksheet.js I found out that is a void...

ahmedrizwan239

Save a formula or any string which starts with `"="` as a string using the cells-based interface

1

Hi @theoephraim, There is currently no way to save a formula or any string which starts with `"="` as a string using the cells-based interface. I think that if we...

miron1512

TS thinks the return type of `GoogleSpreadsheetRow<Row>.get("Column")` is `any` rather than `Row["Column"]`

3

That's pretty much it; it's probably because the type signature of `GoogleSpreadsheetRow.get` is `(key: keyof T) => any` rather than `(key: K) => T[K]` or similar. I could open a...

ryanscottaudio

addRow doesn't work if filter applied

1

If Sheet has any filter applied - so addRow (append) method does nothing. It returns OK, but actual data is not added to the sheet.

konser80

make it east to get/set dates, and handle date formatting.

theoephraim

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#repeatcellrequest

theoephraim

insert row at specific index

2

I am using `insertDimension` to insert row on top on my sheet, but unable to comprehend `range` in the documentation. An example would be appreciated. Thanks This is what I...

pravinfullstack