jpillora / node-edit-google-spreadsheet

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

=concatenate(S2,T2,U2) instead of actual value #62

Closed przemyslawpluta closed 9 years ago

przemyslawpluta commented 9 years ago

After getting the spreadsheet from google instead of getting the actual text visible in the cell I'm getting the action that is used to produce its content. Is there a way to receive just the text?

{ '1': 1,
     '2': 'name',
     '3': '=CONCATENATE("new item ",B2," & ",C2)',
     '4': 00000012,
     '5': '=CONCATENATE(A2,"_",G2,"_",H2,"_",I2,"_",J2)',
     '6': 1,
     '7': '=concatenate(S2,T2,U2)',
     ...
}
`` 
jpillora commented 9 years ago

There is, it's abit hidden though.

spreadsheet.receive({getValues: true}, callback( err , rows , info ) ) {
  //...
});
przemyslawpluta commented 9 years ago

Thanks.