An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120211/2f54d5dd/attachment.pl>
Embed R code in online database
2 messages · Jokel Meyer, Barry Rowlingson
On Sat, Feb 11, 2012 at 5:49 PM, Jokel Meyer <jokel.meyer at googlemail.com> wrote:
Dear R-List! I would like to embed R code in an online database such as i.e. a google spreadsheet in way that users can add data to the database and that R's calculations are updated automatically and i.e. given out in the spreadsheet. Maybe even graphs could be updated online? Is there a way to implement this?
There's no way to integrate R into a google spreadsheet as tightly as, say, letting you put R expressions into formulae for cells. There's also, I think, no way to trigger an external action when a spreadsheet is modified or saved. So, I think the only thing you can do, is to periodically check if the spreadsheet is modified, run an R script, and upload the modified data to Google. I'm not sure what the current state-of-the-art interface from R to google docs is. Maybe http://r-forge.r-project.org/projects/rgoogledata/ Barry