[R] Saving Google worksheets with common prefix

Jennifer Sabatier plessthanpointohfive at gmail.com
Fri Nov 21 17:02:05 CET 2014


On Fri, Nov 21, 2014 at 10:36 AM, Henrik Bengtsson <hb at biostat.ucsf.edu>
wrote:

> print(ts2$i)



You're right.  It's not doing what I think it's supposed to be doing.  The
print(ts2$i) gives NULL:


[1] "Cash Flows211"
NULL
[1] "Cash Flows211 - 2014-11-21.csv"
7: getURL(sheet at cellsfeed, curl = getCurlCon(con), followlocation = TRUE)
6: getCells(sheet, con = con)
5: xmlParse(getCells(sheet, con = con))
4: xpathApply(doc, path, fun, ..., namespaces = namespaces, sessionEncoding
= sessionEncoding,
       addFinalizer = addFinalizer)
3: getNodeSet(doc, "//a:entry/gs:cell", c(a = "http://www.w3.org/2005/Atom",

       gs = "http://schemas.google.com/spreadsheets/2006"))
2: processCells2(doc, trim, header, as.data.frame, stringsAsFactors =
stringsAsFactors)
1: sheetAsMatrix(ts$i, header = TRUE, as.data.frame = TRUE, trim = TRUE) at
#7
Error in getURL(sheet at cellsfeed, curl = getCurlCon(con), followlocation =
TRUE) :
  trying to get slot "cellsfeed" from an object of a basic class ("NULL")
with no slots

So, I've got to figure out how to feed that list of names properly.

Thanks!

Jen

	[[alternative HTML version deleted]]



More information about the R-help mailing list