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@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.
______________________________________________
R-help@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.
