node-google-spreadsheet

node-google-spreadsheet copied to clipboard

Is it possible to add ConditionalFormatRule?

1

I'm trying to add a conditionalFormatRule to a sheet/worksheet, and I'm unable to find a method to do this. Is it possible? If not, how can I change the color...

manueljpeixoto

It occurred while confirming the operation with IE11. Generated content SCRIPT1010: Missing identifier. Read part /***/ "./node_modules/google-spreadsheet/index.js": /*!**************************************************!*\ !*** ./node_modules/google-spreadsheet/index.js ***! \**************************************************/ /*! no static exports found */ /***/ (function(module,...

HiroNoobs

Support for retrieving value from rows interface

1

Thanks for the library, it's been so useful. I love the Spreadsheet Rows interface for it's simplicity. But from time to time I need to drop down to the cell...

chrisjensen

Hi @theoephraim , It would be good if you implement the set(remove or ignore) google spread sheet filters programatically. This is my request for you. Thanks.

vinodhreddygs

Support for batchGet API

2

Hi, is there going to be support for [batchGet](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet)? We need that because we have 200+ worksheets to grab from, and google is triggering its API rate limit errors. BatchGet...

ilyasfoo

Escaping cell values starting with =

2

Setting a value starting with '=' using cell.value setter is treated as a 'formulaValue' valueType. Escaping it by myself by adding a single apostrophe is enforcing it to being treated...

Baraksi

Deleting method is not the same as deleting row manually in the web browser

8

Hello everyone! my issue is an aesthetic kinda issue. I prepare some screenshoot to help my self to explain the problem Here you can see in the first screen shoot,...

NewCoderOnTheBlock

Hello everyone. I am trying to deleting a row with google sheet. Here's the following code: ```ts let rows: GoogleSpreadsheetRow = getSomeRows() let row = rows.filter(...) await row.delete() ``` The...

NewCoderOnTheBlock

Retrieving a row and adding it into another character sheet tab does not carry its properties.

3

Hello everyone, so here's my code ```ts let rows: GoogleSpreadsheetRow = getSomeRows() let row = rows.filter(...) let index = (await this.memo.addRow(row)).rowIndex addborders(this.memo, index, 0) ``` You can see the task...

NewCoderOnTheBlock

I used google-spreadsheet to create new spreadsheet. Below is my code. ` import { GoogleSpreadsheet } from 'google-spreadsheet'; const doc = new GoogleSpreadsheet(); await doc.useServiceAccountAuth({ client_email: config.googleSheetAccount, private_key: config.googleApiPrivateKey, });...

bumjun-kim