[R] Writing a formula to Excel
G.Maubach at weinwolf.de
G.Maubach at weinwolf.de
Thu Jun 30 14:34:28 CEST 2016
Hi All,
I am using excel.link to work seemslessly with Excel.
In addition to values, like numbers and strings, I would like to insert a
full operational formula into a cell.
xlc["G14"] <- print(paste("=G9*100/G6"), quote = FALSE)
The strings is put into the cell, but the cell is not evaluated. Thus the
string is show as result of the computation.
If I open that cell b pressing "F2" or by double-clicking the cell and
pressing RETURN will start the evaluation of the expession.
xlc["G14"] <- parse("=G9*100/G6") # does not run
How can I put a formula into Excel that is evaluated right away?
Kind regards
Georg
More information about the R-help
mailing list