search

jpillora / node-edit-google-spreadsheet

A simple API for editing Google Spreadsheets
304 stars 101 forks source link

How to get value from cells that use vlookups or formulas #107

Closed CoinCoderBuffalo closed 6 years ago

CoinCoderBuffalo commented 6 years ago

Some of the cells I need to read use formulas to compute the value.

Problem is they are coming back like this:

'7': '=vlookup(C2&A2,\'counts by product\'!R2C[-6]:R2001,5,0)', '8': '=if(E2>0,G2/E2,0)', '9': '=vlookup(C2&A2,\'counts by product\'!R2C[-8]:R2001,6,0)',

How can I get the value and not the formula?

CoinCoderBuffalo commented 6 years ago

spreadsheet.receive({ getValues: true}, function (err, rows, info){ // do stuff })