[R] Getting value rather than formula in RGoogleDocs

[Duncan Temple Lang]

Farrel Buchinsky wrote:
> Is there an easy way to read the value of the cells rather than the formula?So
> for instance in a cell whose value was created by simply using the value
> from the cell immediately to the left in the Google spreadsheet I would
> prefer to get the value rather than  =RC[-1]
> 
> When one exports with Google Spreadsheets as a csv then that does not
> happen.
> 
> I am using the following line of code in R
> y2009<-sheetAsMatrix(ts2$y2009,header=TRUE, as.data.frame=TRUE, trim=TRUE)
> 

When I create a sample spreadsheet with formulae in cells
and then retrieve it with RGoogleDocs, I get the values
not the formula.  So I'll need a sample spreadsheet
from which you get the formula and not the value.

   D.


> 
> Farrel Buchinsky
> Google Voice Tel: (412) 567-7870
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.