[R] Creating an Excel file with multiple spreadsheets

Whit Armstrong armstrong.whit at gmail.com
Mon Mar 9 22:23:21 CET 2009


if you don't find the solution you need, I have a package that uses
Apache POI to do this, but you will need to compile it yourself.

contact me if you want to go this route.

-Whit


On Mon, Mar 9, 2009 at 3:34 PM, Patrick Connolly
<p_connolly at slingshot.co.nz> wrote:
> On Mon, 09-Mar-2009 at 02:34PM -0400, Jorge Ivan Velez wrote:
>
> |> DeaR all,
> |>
>
> |> I'd like to know how to create an Excel file with multiple
> |> spreadsheets from R. I searched the help files and found [1] but it
> |> is not what I want to do.
>
> I use the Perl script from Marc Schwartz in that list.  It's very
> useful.  I think if you can work out the R code to make the dataframes
> you want, it's a matter of using write.csv() to make the CSV files that
> the Perl code can use.
>
>
>
> |>
> |> [1] http://tinyurl.com/aurprr
> |>
>
>
> --
> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
>   ___    Patrick Connolly
>  {~._.~}                   Great minds discuss ideas
>  _( Y )_                 Average minds discuss events
> (:_~*~_:)                  Small minds discuss people
>  (_)-(_)                              ..... Eleanor Roosevelt
>
> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
>
> ______________________________________________
> 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