[R] Physically open Excel file from R

Uwe Ligges ligges at statistik.tu-dortmund.de
Mon Feb 8 13:56:12 CET 2010

On 08.02.2010 13:48, Sergey Goriatchev wrote:
> 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.

If you are under Windows and Excel is installed properly,


should do the trick.

Uwe Ligges

> Thanks in advance for help!
> Regards,
> Sergey
> --
> Simplicity is the last step of art./Bruce Lee
> Kniven skärpes bara mot stenen.
> ______________________________________________
> R-help at r-project.org mailing list
> 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.

More information about the R-help mailing list