[R] Physically open Excel file from R

S Ellison S.Ellison at lgc.co.uk
Mon Feb 8 15:03:38 CET 2010


where 'file.xls' is the excel filename.

The escaped quotes (\") are not strictly necessary if the filename contains no spaces, but they are essential if it does.

>>> Sergey Goriatchev <sergeyg at gmail.com> 08/02/2010 12:48:20 >>>
Hello, everyone

I wonder if it is possible to PHYSICALLY open an Excel file from R.
The reason I ask is, I produce regularly an Excel file in R, and then
I want to make it look good, so I have a VBA routine in another Excel
file that works on the regular Excel file.
This formatting file executes VBA code on open, so all I need to do is
physically open it (no reading/writing at all). I wonder if that can
be done from R, so that I do as little as possible manually.

Thanks in advance for help!
Simplicity is the last step of art./Bruce Lee

Kniven skärpes bara mot stenen.

R-help at r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html 
and provide commented, minimal, self-contained, reproducible code.

This email and any attachments are confidential. Any use...{{dropped:8}}

More information about the R-help mailing list