R help - Aug 2011 - Capture R-Console Output to Excel with RExcel

Hello All

I've just started to use RExcel instead of CMD Batches. But I don't get
the console output to an data.frame and push to Excel.

With the CMD batch you got the console out relatively easy with

C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile%

to a file. But how can I get it to Excel with RExcel an VBA?

Thanks,
Dario

	[[alternative HTML version deleted]]

On Aug 11, 2011, at 7:46 AM, Meier Dario wrote:
> Hello All
>
> I've just started to use RExcel instead of CMD Batches. But I don't
> get
> the console output to an data.frame and push to Excel.
>
> With the CMD batch you got the console out relatively easy with
>
> C:\LocalData\R\bin\R CMD BATCH --slave %rscript% %logfile%
>
> to a file. But how can I get it to Excel with RExcel an VBA?
I am guessing that either sink()  or capture.output() with the  
"clipboard" as the destination file should work. It's just a
character
stream, right? Cannot test since I'm on a different OS. You will  
undoubtedly need to process further, perhaps with the "import text to  
columns" using the fixed-width format panel since console output will  
not be tab delimited.

(There is also an RExcel Mailing list, although this doesn't really  
seem like the issues involved depend on RExcel.)

-- 

David Winsemius, MD
West Hartford, CT