R help - Jun 2016 - Writing a formula to Excel

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

Hi,
I don't have excel.link, but have you tried:

"=G9*100/G6\n"

Jim

On Thu, Jun 30, 2016 at 10:34 PM,  <G.Maubach at weinwolf.de>
wrote:
> 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
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.